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');