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