June 11, 2009 at 11:16 pm
I have a login screen and I want to the username and password fields to be case sensitive. If a visitor to my website sets up a username and password to all lowercase letters, then they should only be allowed to login using lowercase letters, not uppercase letters. My database currently has the SQL_Latin1_General_CP1_CS_AS collation. When I run my project I enter uppercase letters for the username and password and sends me to the members page. It shouldn't do that. I also I explicitly entered the collation into my code like this:
sqlstring = "SELECT username, password FROM table "
sqlstring &= "WHERE username = @username AND password = @password COLLATE SQL_Latin1_General_CP1_CS_AS"
Any help and suggestions is greatly appreciated.
June 11, 2009 at 11:32 pm
On the last post I just need the password to be case sensitive, not the username. My apologies.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply