Categories
MySQL

[MySQL] Illegal mix of collations – Solved in direct request

In case, you have executed some request as following example UPDATE `td_invoice_zzz` zi, ts_zone zo SET `zzz_com_zon_id` = zo.zon_id WHERE zzz_com_zon_code = zo.zon_code; And you receive the error about illegal mix of collations as: Error Code: 1267. Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' You are trying to compare two fields that…

Categories
MySQL

MySQL server has gone away, Issue & Solution [drupal]

MySQL server has gone away, issue on drupal, drupal ecommerce kickstart gives me alot of headache since I do not first aware that the issue because of there are so many packets execution on mysql with drupal. The full error is (or similar): Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error:…

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…