Re: Case insensitive sorting

Posted in 1996

Snorri Bergmann — Wed, 22 May 1996 09:09:34 +0000 — source: Informix-list mailing list archive (1991-1998)

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 Hope this helps -- Snorri Bergmann | Mail: snorri@strengur.is Strengur Consulting Engineers | WWW: http://www.strengur.is/ Armuli 7 | Phone: +354 550 9000 (9007 direct) 108 Reykjavik Iceland | Telefax: +354 550 9010