在MySQL中varchar类默认不区分大小写 解决方法: (1) alter table test change a a varchar(10) binary; (2) select * from test where a = binary 'MY'; binary:将后边字段转换为二进制