Hi,
I am getting problem with Login form.
i.e mysql accepting all values i.e not case sensitive.
ex:
select * from table where username='raju';
GETTING RESULTS;
select * from table where username='RAJU';
GETTING RESULTS;
i have to restrict to this case sensitive.
Thanks,
Murthy
[SOLVED] problem with mysql
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
change the column username to a binary (var)char type:
Code: Select all
ALTER TABLE `table_name` CHANGE `username` `username` VARCHAR( 255 ) BINARY NOT NULL