{"id":31,"date":"2020-11-11T13:53:01","date_gmt":"2020-11-11T05:53:01","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/?p=31"},"modified":"2020-11-11T13:53:01","modified_gmt":"2020-11-11T05:53:01","slug":"%e5%ad%b8%e7%94%9futf-8%e5%b8%b3%e5%af%86%e6%aa%94%e6%a1%88%e6%ba%96%e5%82%99","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/2020\/11\/11\/%e5%ad%b8%e7%94%9futf-8%e5%b8%b3%e5%af%86%e6%aa%94%e6%a1%88%e6%ba%96%e5%82%99\/","title":{"rendered":"\u5b78\u751fUTF-8\u5e33\u5bc6\u6a94\u6848\u6e96\u5099"},"content":{"rendered":"<p>\u8001\u7239\u4f7f\u7528\u5b78\u751f\u5b78\u865f\u53ca\u59d3\u540d\u5408\u6210\u5e33\u865f\uff0c\u51fa\u751f\u5e74\u6708\u65e5\u7576\u6210\u5bc6\u78bc\uff0c\u5169\u7b46\u8cc7\u6599\u4ee5TAB\u5206\u9694\u65b9\u5f0f\u5b58\u6210UTF-8\u6587\u5b57\u6a94<br \/>\n\u8cc7\u6599\u4f86\u6e90\u70ba\u6821\u52d9\u7cfb\u7d71\uff0c\u8f49\u51fahtml\u683c\u5f0f\uff0c\u8907\u88fd\u5230EXCEL\uff0c\u5229\u7528\u6587\u5b57\u526a\u53d6\u8ddf\u5408\u4f75\u529f\u80fd\u88fd\u4f5c\u5e33\u5bc6<br \/>\n<img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-medium wp-image-32\" src=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list01a-296x300.png\" alt=\"\" width=\"296\" height=\"300\" srcset=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list01a-296x300.png 296w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list01a.png 478w\" sizes=\"(max-width: 296px) 100vw, 296px\" \/><br \/>\n\u8001\u7239\u7684\u6b0a\u9650\u53ea\u80fd\u6293\u5230\u9019\u7a2e\uff0c\u6240\u4ee5\u7528\u9019\u7a2e\u793a\u7bc4<br \/>\n\u5b78\u865f\u59d3\u540d\u5408\u4f75\u4f7f\u7528 =CONCAT(MID(A2,3,5),B2) \u6307\u4ee4<br \/>\n(\u570b\u5c0f\u521d\u5b78\u8005\u76f4\u63a5\u7528\u73ed\u7d1a\u5ea7\u865f\u5373\u53ef\uff0c\u4ee5\u514d\u5b78\u751f\u4e0d\u6703\u6253\u4e2d\u6587\uff0c\u5f92\u589e\u56f0\u64fe)<br \/>\n\u62bd\u53d6\u51fa\u751f\u5e74\u6708\u65e5\u4f7f\u7528 =CONCAT(MID(C2,3,2),MID(C2,6,2),MID(C2,9,2)) \u6307\u4ee4<br \/>\n(100\u5e74\u4ee5\u5f8c\u51fa\u751f\u5efa\u8b70\u51fa\u751f\u5e74\u6293\u4e09\u78bc\uff0c\u6307\u4ee4\u8981\u6539)<br \/>\n<img decoding=\"async\" class=\"alignnone size-medium wp-image-33\" src=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list03a-214x300.png\" alt=\"\" width=\"214\" height=\"300\" srcset=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list03a-214x300.png 214w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list03a.png 335w\" sizes=\"(max-width: 214px) 100vw, 214px\" \/><br \/>\n\u5c07\u6240\u6709\u7522\u751f\u7684\u5e33\u5bc6\u8907\u88fd\u5230\u65b0\u7684\u5de5\u4f5c\u8868<br \/>\n<img decoding=\"async\" class=\"alignnone size-medium wp-image-34\" src=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list06a-300x181.png\" alt=\"\" width=\"300\" height=\"181\" srcset=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list06a-300x181.png 300w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list06a-768x462.png 768w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list06a.png 786w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><br \/>\n\u53e6\u5b58\u65b0\u6a94\uff0c\u5b58\u6a94\u985e\u578b\u6539\u70ba Unicode\u6587\u5b57<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-35\" src=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list07a-300x156.png\" alt=\"\" width=\"300\" height=\"156\" srcset=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list07a-300x156.png 300w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list07a-1024x533.png 1024w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list07a-768x400.png 768w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list07a.png 1186w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><br \/>\n\u9ede\u958b\u6587\u5b57\u6a94\uff0c\u53f3\u4e0b\u89d2\u6703\u770b\u5230 UTF-16 LE<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-36\" src=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list08a-300x181.png\" alt=\"\" width=\"300\" height=\"181\" srcset=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list08a-300x181.png 300w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list08a-768x462.png 768w, https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-content\/uploads\/sites\/2728\/2020\/11\/list08a.png 786w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><br \/>\n\u518d\u53e6\u5b58\u65b0\u6a94\u4e00\u6b21\uff0c\u7de8\u78bc\u628a\u5b83\u6539\u70ba UTF-8 \u5b58\u6a94\u5b8c\u6210<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8001\u7239\u4f7f\u7528\u5b78\u751f\u5b78\u865f\u53ca\u59d3\u540d\u5408\u6210\u5e33\u865f\uff0c\u51fa\u751f\u5e74\u6708\u65e5\u7576\u6210\u5bc6\u78bc\uff0c\u5169\u7b46\u8cc7\u6599\u4ee5TAB\u5206\u9694\u65b9\u5f0f\u5b58\u6210UTF-8\u6587\u5b57\u6a94 \u8cc7\u6599\u4f86\u6e90\u70ba\u6821 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/2020\/11\/11\/%e5%ad%b8%e7%94%9futf-8%e5%b8%b3%e5%af%86%e6%aa%94%e6%a1%88%e6%ba%96%e5%82%99\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008\u5b78\u751fUTF-8\u5e33\u5bc6\u6a94\u6848\u6e96\u5099\u3009<\/span><\/a><\/p>\n","protected":false},"author":2960,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-31","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"meta_key":{"_edit_lock":["1605084062:2960"],"_edit_last":["2960"],"_wp_page_template":["default"],"_encloseme":["1"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/posts\/31"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/users\/2960"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/comments?post=31"}],"version-history":[{"count":1,"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":37,"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/posts\/31\/revisions\/37"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/media?parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/categories?post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/ghcat2020\/wp-json\/wp\/v2\/tags?post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}