Re: Case insensitive sorting

Posted in 1996

Kerry Sainsbury — Sat, 25 May 1996 22:40:15 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <31A2D9CE.EBF@strengur.is>, Snorri Bergmann <snorri@strengur.is> wrote: >Kerry Sainsbury wrote: >> >> In article <4ni41c$pg0@ns5-1.CC.Lehigh.EDU>, jaf0@Lehigh.EDU wrote: >> >Is there a way to get an Informix database to ignore case when sorting >> >(the ORDER BY clause in a SELECT statement). Is it possible to do this with >> >the NLS features? >> >> Succinctly: No. >> There are some "creative" solutions in the FAQ (see my signature) but the >> best thing you could do is ring your local Informix office and ask them >> how it can be done. >> > >This can actually be done with nchars and nvarchars using the lang environment >LANG=mylang.88591@nofold Aha! The *intuitive* approach :-) Sometimes I just feel so silly when I miss the obvious answers... Thanks! Kerry S >Hope this helps It did, for Online users, I guess. We've just installed an Online Engine, so I guess it's about time I got out the docs and started reading. Sigh. ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/