如果您为该列设置了适当的排序规则,则该字段中的值自然会比较等于其未重读的等值。
mysql> SET NAMES 'utf8' COLLATE 'utf8_unipre_ci';Query OK, 0 rows affected (0.00 sec)mysql> SELECT 'é' = 'e';+------------+| 'é' = 'e' |+------------+| 1 |+------------+1 row in set (0.05 sec)

如果您为该列设置了适当的排序规则,则该字段中的值自然会比较等于其未重读的等值。
mysql> SET NAMES 'utf8' COLLATE 'utf8_unipre_ci';Query OK, 0 rows affected (0.00 sec)mysql> SELECT 'é' = 'e';+------------+| 'é' = 'e' |+------------+| 1 |+------------+1 row in set (0.05 sec)