Re: Case insensitive search

Jacob Salomon <jake@apparel.net> wrote: :Glenn Travis wrote: : :> ODS 7.3 (ship Q1 '98) will have this plus LOWER, plus Enterprise :> Command Center (for unix), plus a WHOLE lot more... Ask your Informix :> rep for more info... : :Ah yes, finally after all these years of asking for it! Somehow, I'm :sure there's a "however" coming up... : :Here it is: : :However, I suspect we will still not be able to index against :UPPER(name), because the key value in the row would not match the key :value in the index entry. This means that a case insensitive search :would still be as slow as [I've heard] the Oracle case-insensitive :search is. Still, it would be no worse than Oracle in this matter. :(Some selling point! ;-) And the capability would finally be there. So :let's give it .. well, 2 cheers! (way to go. yay.) : :If I recall correctly, the ability to index on a function of a column :[like UPPER() or LOWER()] exists only in XPS (maybe in Universal Server :as well?) : :Corrections anyone? 1. It is one of the features of the Universal Server. You can index on any function. 2. They have been told that it's not much use to be able to search on upper if there is no way to index on the function. We will have to wait and see what they do about it. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org