MySql - Illegal mix of collations

mysql.com 5.5

Error on SQL Query

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

SQL Query Code:

SELECT ...FROM ...JOIN ...
 ON stats_visits.country  =  country.code

Quick SQL Query Fix:

ON stats_visits.country collate utf8_general_ci = country.code collate utf8_general_ci   

Or with ALTER DATABASE and TABLE:

ALTER DATABASE your_database CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE database_tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;