Re: Case insensitive search

clema@informix.com (Clem Akins) wrote: :Nils says: :>1. It is one of the features of the Universal Server. You can index on :>any function. : :That's part of what we mean by "extensible", and "universal." And only one small out of many reasons that will make "everybody" want to have this engine. (At least most would be able to add important new functionality to virtually any application using some new functionality in IUS.) :>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. : :It's even better than that! Get this: you can write your *own*! So :now, from the vendor side, we get to wait and see what *you* do about it! ...snip fine explanation relating to IUS... Yes, all that is excelent. My statement did however relate to pre IUS engines. Someone said the UPPER funtion would be included in the normal DS engines. My statement was only that Informix had been told that to include the UPPER (and/or lower) function in that engine would not be too helpfull if it wasn't also possible to create indexes on the function. In IUS that is of course no problem, as it is also no problem to create indexes on any other function, including those you have written yourself. Someone did by the way say that the upper/lower (and other) functions that can be used in Oracle for searches could not be used for indexing. Prety bad implementation if you ask me. Actually next to useless. But what can you expect. My point is that Informix at least know about the problem, have a solution in IUS, and we will have to wait and see what they do in the next version of 7.x. 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