MySQL – Fixing an Illegal mix of Collation
Mixing Collations While creating an ETL process for a Client, I ran into the following MySQL error: "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='"A quick google search resulted a lot of bug reports on the MySQL website, but not any concrete instructions on how...