Password defined as SQL_Latin1_General_CP1_CS_AS but not being recognized when entered
Posted on 2014-04-04
A table has been created that has two fields (i.e., UserId, UserPswd) defined to be SQL_Latin1_General_CP1_CS_AS.
When I enter the user id that is not in its proper case, my program issues the correct message indicating that the user id is not correct.
However, when I enter the user password that is not in its proper case, the program accepts the password as being correct.
Can someone tell me why the SQL_Latin1_General_CP1_CS_AS works for one field but not for the other? Do I need to do something else to get it to be recognized.