Re: Japanese "onyomi" versus "kunyomi" sort
The common (level 1) JIS kanji characters are ordered by yomi, which is preferably onyomi (though one takes kunyomi into account when there's no commonly-used onyomi). The uncommon (level 2) JIS kanji characters are supposedly ordered by radical/stroke but some exceptions occur. MySQL simply accepts the JIS order when sorting SJIS. Converting to Unicode and using (say) utf8_unicode_ci won't help.
MySQL has no current plan for kunyomi, though of course you're welcome to do it yourself or to submit a feature request on bugs.mysql.com. In the latter case, a lot will depend on the level of user demand. Until now, the main thing we've heard from Japanese users is that support for JIS X 4061 collation would be great but with emphasis on fixing up the kana, not on changing the JIS order for kanji.
Subject
Views
Written By
Posted
3478
June 29, 2006 11:31PM
Re: Japanese "onyomi" versus "kunyomi" sort
2058
July 09, 2006 09:28AM
1779
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.