case sensitive login field

Question

5.00/5 (1 vote)

See more:

i have made a insert query used as registration and select query as login and checking but the problem is. it doesnt check for upper case how can i put that in my small scale app.

Posted 14-Nov-12 10:38am

sariqkhan

Updated 16-Dec-12 18:01pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2012-11-14T10:50:00

Solution 1

You need to tell SQL to use a collation that is case sensitive.

Do this in your SQL:

SQL

WHERE password = @password COLLATE SQL_Latin1_General_CP1_CS_AS and Username=@Username

That tells SQL to treat "password = @password" with case sensitivity.

Posted 14-Nov-12 10:50am

ZurdoDev

Comments

sariqkhan 14-Nov-12 16:58pm

nice one
+5
but how do you do that? whats the concept behind that?
what is this COLLATE SQL_Latin1_General_CP1_CS_AS? i never heard before

ZurdoDev 14-Nov-12 17:01pm

Collation defines how dates are stored, how strings are sorted (for example does 9AA come before or after AA) etc. It's kind of like a culture setting. If you look at the properties for your SQL database you'll see what the collation is set to. So, in this case, we're just overriding the collation to make it case sensitive. I actually worked on a DB once that had a case sensitive collation on the whole db. It was terrible. You had to have the case for field names correct or it could not find them.

shaikh-adil 14-Nov-12 17:00pm

+5

sariqkhan 14-Nov-12 19:14pm

nice explanation bro
thanx for helping

RaisKazi 14-Nov-12 19:47pm

My 5+

**Orcun Iyigun** · Accepted Answer · 2012-11-14T10:52:00

Solution 2

For SQL you can use COLLATE.[^].

Here is an example link[^] for you.

Good luck,
OI

Posted 14-Nov-12 10:52am

Orcun Iyigun

Comments

shaikh-adil 14-Nov-12 17:00pm

+5

RaisKazi 14-Nov-12 19:47pm

My 5!