How to validate user name and password with case sensitiveness in php?

[learn.2005@gmail.com]

Hello Friends!
I am Manu Gupta, an IT Engineering student, learning PHP presently. I
want to match user name and pwd from MySQL, it shows case
insensitiveness . Can anybody help me in implementing case sensitiveness
in either PHP or MySQL?
Thanks in advance

[Sjoerd]

Re: How to validate user name and password with case sensitiveness in php?

What do you have so far? Can you show some code?

[samudasu]

Re: How to validate user name and password with case sensitiveness in php?

When you create your mysql table, set the data type attibutes for
username and password columns to binary.

create table login ( uname VARCHAR(8) BINARY, ... ...)

[Jerry Stuckle]

Re: How to validate user name and password with case sensitivenessin php?

learn.2005@gmai l.com wrote:[color=blue]
> Hello Friends!
> I am Manu Gupta, an IT Engineering student, learning PHP presently. I
> want to match user name and pwd from MySQL, it shows case
> insensitiveness . Can anybody help me in implementing case sensitiveness
> in either PHP or MySQL?
> Thanks in advance
>[/color]

http://dev.mysql.com/doc/refman/5.1/...nsitivity.html

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===