S
steve pittman
Guest
On 4/1/2015 7:33 AM, Andrzej_Sz wrote: SQL Order By in UTF-8 database Thread created by Andrzej_Sz "SELECT ... ORDER BY table.name" in my OE 10.2B UTF-8 database puts national names at the end of the list. How to achive the right order of the records like in "FOR EACH ... BY table.name" 4GL phrase ? Stop receiving emails on this subject. Flag this post as spam/abuse. For OpenEdge sql, the order of character data in ORDER BY is determined by the database collation. Since you observe "national names" at the end of your result set (from SELECT), it sounds like your db collation is probably the default BASIC collation. There are a number of UTF-8 collations that are more locale specific and that would probably give you the ordering you want (or close to what you want). These collations are in the OE installed directories, usually in $DLC/prolang/utf . These are described in the OE Internationalizing Applications book that is available online . Basically, to use a different db collation, you would first determine a collation that works for you, then load the .df for that collation into the db, and then do an index rebuild so all the indexes with character data get rebuilt. This is just a very brief overview - please check out all the very important details. This is a non-triivial process to be very carefully done of course! Once the database collation is all setup your SELECT will automatically use it. hope this helps, ....steve pittman [OE sql software architect]
Continue reading...
Continue reading...