Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Posted by: Pablo Viquez
Date: June 03, 2009 07:13PM

This error happens when MySQL cannot determine the collate to use for the comparation.

SELECT id, name
FROM table
WHERE name = CONVERT(@varname USING utf8)
COLLATE utf8_general_ci;


See: http://dev.mysql.com/doc/refman/5.0/en/charset-collate-tricky.html

Solution: (Spanish)
http://www.pabloviquez.com/2009/05/illegal-mix-of-collations%E2%80%A6/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
38000
June 03, 2009 07:13PM


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.