密码框区分大小写

 

不区分大小写：

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"