The problem is occuring because your posts were originally stored in one character encoding, but your new database thinks they have been written in another character encoding.
This means that letters like ç, õ, ã were stored under different codes in your old DB, and your new DB doesn’t know how to handle them because it doesn’t know those codes.
Probably the easiest thing to do would be to ask your hosts about changing the character encoding of your database.
In the “importing” I had choose the UTF-8, because it´s how I write my posts… I will try to import it again in another encoding and see if it can be fixed.
Unfortunately, that’s a MySQL bug! It happens all the time when DB content is moved from one MySQL version to another or from one server to another.
(If you don’t beleive it just check around in this forum for posts before Dec 2005, having special characters: they are all screwed up!)
See if this helps:
http://wordpress.org/support/topic/55282?replies=15#post-303707
It worked!! Thanks a lot Moshu!! I was already thinking in export to another blog, and then import! hahahaha
😉
I have the same problem <http://sheffnersweb.net/?p=169>
Using cPanel’s File Manager I went to
/ public_html / wp-includes /
and edited the file
wp-db.php
by adding
mysql_query(“SET NAMES ‘utf8′”);
after the line
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
It now looks like this:
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_query(“SET NAMES ‘utf8′”);
if (!$this->dbh) {
$this->bail(“
<h1>Error establishing a database connection</h1>
Is this right?
Trouble is, it doesn’t fix my problem.
Can someone help me?
