Re: does mysql plan support utf8 charset more collations such as Simplified Chinese, Japanese... ?
Posted by: Josh Chamas
Date: November 17, 2004 01:44AM

shengw1127 wrote:
> does mysql plan support utf8 charset more
> collations such as Simplified Chinese, Japanese...
> ?
>

While I suspect we are adding support for this in the future
I do not have any information to this effect currently.

> we just use oracle can sort it in multi-language
> correctly!
> mysql can sort utf8 in multi languages but all
> european language, can not support Simplified
> Chinese, Traditional Chinese, Japanese, Korean
> collations.
>
> specailly, in Simplified Chinese, multi sort
> methods can be supported with oralce.
>
> we eager to migration to mysql, but this is the
> biggest obstruction. how should we do?

In MySQL 4.1, you might try something like on the fly conversion
to the simplified chinese character set for sorting. See CONVERT here:

http://dev.mysql.com/doc/mysql/en/Charset-CONVERT.html

so you might do...

select UTF8_COL from TABLE order by convert(UTF8_COL using 'gb2312');

Note I have not tried this myself, but you might give it a shot and see how it works in your case.

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: does mysql plan support utf8 charset more collations such as Simplified Chinese, Japanese... ?
3341
November 17, 2004 01:44AM


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.