Re: Searching inside text blobs

In article <3518ADFB.D815A32@gd.srg-ssr.ch>, Pascal Dreer <Pascal.Dreer@gd.srg-ssr.ch> writes >Hi, > >I use the Informix OnLine 7 DB to store text messages which vary between >1 and >15KB in size. They are stored as TEXT datatype in a Blob space. >Everything works >fine except that I'm not able to search these messages for text strings. >According to >the manual you can only test TEXT or BYTE datatypes only for null. > >Is there any other way to search text inside a TEXT blob ? > Not within Informix, you need a full-text database e.g. BRS/Search sold by dataware www.dataware.com ... >Any help is appreciated, >Pascal > >Pascal.Dreer@services.srg-ssr.ch > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care