Categories
MySQL

MySQL issue & Solution: Illegal mix of collations for operation ‘=’

MySQL Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Overview I have two databases in mysql, I have written a sql to compare two table (dbA.contact & dbB.actor). Example: SELECT dbB.* FROM dbA.contact co, dbB.actor ac WHERE co.name = ac.name When I execute the request, I will get above error, why it […]