[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Password defined as SQL_Latin1_General_CP1_CS_AS but not being recognized when entered

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.

Thank you.
0
CarmenMTorres
Asked:
CarmenMTorres
  • 4
  • 3
  • 2
1 Solution
 
Scott Fell, EE MVEDeveloperCommented:
Is this for your code?  Are you sure you don't have code that converts the password to all upper or lower case or ignores case?
0
 
CarmenMTorresAuthor Commented:
The passwords are encrypted, but when accessing or reading the passwords, they are decrypted.
0
 
Anthony PerkinsCommented:
Please post the schema for your table.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
CarmenMTorresAuthor Commented:
I was able to determine the issue.  I needed to append the clause "COLLATE SQL_Latin1_General_CP1_CS_AS " to the password after it was decrypted.  Once I appended the clause, the function was performing properly.

Thank you all for your input.
0
 
CarmenMTorresAuthor Commented:
Since I was able to resolve this issue myself by appending the clause "COLLATE SQL_Latin1_General_CP1_CS_AS " to my query statement , Administrator can you please close this question.  Thank you.
0
 
Scott Fell, EE MVEDeveloperCommented:
Just accept your own answer.
0
 
Anthony PerkinsCommented:
0
 
Scott Fell, EE MVEDeveloperCommented:
On that comment, click "Accept as Solution". You will be redirected to the Award Points and Grade page for your question.
0
 
CarmenMTorresAuthor Commented:
I was able to determine the answer to my problem before a solution was suggested by the experts.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now