nearenough Posted August 5, 2010 Share Posted August 5, 2010 when the simple search script in the tutorials on this site searches my mySQL database it doesnt find results unless they are typed in the same case as the original entry. ie 'horse' does not find 'Horse' is it some problem with my database table formats or do i need to add a bit of script to the search to solve it? Quote Link to comment Share on other sites More sharing options...
JasonLewis Posted August 5, 2010 Share Posted August 5, 2010 If you are using LIKE in your queries then the search should be not case sensitive. You are using LIKE? Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted August 5, 2010 Share Posted August 5, 2010 What does your query look like and what is the definition of your column? You are either forcing a case-sensitive comparison in your query (unlikely) or due to the definition of your column (data type is a binary character type, the character set, or the collation.) Quote Link to comment Share on other sites More sharing options...
nearenough Posted August 5, 2010 Author Share Posted August 5, 2010 the search was using LIKE, it was the collation thanks a lot Quote Link to comment 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.