Japanese converted to ????

  • I’ve discovered that some old posts on my blog containing Japanese have been converted to mojibake, and when I attempt to replace the Japanese with the correct text, Japanese is converted to “????” (a string of question marks) immediately after I hit the Update button.

    I tried disabling all my plugins in case that might somehow be involved; no change.

    I noticed that my config file showed the encoding as “utf8mb4”; changing that to utf8 did not help.

    The page I need help with: [log in to see the link]

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

  • Hi @adamrice,

    It seems like you are encountering issues with character encoding on your blog, specifically with Japanese text turning into mojibake (garbled characters) and further issues when updating the content.

    Just to make sure you have your wp-config.php set to :

    define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', 'utf8mb4_unicode_ci');

    If issue persists after setting the config above, you can try to check your collation settings on your phpMyAdmin. Make sure your collation settings is set to the recommended: utf8mb4_unicode_ci , you may check this article on how to set it.

    Make sure to backup your database before making any changes!

    All the best!

    Thread Starter adamrice

    (@adamrice)

    @nheeko —

    Thanks so much for your help. That did the trick. I did need to break into phpMyAdmin, and discovered an old table that had a mirror of all my tweets (from when I had a Twitter account), which I had to drop (no great loss) before I could successfully update the collation there.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Japanese converted to ????’ is closed to new replies.