Re: Case-Insensitive search

Richard responds: >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. There are functions such as UPPER and LOWER that allow case insensitive searches in 7.3, and simulations of these functions available from the IIUG site at http://www.iiug.org . >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. Functional indexes are available with the UDO option, but not without. That is, not in 7.3. >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). I don't have the statistics on it "real world", but the Q&A suite that the 7.3 and 9.2 products are subject to is the most comprehensive that Informix has every devised. We have all learned a great deal from the past. _____________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Manager Informix Software, Inc Last seen: Picnicking on the beach at Point Reyes, California