Posted 5 years ago #
Hello all!
I´m moving my website to another server, so, many things to change, but one problem I can´t find a solution: my website is in portuguese, so, I use many simbols like ç, õ, ã... and when I made the transfer they all turned into "?". What can I do to fix it? I used the SCR to change the domain name in the SQL, maybe it was the problem?
Thanks for any help! :-)
website: http://www.maismoda.net
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.
Posted 5 years ago #
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
Posted 5 years ago #
It worked!! Thanks a lot Moshu!! I was already thinking in export to another blog, and then import! hahahaha
;-)
Posted 4 years ago #
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?
This topic has been closed to new replies.
