1271 - Ilegal mix of collations for operation 'UNION'

[quimfv]

Remoto CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */
Local CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 */

SHOW VARIABLES LIKE 'character_set%';
Remoto
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

Local
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir C:\AppServ\MySQL\share\charsets\

SHOW VARIABLES LIKE 'collation%';
Remoto
collation_connection utf8_general_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci

Local
collation_connection utf8_unicode_ci
collation_database utf8_general_ci
collation_server utf8_general_ci

Estos son los datos de mi maquina donde si se ha restaurado aun que no a la primera la bbdd... hay difrencias. La tercera maquina en discordia no la tengo ahora.

Para igualar los los distintos valores hay que modificar my.cnf directamente, no veo instrucciones ALTER... no?