Case Sensitive in sqlserver
-
Hi all I have a login form(user name and password) that reads its data from a database, I need to check the password textbox letters case, e.g. if the user wrote "admin" it will be different than "ADMIN"... Is there is any function to do that?
Best Regards, Trishul Tandel Software Developer
-
Hi all I have a login form(user name and password) that reads its data from a database, I need to check the password textbox letters case, e.g. if the user wrote "admin" it will be different than "ADMIN"... Is there is any function to do that?
Best Regards, Trishul Tandel Software Developer
hiii in sql server we can't identify Case Sensitive..so if u want then store encripted password in database.means use the encription/decrition method for password .using that u can able to match exact value.
Jintal Patel
-
Hi all I have a login form(user name and password) that reads its data from a database, I need to check the password textbox letters case, e.g. if the user wrote "admin" it will be different than "ADMIN"... Is there is any function to do that?
Best Regards, Trishul Tandel Software Developer
You are hashing your passwords aren't you? You're not just storing them in the database as clear text? If you aren't, this is a big security risk. Password hashing is easy if you use the ASP.NET 2.0 Membership API; it does it for you with the default SQL provider.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
-
Hi all I have a login form(user name and password) that reads its data from a database, I need to check the password textbox letters case, e.g. if the user wrote "admin" it will be different than "ADMIN"... Is there is any function to do that?
Best Regards, Trishul Tandel Software Developer
Check out this article: http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm[^]
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson