using CONVERT to search binary documents 
Author Message
 using CONVERT to search binary documents


We are planning to store Word for Windows documents within our Sybase
database.  We will also need to search these documents for certain strings.
One of the programmers used the following method to search:

FROM my_table
WHERE LOCATE( convert(long varchar, blob_column), 'search string') > 0

My question: Is this logically equivalent to a

WHERE blob_column LIKE '%search_string%'

Given that we want to search a binary document for certain strings, is this
a way to do it?  Anyone else done this?
Dan Langille
DVL Software Limited - Wellington, New Zealand

Mon, 23 Nov 1998 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. converting xml documents to html documents

2. Question about converting XML documents to ADO Recordsets using dbadapt.dll

3. Using SQL2000 as a document search engine

4. How to write Memo BLOB to DB using ADO -- how to convert binary to VARIANT

5. Converting values to binary using PL/SQL

6. Search documents using Ingres 2 ??

7. Searching Word Documents with Full Text Searching

8. Storing Excel document in a binary field

9. Extract documents from databse and convert to PDF

10. Trying to convert word documents for loading into SQL 7

11. convert web form to MS word document and save to database

12. convert web form to MS word document and save to database

Powered by phpBB® Forum Software