Japanese "onyomi" versus "kunyomi" sort
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.
Subject
Views
Written By
Posted
Japanese "onyomi" versus "kunyomi" sort
3477
June 29, 2006 11:31PM
2058
July 09, 2006 09:28AM
1778
August 21, 2006 10:39PM
2120
September 05, 2006 06:11AM
1985
October 31, 2006 07:59PM
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.