Re: Chinese sorting and filtering on an table with charset UTF-8 (solved)

[Tobias Prinz]

Okay, solved it myself. While there is no collation for Chinese in UTF-8, I learned from a colleague that I can use CONVERT() in the WHERE part, too.

So the following are possible:
SELECT * FROM names WHERE CONVERT(name USING gb2312) > '明';
SELECT * FROM names ORDER BY CONVERT(name USING gb2312);

The latter implicitly uses gb2312_chinese_ci but you could name another one for that charset, too.

An EXPLAIN on these lines does not look too promising, but it will have to do.



Edited 1 time(s). Last edit at 03/09/2011 04:49AM by Tobias Prinz.