case sensitive ?

Hi everyone,

I'm working on a site requiring authentication and such.

This is the problem:
Say an account username is "s3312". The database recognises this and stores all required data for this user, however is they login again using "S3312" the database doesn't recognise them as the same.
How do I make it so that the database recognises both as the same account ?

Thanks in advance.

In your WHERE clause use:
upper(passed_username) = upper(username_in_db)


Good luck.