涔辩爜浜х敓鏈哄埗瑙ｆ瀽
褰揇iscuz璁哄潧鐨勬暟鎹簱瀛楃闆嗚缃笌鍏跺畠绯荤粺缁勪欢涓嶅尮閰嶆椂锛屾暟鎹湪瀛樺偍鍜屼紶杈撹繃绋嬩腑浼氫骇鐢熺紪鐮佽浆鎹㈤敊璇€傚吀鍨嬪満鏅寘鎷琈ySQL鏁版嵁搴撻噰鐢╨atin1瀛楃闆嗗瓨鍌║TF-8缂栫爜鐨勭綉椤靛唴瀹癸紝瀵艰嚧姹夊瓧绛夐潪ASCII瀛楃琚埅鏂垨閿欒瑙ｇ爜銆?/p>
| 缁勪欢 | 閿欒閰嶇疆绀轰緥 |
|---|---|
| MySQL琛ㄧ粨鏋?/td> | CHARSET=latin1 |
| PHP杩炴帴鍣?/td> | mysql_set_charset(‘gbk’) |
| HTML椤甸潰 | meta charset=GB2312 |
甯歌鏁呴殰璇婃柇鏂规硶
閫氳繃涓夐樁娈佃瘖鏂硶瀹氫綅闂婧愶細
- 鏁版嵁搴撳眰闈細鎵ц
SHOW VARIABLES LIKE 'character_set%'楠岃瘉鏁版嵁搴撳叏灞€瀛楃闆?/li> - 搴旂敤灞傞潰锛氭鏌onfig.inc.php涓殑dbcharset鍙傛暟鏄惁涓嶮ySQL瀹為檯璁剧疆鍖归厤
- 浼犺緭灞傞潰锛氫娇鐢╰cpdump鎶撳寘鍒嗘瀽SQL璇彞缂栫爜
鍏稿瀷閿欒妗堜緥琛ㄧ幇涓洪〉闈㈡樉绀洪棶鍙????)鎴栫伀鏄熸枃(氓聫聭猫隆篓)锛屽鐢盙BK涓嶶TF-8娣风敤寮曡捣銆?/p>
鍏ㄦ爤瑙ｅ喅鏂规
瀹炴柦澶氬眰绾т慨澶嶆柟妗堬細
- 鏁版嵁搴撴敼閫狅細
ALTER DATABASE discuzdb CONVERT TO utf8mb4
- 杩炴帴閰嶇疆锛氬湪PHP涓己鍒舵寚瀹?code>mysqli::set_charset(‘utf8mb4’)
- 鐜閫傞厤锛氫慨鏀筁inux绯荤粺locale閰嶇疆涓簔h_CN.UTF-8
闇€娉ㄦ剰杞崲鐜版湁鏁版嵁鏃朵娇鐢?code>mysqldump閰嶅悎iconv杩涜缂栫爜杩佺Щ銆?/p>
瀛楃闆嗕竴鑷存€ф槸璺ㄥ钩鍙扮郴缁熺ǔ瀹氳繍琛岀殑鍩虹锛屽缓璁湪Discuz閮ㄧ讲鍒濇湡鍗冲缓绔嬪瓧绗﹂泦瑙勮寖鏂囨。锛岄€氳繃鑷姩鍖栨娴嬭剼鏈畾鏈熼獙璇佸悇缁勪欢缂栫爜璁剧疆銆傚宸蹭骇鐢熶贡鐮佺殑鏁版嵁搴擄紝寤鸿閲囩敤鏃犳崯杞崲宸ュ叿杩涜鎵归噺淇銆?/p>
