{"id":10456,"date":"2021-03-14T00:16:16","date_gmt":"2021-03-13T16:16:16","guid":{"rendered":"https:\/\/www.bookcard.net\/wordpress\/?p=10456"},"modified":"2021-03-14T01:10:28","modified_gmt":"2021-03-13T17:10:28","slug":"wordpress_mysql_utf8mb4","status":"publish","type":"post","link":"https:\/\/www.bookcard.net\/wordpress\/wordpress_mysql_utf8mb4\/","title":{"rendered":"WordPress\u4e4b\u90e8\u4efd\u6f22\u5b57\u5514\u5f97\u5b58\u6a94"},"content":{"rendered":"

\"Wordpress\u4e4b\u90e8\u4efd\u6f22\u5b57\u5514\u5f97\u5b58\u6a94\"<\/a>\u8fd1\u569f\u4fc2Wordpress\u5beb\u300e\ud863\udcd2\ud863\udcca\ud863\udd99\ud863\udccd\u95aa\u300f\u300e\ud847\udcde\u300f\u6f22\u5b57\u5514\u5f97\u5b58\u6a94,\u76f4\u63a5\u5c0dMYSQL\u5beb\u6f22\u5b57\u5f48\u300eWarning: #1366 Incorrect string value: ‘…’ for column ‘post_content’ at row 1\u300f.\u8868\u660e\u4fc2MYSQL\u7de8\u78bc\u95dc\u4fc2, \u56e0\u6f22\u5b57\u7686\u8f49\u70baUTF8\u7de8\u78bc,\u591a\u6578\u6f22\u5b57\u53603Byte,\u7d30\u5fc3\u7747\u300e\ud863\udcd2\ud863\udcca\ud863\udd99\ud863\udccd\u95aa\u300f\u300e\ud847\udcde\u300f\u53604Byte .\u6240\u4ee5MYSQL\u5148\u6709utf8mb4\u7de8\u78bc\u569f\u5b58\u6a944Byte\u7279\u6b8a\u5b57\u7b26.<\/p>\n

\u65e9\u5148Wordpress\u751f\u6210MYSQL\u6642\u4fc2utf8\u5f8c\u569f\u8f49\u5497utf8mb4. \u6240\u4ee5\u65e9\u5148Wordpress\u6f22\u5b57\u5514\u5f97\u5b58\u6a94.\u7747wp-config.php\u6587\u6a94.<\/p>\n

\u89e3\u51b3\u65b9\u6cd5\u552f\u6709\u5c07uft8_unicode_ci\u6539\u6210utf8mb4_unicode_ci<\/p>\n

 <\/p>\n

\u4f3a\u670d\u5668utf8mb4<\/p>\n

    \n
  1. \u767b\u5165phpMydamin<\/li>\n
  2. \u300e\u4e00\u822c\u8a2d\u5b9a\u300fGeneral Settings<\/li>\n
  3. \u6539\u300e\u4f3a\u670d\u5668\u9023\u7dda\u7de8\u78bc\u8207\u6392\u5e8f\u300fServer connection collation\u63c0 utf8mb4_unicode_ci<\/li>\n<\/ol>\n

     <\/p>\n

    \u8cc7\u6599\u8868utf8mb4<\/p>\n

      \n
    1. \u767b\u5165phpMydamin<\/li>\n
    2. \u300e\u4f3a\u670d\u5668\u300fserver->\u300e\u8cc7\u6599\u5eab\u300fDatabase<\/li>\n
    3. \u64b3\u300e\u7d50\u69cb\u300fStructure<\/li>\n
    4. \u52fe\u300e\u5168\u9078\u300fCheck<\/li>\n
    5. \u64b3\u300e\u64cd\u4f5c\u300fOperations<\/li>\n
    6. \u6539\u300e\u7de8\u78bc\u8207\u6392\u5e8f\u300fCollation\u63c0 utf8mb4_unicode_ci<\/li>\n
    7. \u52fe\u300e\u66f4\u6539\u6240\u6709\u8cc7\u6599\u8868\u7de8\u78bc\u8207\u6392\u5e8f\u300fChange all tables collations<\/li>\n
    8. \u52fe\u300e\u66f4\u6539\u6240\u6709\u8cc7\u6599\u8868\u6b04\u4f4d\u7de8\u78bc\u8207\u6392\u5e8f\u300fChange all tables collations collations<\/li>\n
    9. \u64b3\u300e\u57f7\u884c\u300fGO<\/li>\n<\/ol>\n

       <\/p>\n\n\n\n\n\n
      \u65e9\u5148wp-config.php<\/td>\n\u5f8c\u569fwp-config.php<\/td>\n<\/tr>\n
      define(‘DB_CHARSET’, ‘utf8’);<\/td>\ndefine(‘DB_CHARSET’, ‘utf8mb4’);<\/td>\n<\/tr>\n
      define(‘DB_COLLATE’, ”);<\/td>\ndefine(‘DB_CHARSET’, ‘utf8mb4_unicode_ci’);<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

       <\/p>\n\n\n\n\n
      Warning: #1366 Incorrect string value: ‘\\xF0\\xA8\\xB3\\x92\\xF0\\xA8…’ for column ‘post_content’ at row 1<\/td>\n<\/tr>\n
      Warning: #1366 Incorrect string value: ‘\\xF0\\xA8\\xB3\\x92\\xF0\\xA8…’ for column ‘post_title’ at row 1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

       <\/p>\n","protected":false},"excerpt":{"rendered":"

      \u8fd1\u569f\u4fc2Wordpress\u5beb\u300e\ud863\udcd2\ud863\udcca\ud863\udd99\ud863\udccd\u95aa\u300f\u300e\ud847\udcde\u300f\u6f22\u5b57\u5514\u5f97\u5b58\u6a94,\u76f4\u63a5\u5c0dMYSQL\u5beb\u6f22\u5b57\u5f48\u300eWarning: #13 … <\/p>\n

      \u7e7c\u7e8c\u95b1\u8b80 WordPress\u4e4b\u90e8\u4efd\u6f22\u5b57\u5514\u5f97\u5b58\u6a94<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[40],"class_list":["post-10456","post","type-post","status-publish","format-standard","hentry","category-history","tag-history","entry"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/posts\/10456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/comments?post=10456"}],"version-history":[{"count":2,"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/posts\/10456\/revisions"}],"predecessor-version":[{"id":10460,"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/posts\/10456\/revisions\/10460"}],"wp:attachment":[{"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/media?parent=10456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/categories?post=10456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bookcard.net\/wordpress\/wp-json\/wp\/v2\/tags?post=10456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}