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

[Bastian Balthazar Bux]

Mark Dacasco wrote:
> 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;
> 
> 
> 

adding to the section "[mysqld]" of the file my.cnf
"character-set-server = utf8"
solves the problem ?


-- 
 ....................................................................
. These pages are best viewed by coming to my house and looking at   .
. my monitor. [S. Lucas Bergman (on his website)]                    .
 ....................................................................