访问MySQL的一个神奇的问题,'aaaaaa'等于'妹妹美'?
mysql> create table a (name varchar(32));
Query OK, 0 rows affected (0.50 sec)
mysql> insert into a values ('aaaaaa');
Query OK, 1 row affected (0.03 sec)
mysql> insert into a values ('妹妹美');
Query OK, 1 row affected (0.06 sec)
mysql> select count(distinct name) from a;
+----------------------+
| count(distinct name) |
+----------------------+
| 1 |
+----------------------+
1 row in set (0.05 sec)
mysql>
高手看看,只是为什么?为什么'aaaaaa'等于'妹妹美'?我竟以为count出来应该是2.