Chinese Problems

  • Hi there,

    My story goes like this:

    Installed WordPress on new server.

    Backed up old WordPress from old server using the backup plugin.

    Altered the database settings on the new server so it uses UTF8 as standard.

    Imported the backup using phpMyAdmin.

    The data is showing up as perfectly readable Chinese in phpMyAdmin – but when outputted via WordPress it’s all ?????? question marks.

    Any help?

    James

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

  • edit this file wp-includes/wp-db.php

    $this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
    //add the follow sentence
    $this->query(“SET NAMES ‘utf8′”);

    save
    empty cache

    Tried that so it looks like this in the coding

    $this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
    $this->query(“SET NAMES ‘utf8′”);
    if (!$this->dbh) {
    $this->bail(“

    Still didn’t work, though. Is the above correct?

    Your first mistake was to alter “the database settings on the new server”. Did your old server have the same settings? It sounds very much as a mismatch between the old and new database setting.

    Oops, sorry, I just realized, you are not the OP.

    Moshu,

    You lost me on the respond. I didn’t alter the database settings I thought; just added the sentence you mentioned.

    JC

    Jcchris,

    can i ask you, for your old server, you manage to have chinese words posted on your site? i.e. a post can have both english and mandarin characters? how did you manage to do it?

    cos i just newly installed wordpress, imported all my entries from blogger, but my chinese characters all became ???

    i tried looking in the forums and language plugins, but most of them are for translating the entire site or posts into different langauge, which is not what i want. I would like to be able to posts in multiple language.

    Can you help?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Chinese Problems’ is closed to new replies.