mysql数据库区分大小怎么解决?

登陆网站时怎么让mysql数据库不区分大小呢?
---------------------------------------------------------------

$user_ID=strtolower($user_ID)
全部变小写.或者全部转大写
---------------------------------------------------------------

能不能具体点呀,

---------------------------------------------------------------

mysql> SELECT "a" = "A";
-> 1
mysql> SELECT BINARY "a" = "A";
-> 0

---------------------------------------------------------------

就是一楼的意思, 把登录进的用户名用upper或者lowercase处理一次, 这样就不存在大小写的分别了

Published At
Categories with Web编程
Tagged with
comments powered by Disqus