{"id":210,"date":"2016-07-16T11:47:23","date_gmt":"2016-07-16T03:47:23","guid":{"rendered":"http:\/\/www.zhuyanbin.com\/?p=210"},"modified":"2016-12-09T22:00:01","modified_gmt":"2016-12-09T14:00:01","slug":"mysql-utf8mb4%e4%b8%8eemoji%e8%a1%a8%e6%83%85","status":"publish","type":"post","link":"https:\/\/www.yanbin888.com\/?p=210","title":{"rendered":"mysql utf8mb4\u4e0eemoji\u8868\u60c5"},"content":{"rendered":"

MYSQL 5.5 \u4e4b\u524d\uff0c UTF8 \u7f16\u7801\u53ea\u652f\u63011-3\u4e2a\u5b57\u8282\uff0c\u53ea\u652f\u6301BMP\u8fd9\u90e8\u5206\u7684unicode\u7f16\u7801\u533a\uff0c BMP\u662f\u4ece\u54ea\u5230\u54ea\uff0c\u5230http:\/\/en.wikipedia.org\/wiki\/Mapping_of_Unicode_characters<\/a>\u8fd9\u91cc\u770b\uff0c\u57fa\u672c\u5c31\u662f0000\uff5eFFFF\u8fd9\u4e00\u533a\u3002 \u4eceMYSQL5.5\u5f00\u59cb\uff0c\u53ef\u652f\u63014\u4e2a\u5b57\u8282UTF\u7f16\u7801utf8mb4\uff0c\u4e00\u4e2a\u5b57\u7b26\u6700\u591a\u80fd\u67094\u5b57\u8282\uff0c\u6240\u4ee5\u80fd\u652f\u6301\u66f4\u591a\u7684\u5b57\u7b26\u96c6\u3002<\/p>\n

utf8mb4 is<\/span> a superset of utf8<\/code><\/pre>\n
utf8mb4\u517c\u5bb9utf8\uff0c\u4e14\u6bd4utf8\u80fd\u8868\u793a\u66f4\u591a\u7684\u5b57\u7b26\u3002<\/p>\n
\u81f3\u4e8e\u4ec0\u4e48\u65f6\u5019\u7528\uff0c\u770b\u4f60\u7684\u505a\u4ec0\u4e48\u9879\u76ee\u4e86\u3002\u3002<\/p>\n
\u5728\u505a\u79fb\u52a8\u5e94\u7528\u65f6\uff0c\u4f1a\u9047\u5230ios\u7528\u6237\u4f1a\u5728\u6587\u672c\u7684\u533a\u57df\u8f93\u5165emoji\u8868\u60c5\uff0c\u5982\u679c\u4e0d\u505a\u4e00\u5b9a\u5904\u7406\uff0c\u5c31\u4f1a\u5bfc\u81f4\u63d2\u5165\u6570\u636e\u5e93\u5f02\u5e38\u3002<\/p>\n
Emoji\u8868\u60c5\u7b26\u53f7\u517c\u5bb9\u65b9\u6848<\/strong><\/h3>\n
\u4e00 \u4ec0\u4e48\u662fEmoji<\/strong><\/p>\n
emoji\u5c31\u662f\u8868\u60c5\u7b26\u53f7\uff1b\u8bcd\u4e49\u6765\u81ea\u65e5\u8bed\uff08\u3048\u3082\u3058\uff0ce-moji\uff0cmoji\u5728\u65e5\u8bed\u4e2d\u7684\u542b\u4e49\u662f\u5b57\u7b26\uff09
\n\u8868\u60c5\u7b26\u53f7\u73b0\u5df2\u666e\u904d\u5e94\u7528\u4e8e\u624b\u673a\u77ed\u4fe1\u548c\u7f51\u7edc\u804a\u5929\u8f6f\u4ef6\u3002
\nemoji\u8868\u60c5\u7b26\u53f7\uff0c\u5728\u5916\u56fd\u7684\u624b\u673a\u77ed\u4fe1\u91cc\u9762\u5df2\u7ecf\u662f\u5f88\u6d41\u884c\u4f7f\u7528\u7684\u4e00\u79cd\u8868\u60c5\u3002
\n\u624b\u673a\u4e0a\u5982\u4f55\u4f7f\u7528emoji\uff1a
\n1.iphone\u3001ipad\u7cfb\u7edf\uff1a\u5b89\u88c5emoji free\uff0c\u518d\u8bbe\u7f6e-\u901a\u7528-\u952e\u76d8-\u56fd\u9645\u952e\u76d8-\u6dfb\u52a0\u65b0\u7684\u952e\u76d8\uff0c\u7136\u540e\u628aemoji\u6dfb\u52a0\u5728\u91cc\u9762\u5373\u53ef\u5728\u53d1\u77ed\u4fe1\u548c\u4e00\u4e9b\u8f93\u5165\u6587\u672c\u7684\u6587\u672c\u6846\u4e2d\u8f93\u5165\u8868\u60c5\u3002
\nIOS 5\u7528\u6237\u53ef\u76f4\u63a5\u4ece\u901a\u7528\u4e2d\u6dfb\u52a0emoji \u952e\u76d8\uff0c\u65e0\u9700\u518d\u5b89\u88c5emoji free
\n2.android\u7cfb\u7edf\uff1a\u5b89\u88c5\u201cGO\u8f93\u5165\u6cd5\u56fd\u9645\u7248\u201d\u540e\uff0c\u5728\u8f93\u5165\u6cd5\u91cc\u9762\u70b9\u9009\u5b89\u88c5emoji\u63d2\u4ef6\u53ef\u4ee5\u4f7f\u7528\u3002\u53e6\u5916\u201c\u767e\u5ea6\u8f93\u5165\u6cd5\u201d\u4e5f\u81ea\u5e26emoji\u8868\u60c5
\n3.Windows Phone : \u5b89\u88c5\u6b64 Emoji Keys\uff0c\u5728\u5176\u4e2d\u8f93\u5165\u4e4b\u540e\u590d\u5236\u7c98\u8d34\u5230\u9700\u8981\u8f93\u5165\u8868\u60c5\u7684\u5730\u65b9\u5373\u53ef<\/p>\n
<\u6b64\u6bb5\u6458\u81ea\u767e\u5ea6\u767e\u79d1\u00a0http:\/\/baike.baidu.com\/view\/2631589.htm<\/a>><\/p>\n
\"\"<\/a><\/p>\n
\n
\u4e8c Emoji\u8868\u60c5\u7b26\u53f7\u95ee\u9898<\/strong>
\n1 \u95ee\u9898\uff1a
\nIOS\u7248\u672c\u4e4b\u95f4\u53d1\u9001\u7684Emoji\u8868\u60c5\u7b26\u53f7\u4e0d\u517c\u5bb9\uff0c\u53ea\u770b\u5230\u65b9\u5757
\n\u4e0d\u540cIOS\u7248\u672c\u5728\u6570\u636e\u5e93\u5b58\u6570\u636e\u65f6\uff0c\u6709\u65f6\u4f1a\u53d1\u751f\u7cfb\u7edf\u9519\u8bef
\n2 \u73b0\u8c61\uff1a
\nIOS 4 \u8f93\u5165Emoji\u8868\u60c5\u7b26\uff0c\u5728IOS5.01 \u663e\u793a\u6b63\u5e38\uff0c\u5728IOS5.1\u4e2d\uff08\u5927\u9646\u7248\uff09\u663e\u73b0\u4e3a\u65b9\u5757\uff0c \u4f46IOS5.01\/5.1\u8f93\u5165\u7684\u8868\u60c5\u7b26\u53f7\uff0c\u663e\u793a\u6b63 \u00a0 \u00a0 \u00a0\u5e38
\nIOS5.01\/5.1 \u8f93\u5165\u8868\u60c5\u7b26\uff0c\u5728IOS5.01\/5.1\u4e2d\u663e\u793a\u6b63\u5e38\uff0c\u4f46\u5728IOS4.X\u663e\u793a\u4e3a\u65b9\u5757
\n\u8f93\u5165Emoji\u5165\u5e16\u5b50\u6b63\u6587\uff0c \u53ef\u6b63\u5e38\u5b58\u50a8\u3002 \u4f46\u7528\u6237\u6635\u79f0\u5728IOS4.X \u8f93\u5165Emoji\uff0c\u7cfb\u7edf\u6b63\u5e38\uff0c \u800cIOS5.01\/5.1\u5219\u63d0\u793a\u7cfb\u7edf\u9519\u8bef\u3002
\n3 \u672c\u8d28:
\niOS 5 and OS X 10.7 (Lion) use the Unicode 6.0 standard \u2018unified\u2019 code points for emoji.
\niOS 5 Emoji \u00a0\u91c7\u7528Unicode 6 \u6807\u51c6\u6765\u7edf\u4e00code points<\/p>\n
iOS 4 on SoftBank iPhones used a set of unofficial code points in the Unicode Private Use Area, and so aren’t \u00a0 \u00a0 \u00a0compatible with any other systems
\niOS 4 \u91c7\u7528SoftBank Unicode\uff0c \u4e00\u79cd\u975e\u5b98\u65b9\u7684, \u91c7\u7528\u79c1\u6709Unicode \u533a\u57df\u3002
\n4 \u4e3e\u4f8b:
\none emoji symbol “tiger”, it is “\\U0001f42f” in iOS5, but “\\ue050” in earlier iOS version
\n\u864e\u8138Emoji\u7b26\u53f7\u5728iOS5 \u4e3aUnicode\uff1a\\U0001f42f\uff1b\u800c\u5728IOS4.x \u4e3a\uff1a\\ue050 (SoftBank \u7f16\u7801)
\n\u53e6\u5916\uff1a \u6309\u7406\u8bb2\uff0c \u4eceiOS5 \u5e94\u8be5\u517c\u5bb9\u4ee5\u524d\u7248\u672c\u7684emoji, \u4f46\u73b0\u5728\u51fa\u73b05.01\u7248\u672c\u5b8c\u7f8e\u517c\u5bb9\uff08\u65e0\u8bba\u5927\u9646\u7248\uff0c\u7f8e\u7248\uff0c\u8fd8\u662f\u6e2f\u7248\uff09\uff0c \u800c5.1 \u00a0 \u00a0 \u5927\u9646\u7248\u51fa\u73b0\u4e86\u4e0d\u517c\u5bb9\u73b0\u8c61\uff08\u817e\u8baf\u5fae\u4fe1\u4e5f\u51fa\u73b0\u4e86\u540c\u6837\u7684\u95ee\u9898\uff09\u3002
\n\u4e09 \u95ee\u9898\u5206\u6790<\/strong>
\n1 \u7cfb\u7edf\u5b58\u50a8\u9519\u8bef\u95ee\u9898\uff08\u5982\u6635\u79f0\uff0c\u5e16\u5b50\u5185\u5bb9\uff09
\n\u539f\u56e0\uff1a
\n\u7531\u4e8eIOS5.X \u91c7\u7528\u65b0\u7684Unicode\uff0c \u5176UTF8 \u7f16\u7801\u5927\u591a\u4e3a4\u4e2a\u5b57\u8282\uff0c \u800c\u7531\u4e8e\u6635\u79f0\/\u5e16\u5b50\u5185\u5bb9column\u5e76\u6ca1\u8bbe\u6210utf8mb4\uff0c\u56e0\u6b64\u5b58\u50a8\u4f1a \u00a0 \u00a0\u53d1\u751f\u9519\u8bef\u3002
\n\u89e3\u51b3\u65b9\u6cd5\uff1a
\n\u5c06\u6635\u79f0\/\u5e16\u5b50\u5185\u5bb9\u8bbe\u6210utf8mb4
\n2 \u4e0d\u540ciOS \u4e4b\u95f4Emoji \u4e0d\u517c\u5bb9\u7684\u95ee\u9898\u3002
\n\u539f\u56e0\uff1a
\niOS 5 \u52304 \u4e0d\u517c\u5bb9\u7684\u95ee\u9898\uff0c\u5f88\u7b80\u5355\uff0cunicode6 \u548csoftbank\u7f16\u7801\u7684\u4e0d\u540c
\niOS 4 \u5230 5\uff0c\u6309\u7406\u8bf4\u5e94\u8be5\u517c\u5bb9\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0ciOS\u5e94\u8be5\u81ea\u52a8\u5224\u65ad\u5982\u679c\u662fsoftbank\u7f16\u7801\uff0c\u81ea\u52a8\u8f6c\u6210unicode6\u3002\u4f46\u73b0\u5728\u770b\u6765\uff0c iOS5.1\uff08\u5927\u9646\u7248\uff09\u597d\u50cf\u53ea\u652f\u6301unicode6, \u800c\u4e0d\u652f\u6301softbank.
\n\u89e3\u51b3\u65b9\u6cd5\uff1a
\n\u5ba2\u6237\u7aef\u53d1\u9001emoji-encoding: Softbank\u6216unicode6, \u7531\u670d\u52a1\u7aef\u5206\u522b\u7ed9\u51fa\u76f8\u5e94\u7684\u7f16\u7801\u8868\u3002
\n\u56db \u89e3\u51b3\u65b9\u6848<\/strong>
\n1 \u6570\u636e\u5b58\u50a8(MySQL varchar \u00a0\u6570\u636e\u7c7b\u578b\u5bf9UTF8 \u652f\u6301\u95ee\u9898)
\nMYSQL 5.5 \u4e4b\u524d\uff0c UTF8 \u7f16\u7801\u53ea\u652f\u63011-3\u4e2a\u5b57\u8282\uff0c \u4eceMYSQL5.5\u5f00\u59cb\uff0c\u53ef\u652f\u63014\u4e2a\u5b57\u8282UTF\u7f16\u7801\uff0c\u4f46\u8981\u7279\u6b8a\u6807\u8bb0\u3002\u4f8b\u5982\u6211\u4eec\u7684\u5e16\u5b50\u5185\u5bb9\u9879\uff0c\u6211\u4eec\u52a0\u4e0a\u4e86\u8fd9\u4e2a\u652f\u6301\u3002\u670d\u52a1\u7aefmysql\u7edf\u4e00\u5b58\u50a8\u4e3aios5.x\u4e5f\u5c31\u662fUnicode\u7f16\u7801\u3002
\n\u5bf9\u5e94alter\u8bed\u53e5:<\/p>\n
\n
\n
\n
[sql]<\/b>\u00a0 view plain<\/a> copy<\/a><\/p>\n
<\/div>\n<\/div>\n<\/div>\n
    \n
  1. ALTER\u00a0TABLE\u00a0topic\u00a0MODIFY\u00a0COLUMN\u00a0content\u00a0varchar(500)\u00a0CHARACTER\u00a0SET\u00a0utf8mb4\u00a0COLLATE\u00a0utf8mb4_unicode_ci\u00a0DEFAULT\u00a0NULL\u00a0COMMENT\u00a0‘\u5185\u5bb9’;<\/li>\n<\/ol>\n<\/div>\n
    2 \u7f16\u7801\u8f6c\u6362:
    \niphone\u624b\u673a\u65b9\u6848
    \n\u5ba2\u6237\u7aef\u8f93\u5165\u5185\u5bb9\u65f6\u5019\uff0c\u7edf\u4e00\u5b58\u50a8\u4e3aunicode\u7f16\u7801(\u8fd9\u91cc\u9700\u8981\u4ecesoftbank\u7f16\u7801\u8f6c\u6362\u4e3aunicode\u7f16\u7801)\u3002\u5ba2\u6237\u7aef\u8bf7\u6c42\u5185\u5bb9\u7684\u65f6\u5019\uff0c\u9700\u8981\u6839\u636e\u4e0d\u540c\u7684\u5ba2\u6237\u7aef\u7ed9\u51fa\u4e0d\u540c\u7684\u7f16\u7801,ios4\u91c7\u7528softbank\u7f16\u7801\u505a\u66ff\u6362,ios5\u91c7\u7528unicode\u7f16\u7801\u76f4\u63a5\u652f\u6301\u3002
    \nandroid\u6216wp\u5176\u4ed6\u624b\u673a\u65b9\u6848:
    \n\u5982\u679c\u6ca1\u6709emoji\u8868\u60c5\u5e93\uff0c\u5c06\u65e0\u6cd5\u8f93\u5165\u3002\u9488\u5bf9\u8f93\u5165\u95ee\u9898,\u5c06\u7edf\u4e00\u91c7\u7528unicode\u7f16\u7801\u5b58\u50a8\u3002\u5ba2\u6237\u7aef\u8bf7\u6c42\u5185\u5bb9\u7684\u65f6\u5019\uff0c\u5c06\u7edf\u4e00\u7528softbank\u7f16\u7801\uff0c\u5ba2\u6237\u7aef\u9700\u8981\u628aemoji\u8868\u60c5\u7b26\u53f7\u5185\u7f6e\u5230\u5ba2\u6237\u7aef\uff0c\u505a\u5bf9\u5e94\u7684\u7f16\u7801\u548cimg\u66ff\u6362\u3002
    \nweb\u89e3\u51b3\u65b9\u6848:
    \n\u53c2\u8003android\u6216wp\u5176\u4ed6\u624b\u673a\u65b9\u6848
    \n\u4e94 \u90e8\u5206\u4ee3\u7801<\/strong>
    \n1 sql\u4ee3\u7801<\/p>\n
    \n
    \n
    \n
    [sql]<\/b>\u00a0 view plain<\/a> copy<\/a><\/p>\n
    <\/div>\n<\/div>\n<\/div>\n
      \n
    1. CREATE\u00a0TABLE\u00a0`ios_emoji`\u00a0(<\/li>\n
    2. \u00a0\u00a0`id`\u00a0int(11)\u00a0NOT\u00a0NULL\u00a0AUTO_INCREMENT\u00a0COMMENT\u00a0‘\u81ea\u589eID’,<\/li>\n
    3. \u00a0\u00a0`unicode`\u00a0varchar(100)\u00a0CHARACTER\u00a0SET\u00a0utf8mb4\u00a0COLLATE\u00a0utf8mb4_unicode_ci\u00a0DEFAULT\u00a0NULL\u00a0COMMENT\u00a0‘Unicode\u7f16\u7801’,<\/li>\n
    4. \u00a0\u00a0`utf8`\u00a0varchar(100)\u00a0CHARACTER\u00a0SET\u00a0utf8mb4\u00a0COLLATE\u00a0utf8mb4_unicode_ci\u00a0DEFAULT\u00a0NULL\u00a0COMMENT\u00a0‘UTF8\u7f16\u7801’,<\/li>\n
    5. \u00a0\u00a0`utf16`\u00a0varchar(100)\u00a0CHARACTER\u00a0SET\u00a0utf8mb4\u00a0COLLATE\u00a0utf8mb4_unicode_ci\u00a0DEFAULT\u00a0NULL\u00a0COMMENT\u00a0‘UTF16\u7f16\u7801’,<\/li>\n
    6. \u00a0\u00a0`sbunicode`\u00a0varchar(100)\u00a0CHARACTER\u00a0SET\u00a0utf8mb4\u00a0COLLATE\u00a0utf8mb4_unicode_ci\u00a0DEFAULT\u00a0NULL\u00a0COMMENT\u00a0‘SBUnicode\u7f16\u7801’,<\/li>\n
    7. \u00a0\u00a0`filename`\u00a0varchar(100)\u00a0CHARACTER\u00a0SET\u00a0utf8mb4\u00a0COLLATE\u00a0utf8mb4_unicode_ci\u00a0DEFAULT\u00a0NULL\u00a0COMMENT\u00a0‘\u6587\u4ef6\u540d’,<\/li>\n
    8. \u00a0\u00a0`filebyte`\u00a0longblob\u00a0COMMENT\u00a0‘\u6587\u4ef6\u5185\u5bb9\u5b57\u8282’,<\/li>\n
    9. \u00a0\u00a0PRIMARY\u00a0KEY\u00a0(`id`)<\/li>\n
    10. )\u00a0ENGINE=InnoDB\u00a0DEFAULT\u00a0CHARSET=utf8\u00a0ROW_FORMAT=COMPACT\u00a0COMMENT=’ios\u8868\u60c5\u7f16\u7801\u8868’;<\/li>\n<\/ol>\n<\/div>\n
      2 java\u4ee3\u7801<\/p>\n
      \n
      \n
      \n
      [java]<\/b>\u00a0 view plain<\/a> copy<\/a><\/p>\n
      <\/div>\n<\/div>\n<\/div>\n
        \n
      1. import\u00a0java.io.UnsupportedEncodingException;<\/li>\n
      2. import\u00a0org.apache.commons.lang.StringUtils;<\/li>\n
      3. <\/li>\n
      4. <\/li>\n
      5. public\u00a0class\u00a0IOSEmojiUtil\u00a0{<\/li>\n
      6. <\/li>\n
      7. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String[]\u00a0ios5emoji\u00a0;<\/li>\n
      8. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String[]\u00a0ios4emoji\u00a0;<\/li>\n
      9. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String[]\u00a0androidnullemoji\u00a0;<\/li>\n
      10. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String[]\u00a0adsbuniemoji;<\/li>\n
      11. <\/li>\n
      12. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0void\u00a0initios5emoji(String[]\u00a0i5emj,String[]\u00a0i4emj,String[]\u00a0adnullemoji,String[]\u00a0adsbemoji){<\/li>\n
      13. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ios5emoji\u00a0=\u00a0i5emj;<\/li>\n
      14. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ios4emoji\u00a0=\u00a0i4emj;<\/li>\n
      15. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0androidnullemoji\u00a0=\u00a0adnullemoji;<\/li>\n
      16. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0adsbuniemoji\u00a0=\u00a0adsbemoji;<\/li>\n
      17. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      18. <\/li>\n
      19. \u00a0\u00a0\u00a0\u00a0\/\/\u5728ios\u4e0a\u5c06ios5\u8f6c\u6362\u4e3aios4\u7f16\u7801<\/li>\n
      20. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String\u00a0transToIOS4emoji(String\u00a0src)\u00a0{<\/li>\n
      21. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0StringUtils.replaceEach(src,\u00a0ios5emoji,\u00a0ios4emoji);<\/li>\n
      22. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      23. \u00a0\u00a0\u00a0\u00a0\/\/\u5728ios\u4e0a\u5c06ios4\u8f6c\u6362\u4e3aios5\u7f16\u7801<\/li>\n
      24. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String\u00a0transToIOS5emoji(String\u00a0src)\u00a0{<\/li>\n
      25. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0StringUtils.replaceEach(src,\u00a0ios4emoji,\u00a0ios5emoji);<\/li>\n
      26. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      27. \u00a0\u00a0\u00a0\u00a0\/\/\u5728android\u4e0a\u5c06ios5\u7684\u8868\u60c5\u7b26\u66ff\u6362\u4e3a\u7a7a<\/li>\n
      28. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String\u00a0transToAndroidemojiNull(String\u00a0src)\u00a0{<\/li>\n
      29. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0StringUtils.replaceEach(src,\u00a0ios5emoji,\u00a0androidnullemoji);<\/li>\n
      30. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      31. <\/li>\n
      32. \u00a0\u00a0\u00a0\u00a0\/\/\u5728android\u4e0a\u5c06ios5\u7684\u8868\u60c5\u7b26\u66ff\u6362\u4e3aSBUNICODE<\/li>\n
      33. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String\u00a0transToAndroidemojiSB(String\u00a0src)\u00a0{<\/li>\n
      34. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0StringUtils.replaceEach(src,\u00a0ios5emoji,\u00a0adsbuniemoji);<\/li>\n
      35. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      36. <\/li>\n
      37. \u00a0\u00a0\u00a0\u00a0\/\/\u5728android\u4e0a\u5c06SBUNICODE\u7684\u8868\u60c5\u7b26\u66ff\u6362\u4e3aios5<\/li>\n
      38. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String\u00a0transSBToIOS5emoji(String\u00a0src)\u00a0{<\/li>\n
      39. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0StringUtils.replaceEach(src,\u00a0adsbuniemoji,\u00a0ios5emoji);<\/li>\n
      40. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      41. <\/li>\n
      42. \u00a0\u00a0\u00a0\u00a0\/\/eg.\u00a0param:\u00a00xF0\u00a00x9F\u00a00x8F\u00a00x80<\/li>\n
      43. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String\u00a0hexstr2String(String\u00a0hexstr)\u00a0throws\u00a0UnsupportedEncodingException{<\/li>\n
      44. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0b\u00a0=\u00a0hexstr2bytes(hexstr);<\/li>\n
      45. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0new\u00a0String(b,\u00a0“UTF-8”);<\/li>\n
      46. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      47. <\/li>\n
      48. \u00a0\u00a0\u00a0\u00a0\/\/eg.\u00a0param:\u00a0E018<\/li>\n
      49. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0String\u00a0sbunicode2utfString(String\u00a0sbhexstr)\u00a0throws\u00a0UnsupportedEncodingException{<\/li>\n
      50. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0b\u00a0=\u00a0sbunicode2utfbytes(sbhexstr);<\/li>\n
      51. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0new\u00a0String(b,\u00a0“UTF-8”);<\/li>\n
      52. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      53. <\/li>\n
      54. \u00a0\u00a0\u00a0\u00a0\/\/eg.\u00a0param:\u00a00xF0\u00a00x9F\u00a00x8F\u00a00x80<\/li>\n
      55. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0byte[]\u00a0hexstr2bytes(String\u00a0hexstr){<\/li>\n
      56. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0String[]\u00a0hexstrs\u00a0=\u00a0hexstr.split(”\u00a0“);<\/li>\n
      57. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0b\u00a0=\u00a0new\u00a0byte[hexstrs.length];<\/li>\n
      58. <\/li>\n
      59. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for(int\u00a0i=0;i<hexstrs.length;i++){<\/li>\n
      60. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0b[i]\u00a0=\u00a0hexStringToByte(hexstrs[i].substring(2))[0];<\/li>\n
      61. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}<\/li>\n
      62. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0b;<\/li>\n
      63. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      64. <\/li>\n
      65. \u00a0\u00a0\u00a0\u00a0\/\/eg.\u00a0param:\u00a0E018<\/li>\n
      66. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0byte[]\u00a0sbunicode2utfbytes(String\u00a0sbhexstr)\u00a0throws\u00a0UnsupportedEncodingException{<\/li>\n
      67. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0int\u00a0inthex\u00a0=\u00a0Integer.parseInt(sbhexstr,\u00a016);<\/li>\n
      68. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0char[]\u00a0schar\u00a0=\u00a0{(char)inthex};<\/li>\n
      69. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0b\u00a0=\u00a0(new\u00a0String(schar)).getBytes(“UTF-8”);<\/li>\n
      70. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0b;<\/li>\n
      71. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      72. <\/li>\n
      73. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0byte[]\u00a0hexStringToByte(String\u00a0hex)\u00a0{<\/li>\n
      74. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0int\u00a0len\u00a0=\u00a0(hex.length()\u00a0\/\u00a02);<\/li>\n
      75. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0result\u00a0=\u00a0new\u00a0byte[len];<\/li>\n
      76. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0char[]\u00a0achar\u00a0=\u00a0hex.toCharArray();<\/li>\n
      77. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for\u00a0(int\u00a0i\u00a0=\u00a00;\u00a0i\u00a0<\u00a0len;\u00a0i++)\u00a0{<\/li>\n
      78. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0int\u00a0pos\u00a0=\u00a0i\u00a0*\u00a02;<\/li>\n
      79. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0result[i]\u00a0=\u00a0(byte)\u00a0(toByte(achar[pos])\u00a0<<\u00a04\u00a0|\u00a0toByte(achar[pos\u00a0+\u00a01]));<\/li>\n
      80. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}<\/li>\n
      81. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0result;<\/li>\n
      82. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      83. <\/li>\n
      84. <\/li>\n
      85. \u00a0\u00a0\u00a0\u00a0private\u00a0static\u00a0byte\u00a0toByte(char\u00a0c)\u00a0{<\/li>\n
      86. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte\u00a0b\u00a0=\u00a0(byte)\u00a0“0123456789ABCDEF”.indexOf(c);<\/li>\n
      87. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return\u00a0b;<\/li>\n
      88. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      89. <\/li>\n
      90. \u00a0\u00a0\u00a0\u00a0public\u00a0static\u00a0void\u00a0main(String[]\u00a0args)\u00a0throws\u00a0UnsupportedEncodingException\u00a0{<\/li>\n
      91. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u00a0TODO\u00a0Auto-generated\u00a0method\u00a0stub<\/li>\n
      92. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0b1\u00a0=\u00a0{-30,-102,-67};\u00a0\/\/ios5\u00a0\/\/0xE2\u00a00x9A\u00a00xBD<\/li>\n
      93. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0b2\u00a0=\u00a0{-18,-128,-104};\u00a0\/\/ios4\u00a0\/\/”E018″<\/li>\n
      94. <\/li>\n
      95. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/————————————-<\/li>\n
      96. <\/li>\n
      97. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0b3\u00a0=\u00a0{-16,-97,-113,-128};\u00a0\u00a0\u00a0\u00a0\/\/0xF0\u00a00x9F\u00a00x8F\u00a00x80<\/li>\n
      98. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0b4\u00a0=\u00a0{-18,-112,-86};\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/E42A<\/li>\n
      99. <\/li>\n
      100. <\/li>\n
      101. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ios5emoji\u00a0=\u00a0new\u00a0String[]{new\u00a0String(b1,”utf-8″),new\u00a0String(b3,”utf-8″)};<\/li>\n
      102. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ios4emoji\u00a0=\u00a0new\u00a0String[]{new\u00a0String(b2,”utf-8″),new\u00a0String(b4,”utf-8″)};<\/li>\n
      103. <\/li>\n
      104. <\/li>\n
      105. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u6d4b\u8bd5\u5b57\u7b26\u4e32<\/li>\n
      106. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0testbytes\u00a0=\u00a0{105,111,115,-30,-102,-67,32,36,-18,-128,-104,32,36,-16,-97,-113,-128,32,36,-18,-112,-86};<\/li>\n
      107. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0String\u00a0tmpstr\u00a0=\u00a0new\u00a0String(testbytes,”utf-8″);<\/li>\n
      108. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0System.out.println(tmpstr);<\/li>\n
      109. <\/li>\n
      110. <\/li>\n
      111. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u8f6c\u6210ios4\u7684\u8868\u60c5<\/li>\n
      112. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0String\u00a0ios4str\u00a0=\u00a0transToIOS5emoji(tmpstr);<\/li>\n
      113. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0byte[]\u00a0tmp\u00a0=\u00a0ios4str.getBytes();<\/li>\n
      114. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/System.out.print(new\u00a0String(tmp,”utf-8″));<\/li>\n
      115. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0for(byte\u00a0b:tmp){<\/li>\n
      116. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0System.out.print(b);<\/li>\n
      117. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0System.out.print(”\u00a0“);<\/li>\n
      118. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}<\/li>\n
      119. \u00a0\u00a0\u00a0\u00a0}<\/li>\n
      120. <\/li>\n
      121. }<\/li>\n<\/ol>\n<\/div>\n
        \u516d \u53c2\u8003\u8d44\u6599<\/strong>
        \n1 Emoji \u5168\u7f16\u7801\u8868\uff1a(\u6211\u53c2\u8003\u7684\u8fd9\u4e2a)
        \nhttp:\/\/punchdrunker.github.com\/iOSEmoji\/table_html\/flower.html
        \n2 Emoji\u5168\u7f16\u7801\u8868
        \nhttp:\/\/code.iamcal.com\/php\/emoji\/<\/p>\n
        3 iOS5\/4 Emoji \u00a0\u517c\u5bb9\u6027\uff1a
        \nhttp:\/\/stackoverflow.com\/questions\/7856775\/how-to-convert-the-old-emoji-encoding-to-the-latest-encoding-in-ios5
        \n4 MySQL emoji\u95ee\u9898
        \nhttp:\/\/dropblood.com\/archives\/ios-mysql-emoji
        \n5 Emoji \u4e2d\u6587\u5bf9\u5e94\u8868
        \nhttp:\/\/www.iapps.im\/wp-content\/uploads\/2012\/02\/emoji-pinyin.png?r=010<\/p>\n
        \u4e03 \u4e0b\u8f7d\u8d44\u6e90\u00a0<\/strong><\/p>\n
        emoji\u56fe\u7247\u548c\u7f16\u7801\u8868<\/a>\u00a0http:\/\/download.csdn.net\/detail\/qdkfriend\/4309051<\/p>\n
        \u5305\u62ecemoji\u6587\u4ef6\u8868,emoji\u6570\u636e\u7f16\u7801\u8868(Unicode\u7f16\u7801,UTF8\u7f16\u7801,UTF16\u7f16\u7801,SBUnicode\u7f16\u7801)<\/p>\n
        mysql\u652f\u6301utf8mb4\u5347\u7ea7\u65b9\u6848<\/p>\n
        <\/h1>\n
        [http:\/\/mathiasbynens.be\/notes\/mysql-utf8mb4#utf8-to-utf8mb4](<\/span><\/p>\n
        How to support full Unicode in MySQL databases<\/h1>\n
        )<\/p>\n
        link:\u00a0http:\/\/my.oschina.net\/wingyiu\/blog\/153357<\/p>\n","protected":false},"excerpt":{"rendered":"
        MYSQL 5.5 \u4e4b\u524d\uff0c UTF8 \u7f16\u7801\u53ea\u652f\u63011-3\u4e2a\u5b57\u8282\uff0c\u53ea\u652f\u6301BMP\u8fd9\u90e8\u5206\u7684unicode\u7f16\u7801\u533a\uff0c BM …<\/span> Read More →<\/span><\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[32],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=\/wp\/v2\/posts\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=210"}],"version-history":[{"count":4,"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=\/wp\/v2\/posts\/210\/revisions"}],"predecessor-version":[{"id":236,"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=\/wp\/v2\/posts\/210\/revisions\/236"}],"wp:attachment":[{"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yanbin888.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}