mysql编码问题

MySQL鐨勯粯璁ょ紪鐮佹槸Latin1锛屼笉鏀寔涓枃锛岃鏀寔涓枃闇€瑕佹妸鏁版嵁搴撶殑榛樿缂栫爜淇敼涓篻bk鎴栬€卽tf8銆?

1銆佹煡鐪嬬紪鐮佷互root 鏂瑰紡鐧诲綍 鍦╩ysql涓嬫煡鐪嬬紪鐮佺殑鏂瑰紡涓?

鍏朵腑锛? character_set_client 聽 聽 聽 聽 聽 聽 聽瀹㈡埛绔紪鐮佹柟寮忥紱 character_set_connection 聽 聽 涓哄缓绔嬭繛鎺ヤ娇鐢ㄧ殑缂栫爜锛? character_set_database 聽 聽 聽 聽鏁版嵁搴撶殑缂栫爜锛? character_set_results 聽 聽 聽 聽 聽 聽缁撴灉闆嗙殑缂栫爜锛? character_set_server 聽 聽 聽 聽 聽 聽 鏁版嵁搴撴湇鍔″櫒鐨勭紪鐮侊紱 鍙淇濊瘉浠ヤ笂缂栫爜缁熶竴涓簎tf8 鎴栬€単bk锛屽氨涓嶄細鍑虹幇涔辩爜闂銆? 2銆佷慨鏀规暟鎹簱缂栫爜 1锛夈€佸垱寤烘暟鎹簱鎸囧畾鏁版嵁搴撶殑瀛楃闆?

聽 聽 聽mysql> create database mydb character set gbk;#鐩存帴鎸囧畾鍏剁紪鐮?

2锛夈€佺洿鎺ラ€氳繃鍛戒护杩涜淇敼

聽 聽 聽set character_set_client=gbk;

聽 聽 聽set character_set_connection=gbk;

聽 聽 聽set character_set_database=gbk;

聽 聽 聽set character_set_results=gbk;

聽 聽 聽set character_set_server=gbk;

3锛夈€乴inux绯荤粺涓嬶紝淇敼MySQL鏁版嵁搴撻粯璁ょ紪鐮佺殑姝ラ涓猴細

聽 聽 聽 聽聽聽鍋滄MySQL鐨勮繍琛? 聽 聽 聽 聽聽聽MySQL涓婚厤缃枃浠朵负my.cnf 聽 聽 聽 聽 聽褰撴垜浠渶瑕佷慨鏀筂ySQL鏁版嵁搴撶殑榛樿缂栫爜鏃讹紝闇€瑕佺紪杈憁y.cnf鏂囦欢杩涜缂栫爜淇敼,鍦╨inux涓嬩慨鏀筸ysql鐨勯厤缃枃浠秏y.cnf锛屾枃浠朵綅缃?聽 聽 聽 聽 聽 聽 聽 聽榛樿/etc/my.cnf鏂囦欢娣诲姞default-character-set=gbk 聽 聽 聽 聽 閲嶅惎鏁版嵁搴? 4锛夈€?鎵ц鑴氭湰锛氭寚瀹氱紪鐮佹牸寮弒et names gbk(娉ㄦ剰锛屼笉鏄疷TF-8)鍙互淇敼 聽 聽 聽 浠庢墽琛屽懡浠ゅ墠鍚庡彲鐭ワ紝

聽SET NAMES 'gbk';

瀹冪浉褰撲簬涓嬮潰鐨勪笁鍙ユ寚浠わ細

SET character_set_client =gbk;

SET character_set_results =聽gbk;

SET character_set_connection =聽gbk;

骞朵笖杩欑淇敼鏄獥鍙ｇ骇鍒殑锛屽彧閽堝鏈獥鍙ｆ湁鏁堬紝鎵撳紑鍙﹀涓€涓獥鍙ｄ慨鏀规棤鏁堛€備篃鍙彂鐜版暟鎹簱搴曞眰鐨勭紪鐮佹柟寮忔病鏈夋敼鍙橈紝鎻掑叆鏁版嵁鍚庤繕鏄互鍘熸潵鐨勭紪鐮佹柟寮忎繚鎸併€?

5)銆佷慨鏀规暟鎹簱鎴栬〃鐨勮鍙ワ細

聽 聽 1. 鍒涘缓鏁版嵁搴? 聽 聽 聽 聽 聽mysql> create database name character set gbk;

聽 聽 2. 鍒涘缓琛? 聽 聽 聽 聽 CREATE TABLE `test` (

聽 聽 聽 聽 `id` int(10) unsigned NOT NULL auto_increment,

聽 聽 聽 聽 PRIMARY KEY (`id`)

聽 聽 聽 聽 ) DEFAULT CHARSET=gbk;

聽 聽 3. 淇敼鏁版嵁搴撴垚utf8鐨?

聽 聽 聽 聽 聽mysql> alter database name character set gbk;

聽 聽 聽4. 淇敼琛ㄩ粯璁ょ敤utf8.

聽 聽 聽 聽 聽mysql> alter table type character set gbk;

聽 聽 聽5. 淇敼瀛楁鐢╱tf8

聽 聽 聽 聽 mysql> alter table type modify type_name varchar(50) CHARACTER SET gbk;