Re: Doing case-insensitive searches

Art S. Kagel wrote: > > Lisa Retief wrote: > > > > We have just discovered that Informix will only do case-sensitive searches, > > which is a huge problem for a project we are working on. It is possible to > > do a match using syntax such as [A][a] etc, but then the table indexing is > > of no use to us and such searches are far too expensive. Has anyone come > > across a solution for this dilemma? Is there a way to set an Informix > > database to be case-insensitive. > > > > I would appreciate any input. Please respond via email where posible. > > Version 7.30+ can do case insensitive searches and 8.30+ can build case > insensitive indexes as can 9.xx+. If you cannot upgrade do the old > store the data in all upper or lower case in an additional column or > a lookup table. > > Art S. Kagel Can someone tell me how to carry out case insensitive searches as described above? I'm on IDS 7.30.UC3 Many thanks, Ollie -- Oliver Wardman Pesticide Usage Survey Central Science Laboratory Sand Hutton York UK Y041 1LZ Tel: 01904 462 588 Fax: 01904 462 253 Web: http://www.csl.gov.uk/environment/level3/pusg.htm