缇庢浜掕仈鏁版嵁搴撲贡鐮佸揩閫熻瘖鏂笌淇鎸囧崡
涓€銆侀棶棰樿瘖鏂柟娉?/h2>
褰撳彂鐜版暟鎹簱涔辩爜鏃讹紝寤鸿鎸夌収浠ヤ笅椤哄簭杩涜鎺掓煡锛?/p>
- 妫€鏌ユ暟鎹簱瀛楃闆嗛厤缃細浣跨敤
SHOW VARIABLES LIKE 'character_set%'鍛戒护楠岃瘉瀛楃闆嗕竴鑷存€?/li> - 纭瀹㈡埛绔繛鎺ヨ缃細鍖呮嫭JDBC鍙傛暟
useUnicode=true&characterEncoding=UTF-8 - 鍒嗘瀽鏁版嵁鎻掑叆鏂瑰紡锛氭鏌ュ簲鐢ㄧ▼搴忔槸鍚︽湭姝ｇ‘澶勭悊BLOB绫诲瀷鐨勪腑鏂囧瓧娈?/li>
- 楠岃瘉鏁版嵁瀛樺偍杩囩▼锛氫娇鐢?code>CONVERT鍑芥暟娴嬭瘯缂栫爜杞崲鏁堟灉
浜屻€佸揩閫熶慨澶嶆楠?/h2>
鍙戠幇涔辩爜鍚庡彲閲囩敤鍒嗗眰淇绛栫暐锛?/p>
| 闂绫诲瀷 | 瑙ｅ喅鏂规 |
|---|---|
| 鍏ㄥ眬瀛楃闆嗛敊璇?/td> | 鎵цALTER DATABASE charset=utf8mb4 |
| 瀛楁绾т贡鐮?/td> | 淇敼琛ㄧ粨鏋?code>ALTER TABLE…CHARACTER SET utf8mb4 |
| 鏁版嵁浼犺緭閿欒 | 璁剧疆SET NAMES 'utf8mb4'寤虹珛杩炴帴 |
涓夈€侀闃叉帾鏂?/h2>
- 寤虹珛缁熶竴缂栫爜瑙勮寖锛氬己鍒朵娇鐢║TF-8/UTF8MB4瀛楃闆?/li>
- 閮ㄧ讲鑷姩鍖栨娴嬶細瀹氭湡杩愯
DBCC CHECKDB楠岃瘉鏁版嵁瀹屾暣鎬?/li>
- 閰嶇疆鐩戞帶鍛婅锛氬闈炲父鐢ㄥ瓧绗﹂泦鎿嶄綔璁剧疆闃堝€兼姤璀?/li>
DBCC CHECKDB楠岃瘉鏁版嵁瀹屾暣鎬?/li>
鍥涖€佸吀鍨嬫渚嬪垎鏋?/h2>
鏌愮數鍟嗙郴缁熻鍗曞娉ㄥ瓧娈靛嚭鐜颁贡鐮侊紝缁忔帓鏌ュ彂鐜帮細
- 鏁版嵁搴撹〃瀛楁浣跨敤latin1瀛楃闆嗗瓨鍌↗SON鏍煎紡鏁版嵁
- 搴旂敤绋嬪簭杩炴帴姹犳湭鎸囧畾瀛楃闆嗗弬鏁?/li>
- 淇鏂规锛氶€氳繃
mysqldump瀵煎嚭鍚庨噸寤篣TF8MB4缂栫爜琛?/li>
