WordPress站点文章出现替换字符�，请求技术问题排查

Hey there, let's break down that frustrating � character showing up in your WordPress posts—this is almost always tied to character encoding mismatches, and since it's only affecting posts (not pages), database-level issues are the first thing we should check.

Why This Is Likely a Database Problem #

WordPress relies on utf8mb4 (a UTF-8 variant that supports emojis, special symbols, and non-Latin characters) for its database by default. Here's why posts might get messed up while pages stay fine:

• The wp_posts table (where both posts and pages are stored) might have inconsistent character set settings for post-specific fields like post_content. If this field is stuck on an older charset like utf8 (not utf8mb4) or has a mismatched collation, special characters can get corrupted into � when saved.
• Pages might have simpler content with fewer special characters, or you might have created them in a more consistent encoding environment—while posts could have been imported, copied from external sources (like Word docs or non-UTF-8 websites), or edited in a way that triggered the encoding conflict.

Step-by-Step Troubleshooting & Fixes #

1. Check Your Database Table & Field Encoding #

Grab your database admin tool (like phpMyAdmin or Adminer) and follow these steps:

• First, back up your database—always do this before making changes!
• Navigate to your WordPress database, then look at the wp_posts table.
• Check the character set and collation for the post_content, post_title, and post_excerpt fields. They should all be set to utf8mb4 with a collation like utf8mb4_unicode_ci.
• If they're not, run this SQL query (replace wp_ with your actual database prefix if you changed it):

  ALTER TABLE wp_posts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  

2. Verify Your wp-config.php Settings #

Open your site's wp-config.php file (in the root directory) and make sure these lines exist and are correct:

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

If you see utf8 instead of utf8mb4, update it, save the file, and refresh your site to see if the � goes away.

3. Rule Out Editor/Import Issues #

• Try creating a brand new test post, typing content manually (no copy-pasting from external sites/docs). If the � doesn't show up, the problem was likely tied to how you added the original posts.
• If you imported posts in bulk, double-check the import tool's encoding settings—make sure it's set to utf8mb4 or UTF-8 to avoid corrupting content during import.

4. Check Server-Level Encoding #

Some web servers have a default PHP character set that's not UTF-8, which can cause encoding mismatches when saving content. You can force UTF-8 output by adding this snippet to your theme's functions.php file:

add_action('init', function() {
    header('Content-Type: text/html; charset=utf-8');
});

If that doesn't help, reach out to your hosting provider to confirm their server's default character set is set to UTF-8.

Final Notes #

Start with the database checks—those are the most probable fix for your specific scenario (posts affected, pages not). And again, don't skip backing up your database before making any changes!

内容的提问来源于stack exchange，提问作者RLCS