MySQL 4.1 has a bug that prevents WordPress 2.1 from displaying accented characters correctly. Instead, they appear as ? marks.
To fix this, open /wp-includes/wp-db.php
and look for this line:
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
(it’s around line 52).
Immediately after that line, add:
mysql_query("SET NAMES 'utf8'");
Save and re-upload the file, and you should see accented characters as usual.
If you are a WebbleYou customer and require accented character support, please contact us and we will be happy to make the necessary changes. No alterations to the database are necessary.
October 27th, 2007 at 3:40 pm
Thanks! This is exactly what I was looking for. I had this issue with a blog that is hosted with DreamHost and they only suggested I should try to fix the encoding on the pages: . However, when that didn’t work, I was pretty stuck. Then I found this great post and it worked right away. Thanks again!