TEXT type / querying

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? Thanks for the info, Jeroen

Jeroen Keppens wrote: > 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? Which version of IDS? IDS 11 has the BTS (Basic Text Search) DataBlade - as well as the not so basic text search datablades. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-3005 whirlpool2 2008-04-15 03:00:07 081C8496AC58D368CCDAE3AA3F21C3AA50A110BCD6809620A6141494870C633B98ECBA 2A7CE8A386AEF8370DF9F770B775F095A06311A00217CEB96DD294AC0