Collation for Chinese character

[alex ma]

I am using mysql-5.0.41 for win32 and the default charater set is UTF8 and the collation is utf8_generic_ci.

As you know, I get a resultset with wrong sorting when I use a sql like that "select * from table1 order by name". The data in the column 'name' is Chinese character.

I know I can get a correct resultset using the function 'convert(name using gbk)' to convert the column 'name'.
I'd like to know whether I can get the correct result via another approach because that kind of sql is not so good for miaration.

Will you release a utf8_chinese_ci module in future?

Many thanks.