涓€銆佸瓧绗﹂泦鍩虹涓庡父瑙侀棶棰?/h2>
瀛楃闆嗗畾涔変簡鏁版嵁搴撲腑瀛楃鐨勭紪鐮佽鍒欙紝閿欒璁剧疆浼氬鑷翠腑鏂囨樉绀轰负涔辩爜銆傞樋閲屼簯鏁版嵁搴撻粯璁ゆ敮鎸佸绉嶅瓧绗﹂泦锛屽UTF-8銆丟BK绛夛紝浣嗚嫢瀹㈡埛绔€佽繛鎺ュ櫒銆佹暟鎹簱瀹炰緥涓夎€呯殑瀛楃闆嗕笉涓€鑷达紝鏁版嵁鍦ㄤ紶杈撹繃绋嬩腑鍙兘鍙戠敓缂栫爜杞崲閿欒銆?/p>
甯歌闂鍦烘櫙鍖呮嫭锛氭湰鍦癝QL鏂囦欢缂栫爜涓庢暟鎹簱瀛楃闆嗕笉鍖归厤銆佸簲鐢ㄧ▼搴忔湭鏄惧紡澹版槑瀛楃闆嗐€佹湇鍔″櫒绯荤粺鐜鏈厤缃甎TF-8鏀寔绛夈€?/p>
浜屻€佸瓧绗﹂泦閫夋嫨鍘熷垯
閬靛惊浠ヤ笅鍘熷垯鍙渶澶ч檺搴﹂伩鍏嶄贡鐮侊細
- 缁熶竴鎬у師鍒?/strong>锛氭暟鎹簱銆佸鎴风杩炴帴銆佸簲鐢ㄧ▼搴忛渶浣跨敤鐩稿悓瀛楃闆嗭紙鎺ㄨ崘UTF-8锛?/li>
- 鍏煎鎬у師鍒?/strong>锛氫紭鍏堥€夋嫨UTF-8缂栫爜锛屾敮鎸佸璇█涓斿吋瀹规€ф渶浣?/li>
- 鍏ㄩ摼璺獙璇?/strong>锛氫粠鏁版嵁杈撳叆銆佸瓨鍌ㄥ埌杈撳嚭鐜妭鍧囬渶妫€鏌ョ紪鐮佽缃?/li>
- 鍏煎鎬у師鍒?/strong>锛氫紭鍏堥€夋嫨UTF-8缂栫爜锛屾敮鎸佸璇█涓斿吋瀹规€ф渶浣?/li>
涓夈€侀樋閲屼簯鏁版嵁搴撳瓧绗﹂泦閰嶇疆姝ラ
- 鍒涘缓鏁版嵁搴撴椂鎸囧畾瀛楃闆?/strong>锛氶€氳繃鎺у埗鍙版垨SQL鍛戒护
CREATE DATABASE鏃跺０鏄?code>CHARACTER SET utf8mb4 - 淇敼鐜版湁鏁版嵁搴撻厤缃?/strong>锛氱櫥褰曟帶鍒跺彴杩涘叆瀹炰緥璇︽儏椤碉紝鍦ㄢ€滃熀鏈俊鎭€濋€夐」鍗¤皟鏁村瓧绗﹂泦鍙傛暟
- 閰嶇疆鏂囦欢寮哄埗璁剧疆锛氬湪
my.cnf涓坊鍔?code>character-set-server=utf8骞堕噸鍚湇鍔?/li>
鍥涖€佹暟鎹縼绉讳笌缂栫爜涓€鑷存€?/h2>
瀵煎叆鏈湴鏁版嵁鏃堕渶纭繚锛?/p>
- 浣跨敤
mysqldump瀵煎嚭SQL鏂囦欢鏃舵寚瀹?code>–default-character-set=utf8 - 閫氳繃
iconv宸ュ叿杞崲鍘嗗彶鏁版嵁鐨勭紪鐮佹牸寮?/li> - 鍦ㄥ簲鐢ㄧ▼搴忚繛鎺ュ瓧绗︿覆涓樉寮忔坊鍔?code>charset=utf8鍙傛暟
浜斻€佹湇鍔″櫒鐜浼樺寲寤鸿
瀹屾垚鏁版嵁搴撻厤缃悗锛岄渶鍚屾妫€鏌ワ細
- 鎿嶄綔绯荤粺璇█鐜锛氶€氳繃
/etc/sysconfig/i18n璁剧疆LANG="en_US.UTF-8" - 瀹夎涓枃瀛椾綋搴擄細鎵ц
yum install fonts-wqy-microhei - Web鏈嶅姟鍣紙濡侼ginx锛夐厤缃?code>charset utf-8鍝嶅簲澶?/li>
閬垮厤闃块噷浜戞暟鎹簱涓枃涔辩爜闇€寤虹珛浠庡瓧绗﹂泦閫夋嫨銆侀厤缃埌鍏ㄩ摼璺獙璇佺殑瀹屾暣瑙ｅ喅鏂规銆備紭鍏堥噰鐢║TF-8缂栫爜骞朵繚鎸佸鎴风銆佹湇鍔＄銆佸簲鐢ㄥ眰鐨勪竴鑷存€ц缃紝鍙交搴曡В鍐?0%浠ヤ笂鐨勪贡鐮侀棶棰樸€傚畾鏈熶娇鐢?code>SHOW VARIABLES LIKE ‘%char%’鍛戒护楠岃瘉鍚勭幆鑺傜紪鐮佺姸鎬佹槸鏈夋晥鐨勭淮鎶ゆ墜娈点€?/p>
