Searching text fields

Posted in 2000

Kief — Thu, 04 May 2000 08:55:16 GMT — source: Informix-list mailing list archive (1991-1998)

Is there any way to search a column of type TEXT in Informix? From the documentation the answer appears to be no, so my next question is: how can you have a searchable column which can hold more than 255 characters, other than the incredibly space-wasting CHAR (n) type? Thanks, kief Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Kief

Edward Rosenthal — Thu, 04 May 2000 16:38:36 GMT — source: Informix-list mailing list archive (1991-1998)

if you have the lvarchar datatype you can still use like and matches on the text. and you have a very large amounts of data you can store there, up to 32K. Kief wrote: > Is there any way to search a column of type TEXT in Informix? > From the documentation the answer appears to be no, so my next > question is: how can you have a searchable column which can > hold more than 255 characters, other than the incredibly > space-wasting CHAR (n) type? > > Thanks, > kief > > Sent via Deja.com http://www.deja.com/ > Before you buy.

↪ replying to Kief

cgrandy@disc.com — Wed, 24 May 2000 19:36:55 GMT — source: Informix-list mailing list archive (1991-1998)

One option to look into is the advanced indexing technology of OMNIDEX from DISC (Dynamic Information Systems Corporation). (Attention: Promotional information follows. Please disregard if not interested in another solution.) OMNIDEX uses specialized Multidimensional Keyword Indexes to deliver full text searches, and unlimited multidimensional analysis by any number of criteria or attributes. OMNIDEX layers on top of your existing database, and it supports numerous databases and document files, including Informix, Oracle, SQL Server, Sybase, flat files, HTML and Word documents. OMNIDEX is ideal for ad-hoc querying, it works well for both high and low cardinality data, and is very efficient in terms of build time and disk space. How much OMNIDEX can help depends on your needs and environment. If you would be interested in a free performance analysis or more information, please contact me. Cheryl Grandy DISC cgrandy@disc.com 303 444-4000 www.disc.com/home OMNIDEX - for the fastest applications ever! In article <8erdtf$b1d$1@nnrp1.deja.com>, Kief <kief@bitbull.com> wrote: > Is there any way to search a column of type TEXT in Informix? > From the documentation the answer appears to be no, so my next > question is: how can you have a searchable column which can > hold more than 255 characters, other than the incredibly > space-wasting CHAR (n) type? > > Thanks, > kief > > Sent via Deja.com http://www.deja.com/ > Before you buy. > -- Cheryl Grandy DISC Get OMNIDEX for the fastest applications ever Sent via Deja.com http://www.deja.com/ Before you buy.