-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|