Japanese "onyomi" versus "kunyomi" sort
Posted by: Jacob Levine
Date: June 29, 2006 11:31PM

Hello forum,

I'm trying to perform a sort in MySQL on Japanese text. The problem is that my queries always sort based on "onyomi" readings of the Japanese characters when I want them to use "kunyomi" readings. I haven't been able to find any useful information on how to accomplish this and was hoping some guru here could help. Details follow.

My field is using the SJIS character set and the default "sjis_japanese_ci" collation. I have also tried the "sjis_bin" collation without seeing any change. In my version of MySQL (4.1.12-nt) no other collations for the SJIS character set are available. When I sort on this field (using "ORDER BY"), the query returns data sorted in the "onyomi" ("音読み") order based on Chinese readings of the Japanese characters when I want it to use the "kunyomi" ("訓読み") readings which are based on Japanese readings of the same characters.

Ultimately I will be displaying the data using PHP, so any solution involving that language would also be useful. Otherwise I guess my question will become a MySQL feature request.

Any help would be greatly appreciated.
TIA,
--Jacob



Edited 1 time(s). Last edit at 06/29/2006 11:38PM by Jacob Levine.

Options: ReplyQuote


Subject
Views
Written By
Posted
Japanese "onyomi" versus "kunyomi" sort
3477
June 29, 2006 11:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.