内容的栏目 * @param int $category 0列表 1频道 2单页 3外链 * @return array */ function category_list($forumlist, $model = 0, $display = 0, $category = 0) { if (empty($forumlist)) return NULL; static $cache = array(); $key = $model . '-' . $display . '-' . $category; if (isset($cache[$key])) return $cache[$key]; if ($display) { foreach ($forumlist as $k => $val) { if (1 == $val['display'] && 1 == $val['type'] && $val['category'] == $category) { $cache[$key][$k] = $val; } } } else { foreach ($forumlist as $k => $val) { if (1 == $val['type'] && $val['category'] == $category) { $cache[$key][$k] = $val; } } } return empty($cache[$key]) ? NULL : $cache[$key]; } /** * @param $forumlist 所有版块列表 不分模型 * @param int $display 0全部CMS栏目 1在首页和频道显示内容的栏目 * @param int $category 0列表 1频道 2单页 3外链 * @return array */ function category_list_show($forumlist, $display = 0, $category = 0) { if (empty($forumlist)) return NULL; static $cache = array(); $key = $display . '-' . $category; if (isset($cache[$key])) return $cache[$key]; if ($display) { foreach ($forumlist as $k => $val) { if (1 == $val['display'] && 1 == $val['type'] && $val['category'] == $category) { $cache[$key][$k] = $val; } } } else { foreach ($forumlist as $k => $val) { if (1 == $val['type'] && $val['category'] == $category) { $cache[$key][$k] = $val; } } } return empty($cache[$key]) ? NULL : $cache[$key]; } /** * @param $forumlist 所有版块列表 * @return mixed BBS栏目数据(仅列表) 尚未开放bbs频道功能 */ function forum_list($forumlist) { if (empty($forumlist)) return array(); static $cache = array(); if (isset($cache['bbs_forum_list'])) return $cache['bbs_forum_list']; $cache['bbs_forum_list'] = array(); foreach ($forumlist as $_fid => $_forum) { if ($_forum['type']) continue; $cache['bbs_forum_list'][$_fid] = $_forum; } return $cache['bbs_forum_list']; } // 导航显示的版块 function nav_list($forumlist) { if (empty($forumlist)) return NULL; static $cache = array(); if (isset($cache['nav_list'])) return $cache['nav_list']; foreach ($forumlist as $fid => $forum) { if (0 == $forum['nav_display']) { unset($forumlist[$fid]); } } return $cache['nav_list'] = $forumlist; } ?>encoding - Strange characters - despite everything being UTF-8

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>encoding - Strange characters - despite everything being UTF-8

    encoding - Strange characters - despite everything being UTF-8

    programmeradmin0浏览0评论

    Not sure why this thread was closed, but this is the same issue inflicting many people.

    All my WP config settings are in order: 

    //define('DB_CHARSET', 'utf8');
//define('DB_CHARSET', 'utf8_unicode_ci');
//define('DB_COLLATE', '');

    I even tried enabling them one by one. None worked.

    When I save a post, weird characters appear in place of apostrophes and spaces. This happens whether I type content manually or

    I've tried a few plugins.

    1. UTF-8 Sanitize
    2. Convert WP to UTF-8

    ..etc.

    None of them work. The problem persists.

    I've also changed the database's character set and collation in MYSQL. Screenshot:

    This is a screenshot of me entering some content by pasting it:

    But immediately upon saving, the text comes back with garbled characters having replaced it:

    What else?

    I went through the rigmarole of dumping the entire MySQL DB, then removing all older non-utf8 characters via TR command. 

    tr -cd '\11\12\15\40-\176' < file-with-binary-chars > clean-file

    Where the file-with-binary-chars was the MySQL dump. Then I restored the table.

    My MySQL config is all utf8: 

    [client]
default-character-set=utf8

[mysqld]
character-set-client=utf8
collation-server=utf8_unicode_ci
character-set-server=utf8

    My browser is Chrome. The encoding is UTF-8 (in the VIEW menu).

    What else can I do? Do I need to make all the plugin files utf-8 as well?

    FYI, this blog is one of the Wordpress blogs. There are other newer Wordpress installations on the same server using the same installation of MySQL 5.6.17, but they don't have such an issue. My guess is that this being an older blog may have some variations in the text entered long ago, but frankly after having done all of the above, I really don't know what else I can do.

    Thanks for any inputs or pointers!

    Not sure why this thread was closed, but this is the same issue inflicting many people.

    All my WP config settings are in order: 

    //define('DB_CHARSET', 'utf8');
//define('DB_CHARSET', 'utf8_unicode_ci');
//define('DB_COLLATE', '');

    I even tried enabling them one by one. None worked.

    When I save a post, weird characters appear in place of apostrophes and spaces. This happens whether I type content manually or

    I've tried a few plugins.

    1. UTF-8 Sanitize
    2. Convert WP to UTF-8

    ..etc.

    None of them work. The problem persists.

    I've also changed the database's character set and collation in MYSQL. Screenshot:

    This is a screenshot of me entering some content by pasting it:

    But immediately upon saving, the text comes back with garbled characters having replaced it:

    What else?

    I went through the rigmarole of dumping the entire MySQL DB, then removing all older non-utf8 characters via TR command. 

    tr -cd '\11\12\15\40-\176' < file-with-binary-chars > clean-file

    Where the file-with-binary-chars was the MySQL dump. Then I restored the table.

    My MySQL config is all utf8: 

    [client]
default-character-set=utf8

[mysqld]
character-set-client=utf8
collation-server=utf8_unicode_ci
character-set-server=utf8

    My browser is Chrome. The encoding is UTF-8 (in the VIEW menu).

    What else can I do? Do I need to make all the plugin files utf-8 as well?

    FYI, this blog is one of the Wordpress blogs. There are other newer Wordpress installations on the same server using the same installation of MySQL 5.6.17, but they don't have such an issue. My guess is that this being an older blog may have some variations in the text entered long ago, but frankly after having done all of the above, I really don't know what else I can do.

    Thanks for any inputs or pointers!

    • encoding
    • characters
    Share Improve this question edited Apr 13, 2017 at 12:37 CommunityBot 1 asked Aug 3, 2014 at 4:51 PKHunterPKHunter 2771 gold badge5 silver badges9 bronze badges 1
    • Just to add, now I've also made sure all the plugins and themes files have their text in UTF8. This is the code I used: gist.github/anonymous/6761e2142c214fb6ef4a – PKHunter Commented Aug 3, 2014 at 5:09
    Add a comment  | 

    6 Answers 6

    Reset to default 9

    This is typically caused when you are copying/pasting MS Word information into the WordPress content editor. WordPress uses something called "Smart Quotes", via a function named wptexturize().

    Ideal Solution

    The ideal solution would be to go back through your content, and replace all single/double quotes using the keyboard.

    However, if you're working with massive copy/pastes, this may not be feasible.

    Disable wptexturize() Filter

    Another option is to disable the wptexturize() filter from running; which can be accomplished by placing the following code in your child theme functions.php file:

    remove_filter('the_content', 'wptexturize');

    You may also wish to remove the filter from comments and/or excerpts:

    remove_filter('comment_text', 'wptexturize');
remove_filter('the_excerpt', 'wptexturize');

    Or for titles:

    remove_filter ('single_post_title', 'wptexturize');
remove_filter ('the_title', 'wptexturize');
remove_filter ('wp_title', 'wptexturize');

    Clean Database

    For existing content which has already saved the "weird" characters into the database; you may need to clean the database by running the following queries from PHPMyAdmin (be sure to take a database backup first):

    UPDATE wp_posts SET post_content = REPLACE(post_content, '“', '“');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'â€', '”');
UPDATE wp_posts SET post_content = REPLACE(post_content, '’', '’');
UPDATE wp_posts SET post_content = REPLACE(post_content, '‘', '‘');
UPDATE wp_posts SET post_content = REPLACE(post_content, '—', '–');
UPDATE wp_posts SET post_content = REPLACE(post_content, '–', '—');
UPDATE wp_posts SET post_content = REPLACE(post_content, '•', '-');
UPDATE wp_posts SET post_content = REPLACE(post_content, '…', '…');

    Plugins

    Well... it's WordPress. You can always use a plugin to help manage the wptexturize() filter. Take a look through This List, and see if one is right for you.

    I was facing the same exact problem.

    I tried everything just like you and at the end I tried one last thing.

    Changed the DB_CHARSET in wp-config file to latin1.

    And things worked :/

    define('DB_CHARSET', 'latin1');
define('DB_COLLATE', 'utf8mb4_general_ci');

    In another case, if you are using PHP Dom (loadHTML) somewhere, there is a need to load HTML as UTF-8. I have fixed it by:

    Replacing

    @$dom->loadHTML($html);

    to

    @$dom->loadHTML('<?xml encoding="UTF-8">' . $html);

    The following fixed it for me, so posting here to share. Even though I ran the SQL updates suggested, I was still getting the funny symbols before the "read more" links.

    I'm totally shocked. After hours of trying things and testing, I finally found the "Settings" then "Readings" option below: "Encoding for pages and feeds". After changing from UTF-7 to UTF-8, everything looks good again.

    And even stranger, after changing it to UTF-8, the option disappears from the page. According to WordPress site, this option was removed since release 3.5.

    The issue can cause by the plugins and direct FTP uploads.

    Here's the detail:

    http://iiiji/wordpress-appearing-weird-characterscode/

    In my case the strange characters weren't written to the database. Check if the raw SQL is showing the incorrect characters as well. If you're seeing regular apostrophes in the database, comment out the following two lines in the wp-config.php:

    // define('DB_CHARSET', 'utf8');
// define('DB_COLLATE', '');

    That fixed it for me right away.

    "This character encoding problem can happen after a database upgrade" - Link

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论