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

[Mark]

You're right. It is not related. The same output are shown as before. 
However, the links you gave me was quite useful. I re-read and 
re-read them over and over until this little query solved my dilemma, sort of:

SET NAMES 'utf8';

Thanks for the help! ^_^

>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 ?