1. 排序 ORDER BY convert_to(title,'GBK'); 报异常 ERROR: character with byte sequence 0xe2 0x84 0xa2 in encoding “UTF8” has no equivalent in encoding “GBK”; 2. 解决办法 使用其他的中文编码; 原因是:GB2312(简体),GBK(简体+繁体),GB18030(简体+繁体+少数民族字体+各种中国的符号) ORDER BY convert_to(title,'GB18030');