>From the manual:
6.3.2.2 Case-Sensitivity
BINARY
The BINARY operator casts the string following it to a binary string.
This is an easy way to force a column comparison to be case-sensitive
even if the column isn't defined as BINARY or BLOB:
mysql> SELECT "a" = "A";
-> 1
mysql> SELECT BINARY "a" = "A";
-> 0
--
Loren McDonald
[EMAIL PROTECTED]
> -----Original Message-----
> Am having a bit of a weird problem with a SELECT on my MYSQL
> database:
>
> If i use this:
>
> SELECT * FROM tablehere WHERE userid = '$uid' AND password =
'$pwd'
>
> with $uid and $pwd being vars from a login form, and "Miguel"
being
> userid
> on the table, i can login if i type "miguel" on the form. No matter if
i
> type uppercase or lowercase, it always logs in, how can that be?
"Miguel"
> is != to "miguel". (but if i misspel it, it fails, as it should :-)
>
> How can i make a correct check with upper case distinction?
> Thanks
>
> Pag
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
