Re: Upper/lower case in version 7

Marek Konopka wrote: > > We are moving our database to Informix 7. > How can we set that the upper and lower case letters in queries should be > treated the same (i.e. 'ibm'='IBM'='Ibm')? > Is there an parameter/option when you create a database? > If not should we use a function like UPPER in all our queries or should we > define a conversion file (in the GLS)? > Which solution is the most efficient? None of the above. Add a column to the table containing the key in all upper case or all lower case for searches. It is the only way until 7.3 or Universal Server. Art S. Kagel