Re: Japanese "onyomi" versus "kunyomi" sort
Posted by: Peter Gulutzan
Date: July 09, 2006 09:28AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Japanese "onyomi" versus "kunyomi" sort
2058
July 09, 2006 09:28AM


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.