MySQL Forums
Forum List  »  PHP

Re: LIKE not working with simple search
Posted by: Scotty Miller
Date: April 29, 2009 03:15AM

I saw this a little while back elsewhere, not sure if this is the solution for you or not, but I am going to assume it is the field that you are searching that is the problem, based off of what you are presenting to us. What is the Charset/Collation for that field? I remember reading someone was having problems searching case-sensitive values in UTF8 but was resolved when he switched from UTF8 to latin1. That might be a solution if you have no need to use UTF8 as a Charset (and are in fact using UTF8). If that isn't the case, could you copy and paste the results from
SHOW FULL COLUMNS FROM table_name

where table_name is the name of your table that contains the field you are trying to search? That will give us a good strong start on what the problem could be.



Edited 1 time(s). Last edit at 04/29/2009 03:17AM by Scotty Miller.

Options: ReplyQuote


Subject
Written By
Posted
R G
April 28, 2009 09:05AM
Re: LIKE not working with simple search
April 29, 2009 03:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.