Password authentication error in Lowercase & Uppercase Characters.

Write New Post |

Search Posts | Answered

Resolved Posts |

Un Answered Posts |

Forums Home | Today's Posts |

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

Replies

Ranjeet_8
Posted on: 7/18/2012 8:00:16 AM

Level: Gold | Status: [Member] | Points: 25

refer this url

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

.

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

GSM_GSV
Posted on: 7/19/2012 3:25:26 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

Sathiya_Narayanan
Posted on: 7/19/2012 4:35:58 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

GSM_GSV
Posted on: 7/19/2012 4:49:16 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

Sathiya_Narayanan
Posted on: 7/19/2012 6:29:46 AM

Level: Starter | Status: [Member] | Points: 25

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. | Reply | Alert Moderator

Password authentication error in Lowercase & Uppercase Characters.

Replies

Reply - Please login to reply

Latest Posts