Character Encoding Issue

  • Hi Folks,

    I’m trying to move my site from one server to another. It’s clear that I’m having a problem with my Character Encoding, but I just can’t seem to find a solution.

    I’ve tried adding a line of code to wp-db.php as per his post, but unfortunately it didn’t work for me.

    My situation:

    The site I’m trying to transfer lives here and I’m trying to transfer it here: https://66.246.183.4/~horsecan/.

    You will see in the posts on the destination site what exactly is happening with the Encoding.

    I’m exporting my database from MySQL4 and importing it to MySQL5, could this be a problem?

    After I downloaded my database, I made sure to open it in a text editor and save it as UTF-8, that doesn’t seem to be making a difference.

    Any ideas as to how I could solve this problem?

    Thanks in advance.

Viewing 4 replies - 1 through 4 (of 4 total)

  • The different versions of MySQL could be a problem.

    But make sure you check that not only the encoding (utf-8) is the same for the old and new database, but also the collation is the same!

    And finally, why are you opening the .sql file?

    MySQL5 can be a definite problem. Can you roll back to 4 and check it? I’ve had to do this many times on installs.

    edit – You may need to just wait until your domain name resolves.

    Thread Starter oh_hello

    (@oh_hello)

    I was opening the .sql file so I could switch all instances of my old domain. I’ll have to check with my host to see if we can roll back to 4.

    Also, something I just realized I forgot to mention…

    I’m creating the backup through the WordPress Database Backup plugin, because when I try the export through phpMyAdmin, it doesn’t export all my posts. I’m left with about a 60% export, everytime. Could this be related to the problem?

    Thread Starter oh_hello

    (@oh_hello)

    Update: I was talking to my webhost, and they can’t roll it back to MySQL4. They even took a shot at transferring the database for me, but didn’t have any luck.

    Are there any other ideas that may work?

    I appreciate the help so far, thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Character Encoding Issue’ is closed to new replies.