-
Sorting in Japanese [by celiawessen]
PHP and MySQL:: Sorting in Japanese
To sort Japanese strings into AIUEO order (at least in kata-kana), you'll need to add the next few lines to your MySQL config file /etc/my.cnf. If this file does not exist, create one.
[mysqld]
default-character-set=ujis
language = /usr/share/mysql/japanese/