Illegal mix of collations?

[Jim R]

Trying to execute this query:

 

UPDATE a_playerRank AS p, wp_terms as t

SET p.wpID = t.term_id

WHERE p.wpSlug = t.slug

 

 

I get the following error:

 

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

 

 

 

As far as I can tell, applicable columns are utf8_unicode_ci and none are utf8_general_ci.  I've searched for solutions here and on elsewhere.  Can't make much of what is being suggested.