SELECT * FROM table1
ORDER BY convert(field using gbk) desc
或者
SELECT id, convert(field using gbk) as field_gbk
FROM table1
ORDER BY field_gbk asc;
SELECT * FROM table1
ORDER BY convert(field using gbk) desc
或者
SELECT id, convert(field using gbk) as field_gbk
FROM table1
ORDER BY field_gbk asc;