MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Posted by: Rick James
Date: October 07, 2014 04:20PM

Let's see
SHOW CREATE PROCEDURE sp_name \G
and the CALL statement, plus declarations of the argument.

I think you will see in the SHOW CREATE that the PROCEDURE something like:
character_set_client: utf8
collation_connection: utf8_general_ci
These were established at the time of doing the CREATE.

Suggest you DROP PROCEDURE, SET the collation, then re-CREATE the PROCEDURE.

Or, work on changing the caller?

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.