My Select Isn't Case Sensative???

[Garethp]

Okay, so I have this

$Search = mysql_query("SELECT * FROM `$Table` WHERE `$Userfield`='$Username' AND `$Passfeild`='$Password'");

All the variables are correct, it's part of a login code. The only problem is, that whether I enter Test or test or TEST as the password, it always comes back true. The real password is Test. But if I enter Tes or anything that's not Test, it comes back false, so I know that it's just case insensitive.

 

Is there a way to make it Case Sensitive?

[Zane]

http://aspadvice.com/blogs/ssmith/archive/2007/09/30/Case-Sensitive-or-Insensitive-SQL-Query.aspx

 

 

some more good reading

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/6a9107b0-b747-4bce-ba90-04339f668ea6

[fenway]

Even better would be (a) not to use plaintext passcodes and (b) not the pass them at all to the query.