MySQL Forums
Forum List  »  Newbie

Re: Alphabatize in Japanese
Posted by: Roland Bouman
Date: July 26, 2005 06:29AM

what is you mysql version? if >=4.1, you should make sure the column of you table is using the right character set and collation.

you can also do this locally in the order by:

ORDER BY japanese_column COLLATE <collation name>

But i recommend you take a look at the mysql reference for character set support and determine what characterset you should use. see:

http://dev.mysql.com/doc/mysql/en/charset.html

Options: ReplyQuote


Subject
Written By
Posted
July 25, 2005 10:07PM
Re: Alphabatize in Japanese
July 26, 2005 06:29AM


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.