Checking username(upper and lower)

**analyzer** · 22-06-12, 12:19

I was trying to check username in my login form that when someone puts username which is not exactly the same with the registered username, he/she will fail to login. Example. . Registered username is tEst and password is test, when someone tried to log in using "test" as username it will not log in because letter "e" must be "E". So it should be "tEst". How will i'am going to verify that?

**ionutvmi** · 22-06-12, 17:23

check with phpmyadmin if the Collation of your username column is latin1_swedish_ci
alternatively you could use strtolower() on your login page

**analyzer** · 23-06-12, 12:57

The collation is latin1_swedish_ci but still doesn't work. I check it in my sql using, WHERE username='".$username."'

**GumSlone** · 26-06-12, 13:30

Originally Posted by analyzer [Only registered and activated users can see links. Click Here To Register...]

The collation is latin1_swedish_ci but still doesn't work. I check it in my sql using, WHERE username='".$username."'

PHP Code:

 WHERE username LIKE '{$username}'

**analyzer** · 26-06-12, 13:52

I'll try it bro, thanks!

**CreativityKills** · 15-07-12, 15:53

use character encoding utf8_general_ci, and make sure your username column is a UNIQUE key

**arevel** · 08-08-12, 16:20

try strtolower($username);

**Ghost** · 08-08-12, 16:24

Originally Posted by arevel [Only registered and activated users can see links. Click Here To Register...]

try strtolower($username);

this makes all characters lowercase. but the original poster wants to check for case "insensitive" characters.
so the user is able to use both upper and lower case at same time.