ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting order of foreign languages (https://www.excelbanter.com/excel-discussion-misc-queries/248340-sorting-order-foreign-languages.html)

Jonathan

Sorting order of foreign languages
 
I have a problem in sorting some data based on Japanese Kanji.
I tried to sort in Japanese Excel it seems sorting by Shift-JIS order with
the known bugs condition under the following website.

http://support.microsoft.com/kb/823766/ja
(Sorry in japanese since it is only bug in Japanese Excel)

But I do the sorting under English/ Chinese version of Excel, the order is
different.
And I have checked the order that seems not following UTF-8, UTF-16 or even
Big 5. Did anyone know the actual sorting order for such kind of foreign
languages (like Korean, Japanese, Chinese etc.)?


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com