Answers for "Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"

Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec

SELECT t.*, ot.Name FROM table t JOIN 
othertable ot ON t.id = ot.id2 
COLLATE latin1_general_ci; -- Choose a common collation here

Posted by: Guest on April-08-2021

Code answers related to "Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"