Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
Posted by: Rick James
Date: May 08, 2010 12:08AM

Well, which do you want? What is the column declared as? Please do SHOW CREATE TABLE. And please show the actual WHERE clause. And perhaps do EXPLAIN EXTENDED SELECT...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
3727
May 08, 2010 12:08AM


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.