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 ? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
