Re: [Q] LOCALE and ORDER by char field

Step 1: upgrade! You are using version 5.0x, and that is not NLS aware (NLS = National Language S[upport?]) and only ever sorts in character code order. The ALS (Asian Language Support) versions handle multi-byte characters and complex collation sequences, but the standard products are 8-bit clean and do not support custom collation sequences -- unless it was added to a late release (say 5.04 or later) and I didn't notice it. With versions 6.0x or 7.[01]x, set one or more of the LANG, LC_COLLATE, DBLANG, DBNLS, COLLCHAR environment variables to create an NLS aware environment. If the locale is set up OK, it will then sort correctly. Be very careful -- you may not need to set all of these, and there may be some other environment variables you should set, and the subject is confusing. Read the manuals carefully. If you wait for 7.20 or later, that should be GLS (Global Language Support) aware, but I don't know when a Cyrillic locale will be available. Have fun... Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: "Leonid Belov" <white@intek.spb.su> >Date: 3 Jan 1996 19:44:50 +0300 >X-Informix-List-Id: <news.20013> > >I use INFORMIX-OnLine 5 under SCO 3.2-4.2. >Character data stored in ISO-8859-5 encoding (cyrillic character set). >When I issue SELECT with ORDER BY character field, >server sorts data according to character codes. >Of course, I need to sort them in the alphabetical order. > >Can anyone help me to tune environment? > > Leonid