涓€銆佸瓧绗︾紪鐮佷笌鍚堢鏁版嵁搴撶殑鍏煎鎬ч棶棰?/h2>
鍚堢鏁版嵁搴撳瓨鍌ㄧ敓鍍诲瓧鍑虹幇闂彿鐨勬牳蹇冨師鍥犲湪浜庡瓧绗﹂泦涓嶅尮閰嶃€傚綋鏁版嵁搴撳瓧绗﹂泦璁句负UTF-8鑰岄潪UTF8MB4鏃讹紝鏃犳硶瀹屾暣鏀寔Unicode 4.0鍙婁互涓婃爣鍑嗙殑鐢熷兓姹夊瓧銆備緥濡侻ySQL榛樿鐨刄TF8瀛楃闆嗕粎鏀寔鏈€澶?瀛楄妭瀛楃锛岃€岄儴鍒嗙敓鍍诲瓧闇€瑕?瀛楄妭缂栫爜銆?/p>
| 瀛楃闆?/th> | 鏀寔鑼冨洿 | 瀛楄妭闀垮害 |
|---|---|---|
| UTF8 | 鍩烘湰澶氭枃绉嶅钩闈?/td> | 1-3瀛楄妭 |
| UTF8MB4 | Unicode鍏ㄥ瓧绗?/td> | 1-4瀛楄妭 |
浜屻€佸悎绉熺幆澧冧笅鐨勬暟鎹簱閰嶇疆闄愬埗
鍦ㄥ叡浜暟鎹簱鐜涓紝鐢ㄦ埛閫氬父缂哄皯淇敼鍏ㄥ眬閰嶇疆鐨勬潈闄愩€傝嫢鏈嶅姟鍟嗘湭棰勫厛璁剧疆character_set_server=utf8mb4锛屽嵆浣垮簲鐢ㄥ眰鎸囧畾缂栫爜涔熸棤娉曞瓨鍌ㄧ敓鍍诲瓧銆傛鏃堕渶閫氳繃浠ヤ笅姝ラ楠岃瘉閰嶇疆锛?/p>
- 鎵ц
SHOW VARIABLES LIKE 'character_set%'妫€鏌ユ湇鍔″櫒缂栫爜 - 纭鏁版嵁搴撹繛鎺ュ瓧绗︿覆鍖呭惈
charset=utf8mb4鍙傛暟 - 璇锋眰鏈嶅姟鍟嗗崌绾ф暟鎹簱鐗堟湰鑷?.5.3浠ヤ笂浠ユ敮鎸乁TF8MB4
涓夈€佸鎴风绋嬪簭澶勭悊鐢熷兓瀛楃殑缂洪櫡
绋嬪簭绔嫢鏈纭鐞嗙紪鐮佽浆鎹紝浼氬鑷寸敓鍍诲瓧鍦ㄥ瓨鍌ㄥ墠琚敊璇浆鐮併€備緥濡侾ython杩炴帴MySQL鏃跺簲鏄惧紡澹版槑charset='utf8mb4'锛孞ava绋嬪簭闇€浣跨敤鏀寔4瀛楄妭缂栫爜鐨凧DBC椹卞姩銆傚父瑙侀敊璇寘鎷細
- 浣跨敤宸插純鐢ㄧ殑
utf8缂栫爜澹版槑 - 鏈湪HTTP璇锋眰澶磋缃?code>Content-Type: text/html; charset=utf-8
- ORM妗嗘灦鏈悓姝ヤ慨鏀瑰瓧娈电骇瀛楃闆?/li>
鍥涖€佹暟鎹縼绉绘椂鐨勭紪鐮佽浆鎹㈤敊璇?/h2>
浠庢棫鏁版嵁搴撹縼绉绘暟鎹椂锛岃嫢鏈繘琛岀紪鐮佹竻娲楋紝鍘烲atin1缂栫爜瀛樺偍鐨勪吉UTF-8鏁版嵁杞崲鍒癠TF8MB4鐜鏃朵細浜х敓涔辩爜銆傚缓璁噰鐢?code>ALTER TABLE鍛戒护閲嶅缓缂栫爜锛?/p>
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;鍚屾椂闇€纭繚ETL宸ュ叿閰嶇疆姝ｇ‘鐨勬簮/鐩爣瀛楃闆嗐€?/p>
鍚堢鏁版嵁搴撳瓨鍌ㄧ敓鍍诲瓧寮傚父闇€浠庢湇鍔＄閰嶇疆銆佸鎴风缂栫爜銆佹暟鎹縼绉讳笁鏂归潰鎺掓煡銆備紭鍏堢‘璁ゆ暟鎹簱鏀寔UTF8MB4锛岀▼搴忚繛鎺ユ寚瀹?瀛楄妭缂栫爜锛屽苟瀵瑰巻鍙叉暟鎹墽琛岀紪鐮佽浆鎹€傚湪鍏变韩鐜涓嬶紝鍙婃椂涓庢湇鍔″晢娌熼€氳皟鏁村叏灞€瀛楃闆嗛厤缃槸瑙ｅ喅闂鐨勫叧閿€?/p>
