为什么蔡婷婷＝蔡媛媛？

malei

mysql> select a.name,b.name from student_study as a,student_register as b where a.name=b.name and a.name='蔡婷婷';
+--------+--------+
| name   | name   |
+--------+--------+
| 蔡婷婷 | 蔡媛媛 |
+--------+--------+

应该是我的表建立的有问题？

ccwlm741212

select a.name,b.name from student_study as a,student_register as b where a.name=b.name and a.name='蔡婷婷' and b.name='蔡婷婷'   执行看看！  还昏头了哦

malei

mysql> select a.name,b.name from student_study as a,student_register as b where a.name=b.name and a.name='蔡婷婷' and b.name='蔡婷婷';
+--------+--------+
| name   | name   |
+--------+--------+
| 蔡婷婷 | 蔡媛媛 |
+--------+--------+
1 row in set (0.23 sec)

ccwlm741212

蔡婷婷= 蔡媛媛 ?  你的汉字系统有问题？？

你修改成其他看看！
蔡婷婷= 蔡媛媛1  ？

malei

MYTSQL，把数据库服务器设置代码用GBK，或者用binary比较。
怎样进行binary比较