php_guest Posted July 18, 2010 Share Posted July 18, 2010 I set my tables to utf8_general_ci but still queries with LIKE are case sensitive. How I can make queries case insensitive? I was thinking to use WHERE LOWER( fullName ) LIKE '%Jessica White%' but the problem is that won't use indexes. Is any other solution? tnx Quote Link to comment https://forums.phpfreaks.com/topic/208094-like-and-case-insensitive-with-utf8/ Share on other sites More sharing options...
Mchl Posted July 18, 2010 Share Posted July 18, 2010 Did you check your column collation? Remember that table collation applies only to new columns. Quote Link to comment https://forums.phpfreaks.com/topic/208094-like-and-case-insensitive-with-utf8/#findComment-1087776 Share on other sites More sharing options...
php_guest Posted July 18, 2010 Author Share Posted July 18, 2010 thanks, I realized it was varbinary. I changed it in phpmyadmin to varchar and now it is utf8_general_ci as it should be. Quote Link to comment https://forums.phpfreaks.com/topic/208094-like-and-case-insensitive-with-utf8/#findComment-1087784 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.