Re: Case-Insensitive search

Posted in 1998

Richard Stanford — Wed, 20 May 1998 17:36:10 -0500 — source: Informix-list mailing list archive (1991-1998)

iftikhar_khan@mailcity.com wrote: > Can we make a case insensitive search in Informix? Bear in mind that making a search case insensative (there are already several posts on possibilities) invalidates any index you happen to have on the column. Just a thought. Out of curiosity, does 7.3 allow indexes on functions? I thought that at one point it was supposed to -- filed the nifty specs in the trash when I got them though as we're not ready to certify on it yet. Out of more curiosity, how buggy is it? In the Real World, I mean (frequent 100% utilization on large SMP machines, esp. HP and IBM). -Richard