No, it is not possible to search inside a BLOB field...
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Jan 2, 2007, at 11:34 PM, Giovanni wrote:
Thanks Marco,
Is it possible to do a search in the item inside the blob tho?
In the case of our resumes, I need to be able to do a query on the
actual documents sitting inside the blob.
Marco Bambini wrote:
SQLiteProPlugin was based on the old sqlite 2 engine which didn't
support binary data.
The new sqlite 3 engine (the one under the REALSQLDatabase) fully
supports BLOB data.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Jan 2, 2007, at 10:36 PM, Stefan wrote:
Am 02.01.2007 um 22:11 schrieb Giovanni:
I am porting or atleast planning on porting an App to RB that I
need it to query the blob record.
Simply, I have resumes that we have saved in a blob field. The
resumes are in MS WORD format and I need to query the actual
information in the blob field. How possible, and feasible is it
to do such a query.
In the past, I tested a photo asset management solution in RB
an SQLiteProPlugin.
While - in general - the system seemed to work, I found serious
problems
regarding mass-importing the contents of a folder. Don't ask for
details. Can't
remember right now.
I don't say it's impossible, I just want to propose early stress
testing - in case
mass importing and such like is of interest.
I'm pretty sure, that SQLIte would be 'strong' enough.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
