Page 1 of 1

problem with mysql

Posted: Tue Oct 19, 2004 1:02 am
by murthy
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

Posted: Tue Oct 19, 2004 1:12 am
by feyd
switch the field/column to binary.

Posted: Tue Oct 19, 2004 1:42 am
by murthy
please explain briefly....i didn't get you

Posted: Tue Oct 19, 2004 2:34 am
by feyd
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

Posted: Tue Oct 19, 2004 3:41 am
by murthy
very thanks ......