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

[Josh Chamas]

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