0

I woud like to make join between tables in different collations. But it throws me an error #1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_slovak_ci,IMPLICIT) for operation '='

SELECT `orders`.* from `orders`
JOIN `users` ON `orders`.`users_id` = `users`.`id`
JOIN `acl_users` ON `acl_users`.`email` = `users`.`email` 
AND `acl_users`.`id` != `users`.`id`

How can I solve this issue?

Čamo
  • 3,863
  • 13
  • 62
  • 114
  • Check the collations in acl_users and users tables and align them to each other. – Shadow Jul 20 '16 at 22:12
  • I founded out this http://stackoverflow.com/questions/3029321/troubleshooting-illegal-mix-of-collations-error-in-mysql?rq=1 – Čamo Jul 20 '16 at 23:01
  • What parameters are you using when connecting? What collation, if any, is mentioned in my.cnf? What is the charset of the column? – Rick James Jul 24 '16 at 01:57

0 Answers0