{"id":833,"date":"2007-05-03T22:17:26","date_gmt":"2007-05-03T22:17:26","guid":{"rendered":"http:\/\/www.icocean.com\/blog\/?p=833"},"modified":"1970-01-01T07:00:00","modified_gmt":"1970-01-01T07:00:00","slug":"mysql%E5%AD%97%E7%AC%A6%E9%9B%86%E7%BC%96%E7%A0%81","status":"publish","type":"post","link":"https:\/\/www.icocean.com\/blog\/?p=833","title":{"rendered":"mysql\u5b57\u7b26\u96c6\u7f16\u7801"},"content":{"rendered":"<p>mysql\u5b57\u7b26\u96c6\u7f16\u7801<\/p>\n<p>\u5b57\u7b26\u96c6\u548c\u6574\u7406<br \/>\u6574\u7406 \u63cf\u8ff0<br \/>armscii8 (ARMSCII-8 Armenian)<br \/>armscii8_bin \u4e9a\u7f8e\u5c3c\u4e9a\u8bed, \u4e8c\u8fdb\u5236<br \/>armscii8_general_ci \u4e9a\u7f8e\u5c3c\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ascii (US ASCII)<br \/>ascii_bin \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>ascii_general_ci \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>big5 (Big5 Traditional Chinese)<br \/>big5_bin \u7e41\u4f53\u4e2d\u6587, \u4e8c\u8fdb\u5236<br \/>big5_chinese_ci \u7e41\u4f53\u4e2d\u6587, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>binary (Binary pseudo charset)<br \/>binary \u4e8c\u8fdb\u5236<br \/>cp1250 (Windows Central European)<!--more--><br \/>cp1250_bin \u4e2d\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>cp1250_croatian_ci \u514b\u7f57\u5730\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp1250_czech_cs \u6377\u514b\u8bed, \u533a\u5206\u5927\u5c0f\u5199<br \/>cp1250_general_ci \u4e2d\u6b27 (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp1251 (Windows Cyrillic)<br \/>cp1251_bin \u897f\u91cc\u5c14\u8bed (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>cp1251_bulgarian_ci \u4fdd\u52a0\u5229\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp1251_general_ci \u897f\u91cc\u5c14\u8bed (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp1251_general_cs \u897f\u91cc\u5c14\u8bed (\u591a\u8bed\u8a00), \u533a\u5206\u5927\u5c0f\u5199<br \/>cp1251_ukrainian_ci \u4e4c\u514b\u5170\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp1256 (Windows Arabic)<br \/>cp1256_bin \u963f\u62c9\u4f2f\u8bed, \u4e8c\u8fdb\u5236<br \/>cp1256_general_ci \u963f\u62c9\u4f2f\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp1257 (Windows Baltic)<br \/>cp1257_bin \u5df4\u62c9\u514b\u8bed (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>cp1257_general_ci \u5df4\u62c9\u514b\u8bed (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp1257_lithuanian_ci \u7acb\u9676\u5b9b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp850 (DOS West European)<br \/>cp850_bin \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>cp850_general_ci \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp852 (DOS Central European)<br \/>cp852_bin \u4e2d\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>cp852_general_ci \u4e2d\u6b27 (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp866 (DOS Russian)<br \/>cp866_bin \u4fc4\u8bed, \u4e8c\u8fdb\u5236<br \/>cp866_general_ci \u4fc4\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>cp932 (SJIS for Windows Japanese)<br \/>cp932_bin \u65e5\u8bed, \u4e8c\u8fdb\u5236<br \/>cp932_japanese_ci \u65e5\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>dec8 (DEC West European)<br \/>dec8_bin \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>dec8_swedish_ci \u745e\u5178\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>eucjpms (UJIS for Windows Japanese)<br \/>eucjpms_bin \u65e5\u8bed, \u4e8c\u8fdb\u5236<br \/>eucjpms_japanese_ci \u65e5\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>euckr (EUC-KR Korean)<br \/>euckr_bin \u671d\u9c9c\u8bed, \u4e8c\u8fdb\u5236<br \/>euckr_korean_ci \u671d\u9c9c\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>gb2312 (GB2312 Simplified Chinese)<br \/>gb2312_bin \u7b80\u4f53\u4e2d\u6587, \u4e8c\u8fdb\u5236<br \/>gb2312_chinese_ci \u7b80\u4f53\u4e2d\u6587, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>gbk (GBK Simplified Chinese)<br \/>gbk_bin \u7b80\u4f53\u4e2d\u6587, \u4e8c\u8fdb\u5236<br \/>gbk_chinese_ci \u7b80\u4f53\u4e2d\u6587, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>geostd8 (GEOSTD8 Georgian)<br \/>geostd8_bin \u4e54\u6cbb\u4e9a\u8bed, \u4e8c\u8fdb\u5236<br \/>geostd8_general_ci \u4e54\u6cbb\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>greek (ISO 8859-7 Greek)<br \/>greek_bin \u5e0c\u814a\u8bed, \u4e8c\u8fdb\u5236<br \/>greek_general_ci \u5e0c\u814a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>hebrew (ISO 8859-8 Hebrew)<br \/>hebrew_bin \u5e0c\u4f2f\u6765\u8bed, \u4e8c\u8fdb\u5236<br \/>hebrew_general_ci \u5e0c\u4f2f\u6765\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>hp8 (HP West European)<br \/>hp8_bin \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>hp8_english_ci \u82f1\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>keybcs2 (DOS Kamenicky Czech-Slovak)<br \/>keybcs2_bin \u6377\u514b\u65af\u6d1b\u4f10\u514b\u8bed, \u4e8c\u8fdb\u5236<br \/>keybcs2_general_ci \u6377\u514b\u65af\u6d1b\u4f10\u514b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>koi8r (KOI8-R Relcom Russian)<br \/>koi8r_bin \u4fc4\u8bed, \u4e8c\u8fdb\u5236<br \/>koi8r_general_ci \u4fc4\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>koi8u (KOI8-U Ukrainian)<br \/>koi8u_bin \u4e4c\u514b\u5170\u8bed, \u4e8c\u8fdb\u5236<br \/>koi8u_general_ci \u4e4c\u514b\u5170\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin1 (cp1252 West European)<br \/>latin1_bin \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>latin1_danish_ci \u4e39\u9ea6\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin1_general_ci \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin1_general_cs \u897f\u6b27 (\u591a\u8bed\u8a00), \u533a\u5206\u5927\u5c0f\u5199<br \/>latin1_german1_ci \u5fb7\u8bed (\u5b57\u5178), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin1_german2_ci \u5fb7\u8bed (\u7535\u8bdd\u672c), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin1_spanish_ci \u897f\u73ed\u7259\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin1_swedish_ci \u745e\u5178\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>\u6574\u7406 \u63cf\u8ff0<br \/>latin2 (ISO 8859-2 Central European)<br \/>latin2_bin \u4e2d\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>latin2_croatian_ci \u514b\u7f57\u5730\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin2_czech_cs \u6377\u514b\u8bed, \u533a\u5206\u5927\u5c0f\u5199<br \/>latin2_general_ci \u4e2d\u6b27 (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin2_hungarian_ci \u5308\u7259\u5229\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin5 (ISO 8859-9 Turkish)<br \/>latin5_bin \u571f\u8033\u5176\u8bed, \u4e8c\u8fdb\u5236<br \/>latin5_turkish_ci \u571f\u8033\u5176\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin7 (ISO 8859-13 Baltic)<br \/>latin7_bin \u5df4\u62c9\u514b\u8bed (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>latin7_estonian_cs \u7231\u6c99\u5c3c\u4e9a\u8bed, \u533a\u5206\u5927\u5c0f\u5199<br \/>latin7_general_ci \u5df4\u62c9\u514b\u8bed (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>latin7_general_cs \u5df4\u62c9\u514b\u8bed (\u591a\u8bed\u8a00), \u533a\u5206\u5927\u5c0f\u5199<br \/>macce (Mac Central European)<br \/>macce_bin \u4e2d\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>macce_general_ci \u4e2d\u6b27 (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>macroman (Mac West European)<br \/>macroman_bin \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>macroman_general_ci \u897f\u6b27 (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>sjis (Shift-JIS Japanese)<br \/>sjis_bin \u65e5\u8bed, \u4e8c\u8fdb\u5236<br \/>sjis_japanese_ci \u65e5\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>swe7 (7bit Swedish)<br \/>swe7_bin \u745e\u5178\u8bed, \u4e8c\u8fdb\u5236<br \/>swe7_swedish_ci \u745e\u5178\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>tis620 (TIS620 Thai)<br \/>tis620_bin \u6cf0\u8bed, \u4e8c\u8fdb\u5236<br \/>tis620_thai_ci \u6cf0\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2 (UCS-2 Unicode)<br \/>ucs2_bin Unicode (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>ucs2_czech_ci \u6377\u514b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_danish_ci \u4e39\u9ea6\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_esperanto_ci \u672a\u77e5, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_estonian_ci \u7231\u6c99\u5c3c\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_general_ci Unicode (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_hungarian_ci \u5308\u7259\u5229\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_icelandic_ci \u51b0\u5c9b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_latvian_ci \u62c9\u8131\u7ef4\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_lithuanian_ci \u7acb\u9676\u5b9b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_persian_ci \u6ce2\u65af\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_polish_ci \u6ce2\u5170\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_roman_ci \u897f\u6b27, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_romanian_ci \u7f57\u9a6c\u5c3c\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_slovak_ci \u65af\u6d1b\u4f10\u514b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_slovenian_ci \u65af\u6d1b\u6587\u5c3c\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_spanish2_ci \u4f20\u7edf\u897f\u73ed\u7259\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_spanish_ci \u897f\u73ed\u7259\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_swedish_ci \u745e\u5178\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_turkish_ci \u571f\u8033\u5176\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ucs2_unicode_ci Unicode (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>ujis (EUC-JP Japanese)<br \/>ujis_bin \u65e5\u8bed, \u4e8c\u8fdb\u5236<br \/>ujis_japanese_ci \u65e5\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8 (UTF-8 Unicode)<br \/>utf8_bin Unicode (\u591a\u8bed\u8a00), \u4e8c\u8fdb\u5236<br \/>utf8_czech_ci \u6377\u514b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_danish_ci \u4e39\u9ea6\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_esperanto_ci \u672a\u77e5, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_estonian_ci \u7231\u6c99\u5c3c\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_general_ci Unicode (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_hungarian_ci \u5308\u7259\u5229\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_icelandic_ci \u51b0\u5c9b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_latvian_ci \u62c9\u8131\u7ef4\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_lithuanian_ci \u7acb\u9676\u5b9b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_persian_ci \u6ce2\u65af\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_polish_ci \u6ce2\u5170\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_roman_ci \u897f\u6b27, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_romanian_ci \u7f57\u9a6c\u5c3c\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_slovak_ci \u65af\u6d1b\u4f10\u514b\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_slovenian_ci \u65af\u6d1b\u6587\u5c3c\u4e9a\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_spanish2_ci \u4f20\u7edf\u897f\u73ed\u7259\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_spanish_ci \u897f\u73ed\u7259\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_swedish_ci \u745e\u5178\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_turkish_ci \u571f\u8033\u5176\u8bed, \u4e0d\u533a\u5206\u5927\u5c0f\u5199<br \/>utf8_unicode_ci Unicode (\u591a\u8bed\u8a00), \u4e0d\u533a\u5206\u5927\u5c0f\u5199 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql\u5b57\u7b26\u96c6\u7f16\u7801 \u5b57\u7b26\u96c6\u548c\u6574\u7406\u6574\u7406 \u63cf\u8ff0armscii8 (ARMSCII-8 Armenian)arms <a href='https:\/\/www.icocean.com\/blog\/?p=833' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[369,366,367,370,368],"class_list":["post-833","post","type-post","status-publish","format-standard","hentry","category-4","tag-charset","tag-mysql","tag-367","tag-370","tag-368","category-4-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=833"}],"version-history":[{"count":0,"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/833\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.icocean.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}