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? Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.