缇庢浜掕仈鏁版嵁搴撲贡鐮佸揩閫熻瘖鏂笌淇鎸囧崡
涓€銆侀棶棰樿瘖鏂柟娉?/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>
鍥涖€佸吀鍨嬫渚嬪垎鏋?/h2>
鏌愮數鍟嗙郴缁熻鍗曞娉ㄥ瓧娈靛嚭鐜颁贡鐮侊紝缁忔帓鏌ュ彂鐜帮細
