Mixed Collation Errors

If you are getting PHP log files that say things like:

Illegal mix of collations (latin1_general_cs,IMPLICIT) and (latin1_general_ci,IMPLICIT) 

or

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) 

the easiest way to fix this is to simply convert your database to use UTF8. Fortunately there is a UTF8 Conversion Tool you can run to do this.