Re: Searching text fields

Posted in 2000

Obnoxio The Clown — Thu, 04 May 2000 12:36:20 BST — source: Informix-list mailing list archive (1991-1998)

From: Kief <kief@bitbull.com> > >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? Two things spring to mind: 1. "Arrays" of CHAR(80)? :0) 2. Informix 9.x with a text datablade. (Which is probably more elegant! :) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com