"text search" for a blob

[linda]

We have a requirement to store combined image/text data in the database
and provide the ability to search for text in this blob.

The only solution i have found is to use a stored procedure called wp_stores_update which will generate a web page from a row in my table.

This page is stored in the file system and the index server picks it up.

I would prefer not to have to store the data in the database and the filesystem.

Can anyone provide any ideas here? There is a long reason behind storing the data in the database.....

[Carly]

Have you looked full-text search under SQL 7. see Books on Line search for Full-Text
If your blob is of a Text data type then you can use this.
Note there is a limit on the text that is searched (I can't remember if the limit is 160K or something, however this can be changed in the registry, search http://search.support.microsoft.com/kb for this.)


------------
linda at 9/13/00 2:25:58 PM


We have a requirement to store combined image/text data in the database
and provide the ability to search for text in this blob.

The only solution i have found is to use a stored procedure called wp_stores_update which will generate a web page from a row in my table.

This page is stored in the file system and the index server picks it up.

I would prefer not to have to store the data in the database and the filesystem.

Can anyone provide any ideas here? There is a long reason behind storing the data in the database.....