Garethp Posted September 5, 2009 Share Posted September 5, 2009 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? Link to comment https://forums.phpfreaks.com/topic/173218-my-select-isnt-case-sensative/ Share on other sites More sharing options...
Zane Posted September 5, 2009 Share Posted September 5, 2009 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 Link to comment https://forums.phpfreaks.com/topic/173218-my-select-isnt-case-sensative/#findComment-913100 Share on other sites More sharing options...
fenway Posted September 8, 2009 Share Posted September 8, 2009 Even better would be (a) not to use plaintext passcodes and (b) not the pass them at all to the query. Link to comment https://forums.phpfreaks.com/topic/173218-my-select-isnt-case-sensative/#findComment-915026 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.