密码框区分大小写

 

不区分大小写：

sql="SELECT * from admin where admin_name='"&adminname&"' and admin_pwd='"&adminpwd&"' order by admin_name desc"

 

区分大小写：

sql="SELECT * from admin where admin_name='"&adminname&"' and admin_pwd collate Chinese_PRC_CS_AS_WS ='"&adminpwd&"' order by admin_name desc"

转载于:https://www.cnblogs.com/sun-chen-ks/archive/2005/10/16/256096.html