MySQL Database Error :: Illegal mix of collations

The error “Illegal mix of collations” in MySQL has to do with the collation type for the database being set differently than MySQL. This likely occurred because you created the databases on a system that had a different collation type. The collocation defaults to UTF, and should be acceptable in most cases. Collation for a database can be changed with the alter database command.

The following example changes the collate of a database named dbname to utf8:

ALTER DATABASE dbname COLLATE utf8_general_ci

The following example changes the collate of a database named dbname to French:

ALTER DATABASE dbname COLLATE French_CI_AS

The following example changes the collate of a database named dbname to Swedish:

ALTER DATABASE dbname COLLATE latin1_swedish_ci

Additional information can be found in the Character Set Support page of MySQL's manual:

http://dev.mysql.com/doc/refman/6.0/en/charset.html