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 ?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to