使用order by binary 字段名 也不行啊:mysql> select * from pinyin;
+----+------+
| id | name |
+----+------+
| 1 | 啊 |
| 2 | 不 |
| 3 | 才 |
| 4 | 的 |
| 5 | 恶 |
| 6 | 发 |
| 7 | 个 |
| 8 | 号 |
+----+------+
8 rows in set (0.00 sec)mysql> select * from pinyin order by binary name;
+----+------+
| id | name |
+----+------+
| 2 | 不 |
| 7 | 个 |
| 6 | 发 |
| 8 | 号 |
| 1 | 啊 |
| 5 | 恶 |
| 3 | 才 |
| 4 | 的 |
+----+------+
8 rows in set (0.00 sec)
+----+------+
| id | name |
+----+------+
| 1 | 啊 |
| 2 | 不 |
| 3 | 才 |
| 4 | 的 |
| 5 | 恶 |
| 6 | 发 |
| 7 | 个 |
| 8 | 号 |
+----+------+
8 rows in set (0.00 sec)mysql> select * from pinyin order by binary name;
+----+------+
| id | name |
+----+------+
| 2 | 不 |
| 7 | 个 |
| 6 | 发 |
| 8 | 号 |
| 1 | 啊 |
| 5 | 恶 |
| 3 | 才 |
| 4 | 的 |
+----+------+
8 rows in set (0.00 sec)
+----+------+
| id | name |
+----+------+
| 2 | 不 |
| 7 | 个 |
| 6 | 发 |
| 8 | 号 |
| 1 | 啊 |
| 5 | 恶 |
| 3 | 才 |
| 4 | 的 |
+----+------+
8 rows in set (0.00 sec)