Posted By

ginoplusio on 11/18/08


Tagged

login sql case query ASP uppercase lowercase sensitive collate


Versions (?)

SQL case sensitive match for user and password


 / Published in: SQL
 

URL: http://www.barattalo.it/

When you make a login remember to use CASE SENSITIVE on password and case insensitive on username

  1. SELECT * FROM users WHERE login='youruser' AND password='YourPassword' COLLATE SQL_Latin1_General_Cp1_CS_AS

Report this snippet  

You need to login to post a comment.