涓€銆佺粺涓€瀛楃缂栫爜璁剧疆
纭繚phpMyAdmin鐣岄潰涓嶮ySQL鏈嶅姟鍣ㄧ殑瀛楃闆嗙粺涓€涓篣TF-8鎴朥TF8MB4銆傚湪phpMyAdmin棣栭〉鏌ョ湅鏈嶅姟鍣ㄧ紪鐮佺姸鎬侊紝鑻ユ樉绀轰负latin1鎴朿p1252锛岄渶淇敼閰嶇疆鏂囦欢config.inc.php锛屾坊鍔犱互涓嬪弬鏁帮細
$cfg['DefaultCharset'] = 'utf8mb4'; $cfg['DefaultConnectionCollation'] = 'utf8mb4_general_ci';
鍚屾椂淇敼PHP閰嶇疆鏂囦欢php.ini涓殑mysql鍜宮ysqli妯″潡瀛楃闆嗚缃€?/p>
浜屻€佸垱寤烘暟鎹簱鏃舵寚瀹氬瓧绗﹂泦
鍦╬hpMyAdmin鏂板缓鏁版嵁搴撴椂锛屽繀椤绘樉寮忛€夋嫨瀛楃闆嗭細
- 杩涘叆鏁版嵁搴撳垱寤虹晫闈紝濉啓鍚嶇О鍚庨€夋嫨瀛楃闆嗕负utf8mb4_general_ci
- 閬垮厤浣跨敤榛樿鐨刲atin1鎴杇bk瀛楃闆嗭紝闄ら潪鐗规畩闇€姹?/li>
- 宸叉湁鏁版嵁搴撳彲閫氳繃SQL璇彞淇敼锛?br>
ALTER DATABASE dbname CHARACTER SET utf8mb4
涓夈€佷慨鏀筂ySQL鏈嶅姟鍣ㄩ粯璁ゅ瓧绗﹂泦
鍦╩y.cnf鎴杕y.ini閰嶇疆鏂囦欢涓坊鍔犱互涓嬮厤缃锛?/p>
[mysqld] character-set-server = utf8mb4 collation-server = utf8mb4_general_ci
淇敼鍚庨渶閲嶅惎MySQL鏈嶅姟鐢熸晥銆俉indows绯荤粺鍙€氳繃鏈嶅姟绠＄悊鍣ㄦ搷浣滐紝Linux绯荤粺浣跨敤systemctl restart mysql鍛戒护銆?/p>
鍥涖€丳HP杩炴帴瀛楃闆嗚缃?/h2>
鍦≒HP绋嬪簭涓缓绔嬫暟鎹簱杩炴帴鍚庣珛鍗虫墽琛屽瓧绗﹂泦澹版槑锛?/p>
- 浣跨敤鍘熺敓MySQLi鎵╁睍锛?br>
$mysqli->set_charset('utf8mb4') - 浣跨敤PDO杩炴帴鏃惰缃瓺SN鍙傛暟锛?br>
charset=utf8mb4 - 浼犵粺mysql鎵╁睍闇€鎵ц锛?br>
mysql_query("SET NAMES 'utf8mb4'")
浜斻€侀獙璇佷笌缁存姢
閫氳繃浠ヤ笅鍛戒护楠岃瘉瀛楃闆嗚缃細
SHOW VARIABLES LIKE 'character_set%'; SHOW CREATE DATABASE dbname;
瀹氭湡妫€鏌ユ暟鎹〃瀛楁鐨勫瓧绗﹂泦锛屼娇鐢?code>ALTER TABLE璇彞鏇存柊閬楃暀瀛楁銆傚缓璁紑鍙戠幆澧冧笌鐢熶骇鐜淇濇寔瀹屽叏涓€鑷寸殑瀛楃闆嗛厤缃€?/p>
缁撹锛氳В鍐硃hpMyAdmin鏁版嵁搴撳悕涔辩爜鐨勬牳蹇冨湪浜庡缓绔嬪叏閾捐矾瀛楃闆嗙粺涓€鏈哄埗锛屼粠鏈嶅姟鍣ㄩ厤缃€佹暟鎹簱鍒涘缓鍒板簲鐢ㄥ眰杩炴帴鍧囬渶閲囩敤UTF8MB4缂栫爜锛岄厤鍚堝畾鏈熼獙璇佸彲褰诲簳閬垮厤涔辩爜闂銆?/p>
