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

Example: 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