Sorting order of foreign languages

J

Jonathan

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.)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Korean language pack causes problems with email width in Outlook 0
Sorting a column based on required order 2
Switching languages 1
Is there a table of Excel function-names for different languages? 5
File origin option 0
Excel 2010 - choose codepage when saving as text? 1
Japanese text entry broken 1
installing foreign language packs 3

Top