Re: Effect of Locale on character sorting order?

If you want locale-aware sorting, you need locale-aware software. That means either Version 6.00 or later (which supports NLS -- national language support) for 8-bit character-set support, or ALS (Asian Language Support) for handling Japanese etc (several versions, including 4 and 5), or GLS (Global Language Support) available in version 7.20 -- still to be put on general release. 5.0x is not locale aware, and probably never will be. It does handle 8-bit characters (as you point out), but it sorts using straight numeric comparisons of the character codes. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: I presume you are referring to 5.02 -- there is no 5.2 software. >From: andy lennard <andy@kontron.demon.co.uk> >Date: Thu, 22 Feb 96 07:52:03 GMT >X-Informix-List-Id: <news.21431> > >I would appreciate you assistance regarding internationalisation. >I run Online v5.2 on Sun SunOS4.1.3. I need to 'go international'! > >I can put iso_8859_1 characters into CHAR fields in a table but then >when I SELECT with an ORDER BY on that field, the results aren't >what I expect. > >Have I any control over the sorting order? If so, can the control be >specified from the front-end, or is it embedded within the database, >or sqlturbo?