MySQL strings

thoand

I am developing a loggin system using MySQL for names and password etc.,

When loggin in, I am checking the input values with the ones in the db table, but have noticed that it does'nt matter if I am using uppercase or lowercase letters in the password.

Can anyone explain why? is this a Win32 thing?

regards Thomas A:

xwin

Can I see your code?

thoand

$userid = $POST['userid'];
$passw = $POST['passw'];

SELECT * FROM users WHERE useractive = 1 AND userid = '$userid' AND userpass = '$passw'

...

xwin

Hmm..

Wierd. I thought that if you took the code from somewhere, it might have used strtolower or something to that effect, but... :-/

xblue

Hi there,

mysql char, varchar and text fields behave case-insensitive by default. Using BINARY in your query changes this.

See
http://www.phpbuilder.com/board/showthread.php?threadid=65227

Hope this help,
xblue