MySQL中为什么SQL语句中大小写不区分？

congcong2010

字符集的校验规则问题，你的字符集应该是选择以_ci（大小写不敏感）结束的，你应该选择以_cs（大小写敏感）或_bin（二元）结束的校验规则

a20041070129

学习学习！！

dushenglin

The default character set and collation are latin1 and latin1_swedish_ci, so nonbinary string comparisons are case insensitive by default. This means that if you search with col_name LIKE 'a%', you get all column values that start with A or a. To make this search case sensitive, make sure that one of the operands has a case sensitive or binary collation.


http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

http://blog.csdn.net/xfsnow/archive/2008/09/05/2885948.aspx

[ 本帖最后由 dushenglin 于 2010-12-5 21:21 编辑 ]