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 Paharenko | 1 Aug |
| • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and(latin1_swedish_ci,COERCIBLE) for operation '=' | Mark Dacasco | 1 Aug |
| • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)for operation '=' | Bastian Balthazar Bux | 1 Aug |
| • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' | Mark | 1 Aug |
| • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)for operation '=' | Bastian Balthazar Bux | 1 Aug |
| • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' (SOLVED) | Mark | 2 Aug |