SQL case sensitive match for user and password - SQL Snipplr Social Repository

Revision: 9709

at November 18, 2008 08:03 by ginoplusio

Updated Code

SELECT * FROM users WHERE login='youruser' and password='YourPassword' COLLATE SQL_Latin1_General_Cp1_CS_AS

Revision: 9708

at November 18, 2008 08:02 by ginoplusio

Initial Code

SELECT * FROM feUtenti WHERE login='youruser' and password='YourPassword' COLLATE SQL_Latin1_General_Cp1_CS_AS

Initial URL

http://www.barattalo.it/

Initial Description

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

Initial Title

SQL case sensitive match for user and password

Initial Tags

login, sql, query, ASP

Initial Language

SQL