WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Problem with simbols when moving it to another server (6 posts)

  1. Jaqueline
    Member
    Posted 7 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

  2. maerk
    Member
    Posted 7 years ago #

    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.

  3. Jaqueline
    Member
    Posted 7 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.

  4. moshu
    Member
    Posted 7 years ago #

    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

  5. Jaqueline
    Member
    Posted 7 years ago #

    It worked!! Thanks a lot Moshu!! I was already thinking in export to another blog, and then import! hahahaha

    ;-)

  6. sheffner
    Member
    Posted 7 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?

Topic Closed

This topic has been closed to new replies.

About this Topic