Re: TEXT type / querying

Jeroen Keppens said: > Hi, > > we need to store plain text in a table with possibility to search on it. > > New to Informix, I had a look at the text character types. A > LVARCHAR(4000) is too small (largest text atm 118K), so we need > another solution. I thought about using the TEXT type, but apparently > you can't do queries (LIKE) on that. > > What is usually used for this? How do you query on it if TEXT? http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_multirep.html I'm sure you can wrap an ETX or other text search datablade around it. -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent."