Password authentication error in Lowercase & Uppercase Characters.

Posted by Sathiya_Narayanan under ASP.NET on 7/18/2012 | Points: 10 | Views : 1551 | Status : [Member] | Replies : 5
Hi,

I created an login application its working fine but have some errors in passwords authenticating,
in DB it contains username is 'ask' and password is 'ask', when entering this information the application is logged in.
error is when user entering his username and password as 'ask' 'ask' its logged in & if the user enters the password as "ASK"(in uppercase) also its accepting.
its not checking the uppercase and lowercase characters

if u know share your ideas how to solve this problem...





Thanks,

SATHIYANARAYANAN


Responses

Posted by: Ranjeet_8 on: 7/18/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
refer this url

http://codeigniter.com/forums/viewthread/197738/#929702

.

Sathiya_Narayanan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: GSM_GSV on: 7/19/2012 [Member] Starter | Points: 25

Up
0
Down
Try this

select username, password from users collate SQL_Latin1_General_Cp1_CS_AS

This will be case sensitive
or
store the hashed password in the database, not as text

---------------------------------------
Live the life you've dreamed

Regards
MADHU

Sathiya_Narayanan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sathiya_Narayanan on: 7/19/2012 [Member] Starter | Points: 25

Up
0
Down
Hi please tell briefly.
Where, how to use this in storedprocedure or in cs coding..

SATHIYANARAYANAN

Sathiya_Narayanan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: GSM_GSV on: 7/19/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,

Include "collate SQL_Latin1_General_Cp1_CS_AS" in your select statement in cs. Not stored procedure.

---------------------------------------
Live the life you've dreamed

Regards
MADHU

Sathiya_Narayanan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sathiya_Narayanan on: 7/19/2012 [Member] Starter | Points: 25

Up
0
Down
I m using Stored procedure
though again I replaced to query also its not working..
showing error in sql query..

SATHIYANARAYANAN

Sathiya_Narayanan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response