鍦ㄤ娇鐢↗ustHost鎵樼鏈嶅姟鏃讹紝鍙兘浼氶亣鍒版暟鎹簱瀛楃缂栫爜鐨勯棶棰樸€傝繖鍙兘瀵艰嚧涓枃绛夐潪ASCII瀛楃鏄剧ず涔辩爜锛屾垨鏄湪淇濆瓨鏃跺嚭鐜伴棶棰樸€備负浜嗚В鍐宠繖浜涢棶棰橈紝鎴戜滑闇€瑕佷粠澶氫釜瑙掑害杩涜鎺掓煡鍜岃皟鏁淬€?/p>
1. 纭鏁版嵁搴撲笌琛ㄧ殑瀛楃闆嗚缃?/h2>
瑕佺‘淇濅綘鐨凪ySQL鏁版嵁搴撳拰琛ㄩ兘姝ｇ‘鍦拌缃簡瀛楃闆嗐€傚彲浠ラ€氳繃浠ヤ笅SQL鍛戒护鏉ユ鏌?
SHOW VARIABLES LIKE \'character_set%\';
SHOW VARIABLES LIKE \'collation%\';
鐞嗘兂鎯呭喌涓嬶紝浣犲簲璇ョ湅鍒?code>utf8mb4浣滀负榛樿瀛楃闆嗕互鍙婂搴旂殑鎺掑簭瑙勫垯锛堜緥濡傦細utf8mb4_unicode_ci)銆傚鏋滀笉鏄繖鏍凤紝閭ｄ箞浣犻渶瑕佷慨鏀硅繖浜涘弬鏁般€傚彲浠ヤ娇鐢ㄥ涓婼QL璇彞鏇存敼鐜版湁鏁版嵁搴撳拰琛ㄧ殑瀛楃闆嗭細
ALTER DATABASE your_database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
2. 妫€鏌HP鑴氭湰涓殑杩炴帴璁剧疆
濡傛灉浣犵殑搴旂敤绋嬪簭鏄敤PHP缂栧啓鐨勶紝鍦ㄥ缓绔嬩笌MySQL鏁版嵁搴撶殑杩炴帴鏃讹紝涔熼渶瑕佹寚瀹氭纭殑瀛楃闆嗐€傚浜庤緝鏂扮殑PHP鐗堟湰锛屼綘鍙互閫氳繃mysqli鎴栬€匬DO鎵╁睍鏉ュ疄鐜拌繖涓€鐐广€?/p>
浠ysqli涓轰緥锛?/p>
$mysqli = new mysqli(\"host\", \"username\", \"password\", \"database\");
$mysqli->set_charset(\"utf8mb4\");
濡傛灉浣跨敤PDO锛屽垯鍙互鍦ㄥ垱寤鸿繛鎺ユ椂鐩存帴鎸囧畾瀛楃闆嗭細
$pdo = new PDO(\'mysql:host=host;dbname=database;charset=utf8mb4\', \'username\', \'password\');
3. 鏂囦欢鏈韩鐨勭紪鐮佹牸寮?/h2>
闄や簡鏁版嵁搴撳唴閮ㄧ殑璁剧疆澶栵紝杩橀渶瑕佺‘淇濅綘涓婁紶鍒版湇鍔″櫒涓婄殑鎵€鏈夋枃浠舵湰韬篃鏄疷TF-8缂栫爜鐨勩€傝澶氭枃鏈紪杈戝櫒鍏佽鐢ㄦ埛閫夋嫨淇濆瓨鏂囦欢鏃舵墍浣跨敤鐨勭紪鐮佹牸寮忋€傝鍔″繀纭鎵€鏈夌殑HTML銆丆SS銆丣S浠ュ強鍏朵粬鐩稿叧鏂囦欢鍧囬噰鐢║TF-8缂栫爜锛屽苟涓斾笉瑕佸甫鏈塀OM锛堝瓧鑺傞『搴忔爣璁帮級銆?/p>
4. 娴忚鍣ㄧ鐨勮〃鐜?/h2>
鏈€鍚庝絾鍚屾牱閲嶈鐨勬槸锛屾祻瑙堝櫒濡備綍瑙ｉ噴椤甸潰鍐呭涔熷緢鍏抽敭銆傜‘淇濈綉椤靛ご閮ㄥ寘鍚簡姝ｇ‘鐨?meta charset=”UTF-8″>鏍囩銆備緥濡傦細
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">
杩欐牱鍋氬彲浠ュ憡璇夋祻瑙堝櫒搴旇鎸夌収鍝瀛楃闆嗘潵娓叉煋椤甸潰鍐呭銆?/p>
閫氳繃浠ヤ笂鍑犱釜姝ラ锛屾垜浠彲浠ユ湁鏁堝湴瑙ｅ喅JustHost鐜涓嬬殑鏁版嵁搴撳瓧绗︾紪鐮侀棶棰樸€傝浣忥紝鑹ソ鐨勭紪鐮佸疄璺典笉浠呮湁鍔╀簬閬垮厤涔辩爜鐜拌薄锛岃繕鑳芥彁楂樿法骞冲彴鍏煎鎬у拰鐢ㄦ埛浣撻獙銆傚鏋滀綘浠嶇劧閬囧埌浜嗗洶闅撅紝寤鸿鑱旂郴JustHost鐨勬妧鏈敮鎸佸洟闃熻幏鍙栬繘涓€姝ョ殑甯姪銆?/p>
