Re: Doing case-insensitive searches

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