Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

[Mark Dacasco]

SHOW VARIABLES LIKE ''%char%;
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_results utf8
character_set_server latin1
character_set_system utf8

SHOW CREATE TABLE `table1`;
CREATE TABLE `main_peeps` (
   `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Primary Key',
   `test` varchar(255) NOT NULL default '' COMMENT 'Test',
   PRIMARY KEY  (`id`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='COMMENT HERE'

>Please, send the output of the following statements:
>
>   show variables like '%char%';
>
>   show create table table1;