涓€銆佸瓧绗﹂泦鍩虹姒傚康涓庝贡鐮佹垚鍥?/h2>
涓枃涔辩爜鐨勬湰璐ㄦ槸瀛楃缂栫爜鍦ㄥ瓨鍌ㄣ€佷紶杈撱€佽В鏋愮幆鑺傜殑涓嶄竴鑷存€с€備簯鏁版嵁搴撳満鏅腑甯歌鎴愬洜鍖呮嫭锛?/p>
- 鏁版嵁搴撴湇鍔＄榛樿瀛楃闆嗕笌瀹㈡埛绔紪鐮佷笉鍖归厤
- 杩炴帴浼氳瘽鏈寚瀹氱粺涓€缂栫爜鏍煎紡锛堝character_set_client/connection/results锛?/li>
- 璺ㄥ钩鍙版暟鎹縼绉绘椂鏈墽琛岀紪鐮佽浆鎹?/li>
鐜颁唬浜戞暟鎹簱寤鸿閲囩敤UTF8mb4瀛楃闆嗭紝鍏舵敮鎸佸洓瀛楄妭缂栫爜鍙畬鏁磋鐩栫敓鍍绘眽瀛椾笌Emoji绗﹀彿銆?/p>
浜屻€佷簯鏁版嵁搴撳瓧绗﹂泦閰嶇疆瑕佺偣
浠ラ樋閲屼簯銆佸崕涓轰簯绛変富娴佸钩鍙颁负渚嬶紝鎺ㄨ崘閰嶇疆娴佺▼锛?/p>
- 鍒涘缓瀹炰緥鏃堕€夋嫨
utf8mb4浣滀负榛樿瀛楃闆?/li> - 閫氳繃鎺у埗鍙颁慨鏀瑰弬鏁扮粍锛氳缃?code>character_set_server=utf8mb4
- 寤虹珛杩炴帴鍚庢墽琛孲QL锛?code>SET NAMES ‘utf8mb4’
| 鍙傛暟 | 寤鸿鍊?/th> |
|---|---|
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_results | utf8mb4 |
涓夈€佹暟鎹紶杈撶紪鐮佽鑼冨疄璺?/h2>
閬垮厤鏁版嵁绠￠亾涓殑缂栫爜姹℃煋闇€娉ㄦ剰锛?/p>
- 搴旂敤绋嬪簭杩炴帴瀛楃涓叉樉寮忓０鏄?code>charset=utf8mb4
- API鎺ュ彛璁剧疆HTTP澶达細
Content-Type: application/json; charset=utf-8 - 鎵归噺瀵煎叆鏁版嵁鏃朵娇鐢?code>iconv宸ュ叿杞崲缂栫爜鏍煎紡
鍥涖€佽繍缁寸洃鎺т笌鏁呴殰鎺掓煡
寤鸿閫氳繃浠ヤ笅鏂瑰紡寤虹珛闃叉姢浣撶郴锛?/p>
- 閮ㄧ讲鐩戞帶鑴氭湰瀹氭湡妫€鏌ユ暟鎹簱缂栫爜鍙傛暟
- 浣跨敤
SHOW VARIABLES LIKE 'character_set%'楠岃瘉浼氳瘽缂栫爜 - 鍦ㄦ祴璇曠幆澧冩ā鎷熶笉鍚岀紪鐮佸満鏅獙璇佹暟鎹畬鏁存€?/li>
瑙ｅ喅浜戞暟鎹簱涓枃涔辩爜闇€瑕佸缓绔嬬鍒扮鐨勭紪鐮佺鐞嗕綋绯伙紝浠庢暟鎹簱瀹炰緥鍒涘缓銆佽繛鎺ラ厤缃埌鏁版嵁浼犺緭瀹炴柦鍏ㄩ摼璺帶鍒躲€傚缓璁皢UTF8mb4浣滀负鏍囧噯缂栫爜鏂规锛屽苟閫氳繃鑷姩鍖栧伐鍏峰疄鐜扮紪鐮佽鑼冪殑鎸佺画鐩戞帶銆?/p>
