List:General Discussion« Previous MessageNext Message »
From:Bastian Balthazar Bux Date:August 1 2005 8:33pm
Subject:Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)
for operation '='
View as plain text  
useful links:
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
http://dev.mysql.com/doc/mysql/en/Charset-server.html
http://dev.mysql.com/doc/mysql/en/Charset-map.html
http://dev.mysql.com/doc/mysql/en/Option_files.html
http://bugs.mysql.com/bug.php?id=3611

I've found this in my php.ini, should _not_ be related but it can worth
a try (apache restart required).

=== php.ini ===
[PHP]
default_charset = "utf-8"
[mbstring]
mbstring.internal_encoding = utf-8
=== php.ini ===

and finally  "SHOW VARIABLES LIKE '%char%';" look like this now

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_results utf8
character_set_server utf8
character_set_system utf8

right ?

Mark wrote:
> I didn't find any option for character-set-server so I add it under
> mysqld as you've stated. I also found default-character-set so I also
> set its value to utf8. It didn't work.
> 
> I tried adding a dash (utf-8) to it. It didn't work also.
> 
> Yes, I did restart MySQL after saving the configuration.
> 
> What does that error mean, by the way?

The first link provided answer to this question.

> 
>> adding to the section "[mysqld]" of the file my.cnf
>> "character-set-server = utf8"
>> solves the problem ?
> 
Thread
Illegal mix of collations (utf8_general_ci,IMPLICIT) and(latin1_swedish_ci,COERCIBLE) for operation '='Tulong!1 Aug
  • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='Gleb Paharenko1 Aug
    • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and(latin1_swedish_ci,COERCIBLE) for operation '='Mark Dacasco1 Aug
      • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)for operation '='Bastian Balthazar Bux1 Aug
        • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='Mark1 Aug
          • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)for operation '='Bastian Balthazar Bux1 Aug
            • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' (SOLVED)Mark2 Aug