鍦ㄤ簯鏈嶅姟鍣ㄧ郴缁熷眰闈紝闇€纭繚榛樿璇█鐜鏀寔UTF-8缂栫爜銆傚浜嶶buntu绯荤粺锛屽彲閫氳繃瀹夎涓枃璇█鍖呭疄鐜帮細

sudo apt-get install language-pack-zh-hans
export LANG="zh_CN.UTF-8"

寤鸿鍦?code>~/.profile閰嶇疆鏂囦欢涓案涔呰缃幆澧冨彉閲忥紝閬垮厤閲嶅惎澶辨晥銆?/p>

鏁版嵁搴撳瓧绗﹂泦璁剧疆

浠ySQL涓轰緥锛岄渶閫氳繃閰嶇疆鏂囦欢寮哄埗鎸囧畾UTF-8缂栫爜锛?/p>

1. 淇敼my.cnf鏂囦欢[mysqld]娈垫坊鍔犻厤缃?/li>
2. 閲嶅惎鏁版嵁搴撴湇鍔′娇閰嶇疆鐢熸晥

character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

鍒涘缓鏁版嵁琛ㄦ椂闇€鏄惧紡鎸囧畾CHARSET=utf8mb4銆?/p>

搴旂敤绋嬪簭閰嶇疆浼樺寲

鍦ㄦ暟鎹簱杩炴帴閰嶇疆涓己鍒舵寚瀹氱紪鐮佸弬鏁帮細

• JDBC杩炴帴绀轰緥锛?code>jdbc:mysql://host/db?useUnicode=true&characterEncoding=UTF-8
• ORM妗嗘灦闇€閰嶇疆鏂硅█鍜岀被鍨嬭浆鎹㈣鍒?/li>

Web鏈嶅姟鍣ㄩ渶璁剧疆鍝嶅簲澶?code>Content-Type: text/html; charset=utf-8锛岄伩鍏嶄紶杈撹繃绋嬬紪鐮佷涪澶便€?/p>

楠岃瘉涓庢晠闅滄帓鏌?/h2>

閫氳繃浠ヤ笅鍛戒护楠岃瘉鏁版嵁搴撶紪鐮侀厤缃細

SHOW VARIABLES LIKE 'character_set_%';

鑻ュ嚭鐜板瓧绗︽樉绀哄紓甯革紝寤鸿鎸夐『搴忔鏌ワ細绯荤粺鐜鈫掓暟鎹簱閰嶇疆鈫掑簲鐢ㄨ繛鎺ュ弬鏁扳啋鏁版嵁浼犺緭缂栫爜锛屼娇鐢?code>hex鍑芥暟杈呭姪鍒嗘瀽瀛楄妭搴忓垪銆?/p>