{"id":66,"date":"2026-11-19T00:05:05","date_gmt":"2026-11-18T16:05:05","guid":{"rendered":"https:\/\/www.scotthk.com\/?p=66"},"modified":"2026-11-19T00:06:19","modified_gmt":"2026-11-18T16:06:19","slug":"%e7%8f%be%e4%bb%a3%e8%b3%87%e6%96%99%e5%ba%ab%e7%94%a8%e4%bb%80%e9%ba%bc%e7%b7%a8%e7%a2%bc%e6%98%af%e6%9c%80%e5%a5%bd","status":"publish","type":"post","link":"https:\/\/www.scotthk.com\/?p=66","title":{"rendered":"\u8cc7\u6599\u5eab\u7528\u4ec0\u9ebc\u7de8\u78bc\u662f\u6700\u597d"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u73fe\u4ee3\u8cc7\u6599\u5eab\u516c\u8a8d\u6700\u597d\u7684\u5b57\u5143\u7de8\u78bc\u662f <strong>UTF-8<\/strong>\uff08\u5728 MySQL \u8207 MariaDB \u4e2d\u5177\u9ad4\u7a31\u70ba <strong>utf8mb4<\/strong>\uff09\u3002\u5b83\u80fd\u5b8c\u6574\u652f\u63f4\u5168\u7403\u6240\u6709\u8a9e\u8a00\u6587\u5b57\u3001\u7279\u6b8a\u7b26\u865f\u4ee5\u53ca Emoji\uff0c\u4e26\u5177\u5099\u6975\u4f73\u7684\u5132\u5b58\u6548\u7387\u8207\u8de8\u7cfb\u7d71\u76f8\u5bb9\u6027\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u70ba\u4ec0\u9ebc\u9078\u64c7 UTF-8\uff1f<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u5168\u7403\u8a9e\u8a00\u8207 Emoji \u652f\u63f4\u3002<\/strong> UTF-8 \u6db5\u84cb\u4e86\u5b8c\u6574\u7684 Unicode \u5b57\u5143\u96c6\uff0c\u80fd\u6b63\u78ba\u5132\u5b58\u7e41\u9ad4\u4e2d\u6587\u3001\u7c21\u9ad4\u4e2d\u6587\u3001\u65e5\u97d3\u6587\u3001\u5404\u570b\u8a9e\u8a00\u4ee5\u53ca\u73fe\u4ee3\u61c9\u7528\u5fc5\u5099\u7684 Emoji \u8868\u60c5\u7b26\u865f\u3002<\/li>\n\n\n\n<li><strong>\u5132\u5b58\u7a7a\u9593\u5f48\u6027\u9ad8\u3002<\/strong> \u5b83\u63a1\u7528\u53ef\u8b8a\u9577\u5ea6\u7de8\u78bc\uff081 \u5230 4 \u500b\u4f4d\u5143\u7d44\uff09\uff0c\u82f1\u6578\u5b57\u5143\u53ea\u4f54 1 \u500b\u4f4d\u5143\u7d44\uff0c\u4e2d\u6587\u5b57\u5143\u901a\u5e38\u4f54 3 \u500b\u4f4d\u5143\u7d44\uff0c\u5927\u5e45\u7bc0\u7701\u5132\u5b58\u7a7a\u9593\u8207\u7db2\u8def\u50b3\u8f38\u983b\u5bec\u3002<\/li>\n\n\n\n<li><strong>\u73fe\u4ee3\u7db2\u8def\u6a19\u6e96\u4e00\u81f4\u3002<\/strong> \u7db2\u9801\uff08HTML5\uff09\u3001API\uff08JSON\uff09\u8207\u5404\u5927\u7a0b\u5f0f\u8a9e\u8a00\u9810\u8a2d\u7686\u4f7f\u7528 UTF-8\uff0c\u8cc7\u6599\u5eab\u63a1\u7528\u76f8\u540c\u7de8\u78bc\u53ef\u514d\u9664\u8f49\u78bc\u904e\u7a0b\uff0c\u5fb9\u5e95\u907f\u514d\u4e82\u78bc\u98a8\u96aa\u3002<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e3b\u6d41\u8cc7\u6599\u5eab\u7684\u63a8\u85a6\u8a2d\u5b9a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\u8cc7\u6599\u5eab\u7cfb\u7d71<\/th><th>\u63a8\u85a6\u5b57\u5143\u96c6 (Character Set)<\/th><th>\u63a8\u85a6\u6392\u5e8f\u898f\u5247 (Collation)<\/th><th>\u6ce8\u610f\u4e8b\u9805<\/th><\/tr><tr><td><strong>MySQL \/ MariaDB<\/strong><\/td><td><code>utf8mb4<\/code><\/td><td><code>utf8mb4_unicode_ci<\/code> \u6216 <code>utf8mb4_0900_ai_ci<\/code><\/td><td>\u5207\u52ff\u4f7f\u7528\u820a\u7248\u7684 <code>utf8<\/code>\uff08\u50c5\u652f\u63f4 3 \u4f4d\u5143\u7d44\uff09\uff0c\u5426\u5247\u5b58\u5165 Emoji \u6216\u751f\u50fb\u5b57\u6703\u5831\u932f\u6216\u907a\u5931\u8cc7\u6599\u3002<\/td><\/tr><tr><td><strong>PostgreSQL<\/strong><\/td><td><code>UTF8<\/code><\/td><td><code>en_US.UTF-8<\/code> \u6216 <code>C.UTF-8<\/code><\/td><td>\u5efa\u7acb\u8cc7\u6599\u5eab\u6642\u7684\u9810\u8a2d\u6a19\u6e96\uff0c\u5c0d\u591a\u570b\u8a9e\u8a00\u8207\u8907\u96dc\u5b57\u5143\u652f\u63f4\u5ea6\u6975\u4f73\u3002<\/td><\/tr><tr><td><strong>SQL Server<\/strong><\/td><td><code>UTF-8<\/code>\uff08\u914d\u5408 <code>VARCHAR<\/code>\uff09\u6216 <code>NVARCHAR<\/code><\/td><td>\u5c0d\u61c9\u652f\u63f4 <code>_UTF8<\/code> \u7684\u5b9a\u5e8f\uff08\u5982 <code>Chinese_Taiwan_Stroke_CI_AS_KS_WS_SC_UTF8<\/code>\uff09<\/td><td>SQL Server 2019 \u8d77\u5728 <code>VARCHAR<\/code> \u6b04\u4f4d\u5b8c\u6574\u652f\u63f4 UTF-8\uff0c\u517c\u9867\u76f8\u5bb9\u6027\u8207\u7a7a\u9593\u6548\u7387\u3002<\/td><\/tr><tr><td><strong>SQLite \/ MongoDB<\/strong><\/td><td>\u9810\u8a2d <code>UTF-8<\/code><\/td><td>\u9810\u8a2d\u4e8c\u9032\u4f4d\u6216\u6a19\u6e96\u6392\u5e8f<\/td><td>\u5169\u8005\u5e95\u5c64\u7686\u539f\u751f\u4ee5 UTF-8 \u8655\u7406\u5b57\u4e32\uff0c\u901a\u5e38\u7121\u9700\u984d\u5916\u8abf\u6574\u3002<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5be6\u52d9\u8a2d\u5b9a\u5efa\u8b70<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u7d71\u4e00\u5168\u93c8\u8def\u7de8\u78bc\u3002<\/strong> \u9664\u4e86\u8cc7\u6599\u5eab\u8207\u8cc7\u6599\u8868\u672c\u8eab\uff0c\u61c9\u7528\u7a0b\u5f0f\u9023\u7dda\u5b57\u4e32\uff08Connection String\uff09\u4e5f\u5fc5\u9808\u660e\u78ba\u6307\u5b9a\u70ba <code>utf8mb4<\/code> \u6216 <code>UTF-8<\/code>\u3002<\/li>\n\n\n\n<li><strong>\u7559\u610f\u6392\u5e8f\u898f\u5247\uff08Collation\uff09\u3002<\/strong> \u82e5\u7cfb\u7d71\u9700\u8981\u5340\u5206\u5927\u5c0f\u5beb\u6216\u7279\u5b9a\u8a9e\u7cfb\u7684\u7b46\u5283\u6392\u5e8f\uff0c\u5efa\u7acb\u8cc7\u6599\u8868\u6642\u61c9\u4f9d\u64da\u696d\u52d9\u9700\u6c42\u6311\u9078\u5c0d\u61c9\u7684 <code>_cs<\/code>\uff08\u5340\u5206\u5927\u5c0f\u5beb\uff09\u6216 <code>_ci<\/code>\uff08\u4e0d\u5340\u5206\u5927\u5c0f\u5beb\uff09\u5b9a\u5e8f\u3002<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8cc7\u6599\u5eab\u516c\u8a8d\u6700\u597d\u7684\u5b57\u5143\u7de8\u78bc\u662f UTF-8\uff08\u5728 MySQL \u8207 MariaDB \u4e2d\u5177\u9ad4\u7a31\u70ba utf8mb4\uff09\u3002\u5b83\u80fd\u5b8c\u6574\u652f\u63f4\u5168\u7403\u6240\u6709\u8a9e\u8a00\u6587\u5b57\u3001\u7279\u6b8a\u7b26\u865f\u4ee5\u53ca Emoji\uff0c\u4e26\u5177\u5099\u6975\u4f73\u7684\u5132\u5b58\u6548\u7387\u8207\u8de8\u7cfb\u7d71\u76f8\u5bb9\u6027\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,9,3],"tags":[12,13],"class_list":["post-66","post","type-post","status-publish","format-standard","hentry","category-linux","category-networking","category-computer-knowledge","tag-linux","tag-networking"],"_links":{"self":[{"href":"https:\/\/www.scotthk.com\/index.php?rest_route=\/wp\/v2\/posts\/66","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scotthk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scotthk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scotthk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scotthk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=66"}],"version-history":[{"count":2,"href":"https:\/\/www.scotthk.com\/index.php?rest_route=\/wp\/v2\/posts\/66\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/www.scotthk.com\/index.php?rest_route=\/wp\/v2\/posts\/66\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/www.scotthk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=66"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scotthk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=66"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scotthk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}