Password authentication error in Lowercase & Uppercase Characters.

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

0	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

Latest Posts