Re: does mysql plan support utf8 charset more collations such as Simplified Chinese, Japanese... ?
> 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
> mysql can sort utf8 in multi languages but all
> european language, can not support Simplified
> Chinese, Traditional Chinese, Japanese, Korean
> 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:
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.
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting