SQL Collation with ASP.NET VB.NET

• kedric

  Old Hand

  Points: 323

  More actions

  June 11, 2009 at 11:16 pm

  #384762

  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.

• kedric

  Old Hand

  Points: 323

  More actions

  June 11, 2009 at 11:32 pm

  #1008397

  On the last post I just need the password to be case sensitive, not the username. My apologies.