if you are willing to look at a commercial component
look at rubicon at tamaracka.com


Regards
gk


------------------Original Message-----------

From : "Jonathan Hull" <jono@...>
To : firebird-support@yahoogroups.com
Date : 14/07/2004 5:30:39 AM
Subject : [firebird-support] Case-insensitive 'containing' on a BLOB - perhaps UDF?

Hi all,
I would like to do a case insensitive string search on a binary blob
(eg a stored Word Doc file), preferrably using standard SQL.

My research indicates this is not possible in IB6, FB1 or FB1.5.

Does anyone have a strategy that works in FB1.5? Perhaps a UDF
function? The only other approach that I can imagine (after a strong
coffee) would be to tokenise the text on the way in so each BLOB has a
corresponding text field containing keywords, but this seems a pretty
high overhead.

All comments will be very welcome.

Also, if your listening Helen, I can't wait for the word on your (even
bigger) bible to become available.

Cheers from New Zealand
Jono.





Yahoo! Groups Links

>>> This mail is created in Hamsa (www.jlmatrix.com) <<<