mysql - 你如何让 MySQL 不将非 ASCII 视为 ASCII？

Question

示例表:

CREATE TABLE test (name varchar(32)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO test VALUES ('adam');
INSERT INTO test VALUES ('ádam');

问题查询:

SELECT name FROM test WHERE username='ádam';
+----------+
| name     |
+----------+
| adam     |
| ádam     |
+----------+

如何让 MySQL 准确地搜索用户输入，而不是隐式地将其音译为 ASCII？

Answer 1

mysql> SELECT name FROM test WHERE CONVERT(name USING BINARY) = 'ádam';

+-------+
| name  |
+-------+
| ádam  |
+-------+