mysql查询区分大小写

mysql> select * from name where name='a';
+------+
| name |
+------+
| a    |
| ä    |
+------+
2 rows in set (0.00 sec)

mysql> select * from name where binary name='a';
+------+
| name |
+------+
| a    |
+------+
1 row in set (0.01 sec)

因为字符集不是bin导致的，所以可以使用SQL语句强制处理