String case question
Posted: Mon Jun 18, 2007 9:19 pm
Code: Select all
SELECT * FROM `x_roope_strings` WHERE `string`='Ka_la'A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
SELECT * FROM `x_roope_strings` WHERE `string`='Ka_la'You can also just use the BINARY keyword in the query. I use it on logins so that no user can sign up with the same name having different cases, but they have to login with the same case that they signed up with.feyd wrote:Setting the column to BINARY would make it case sensitive.