List:General Discussion« Previous MessageNext Message »
From:Mark Date:August 1 2005 5:35pm
Subject:Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(latin1_swedish_ci,COERCIBLE) for operation '='
View as plain text  
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?

>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