éè¿å®¢æ·ç«¯ä¿®æ¹è¡¨å段çé»è®¤å符é
1
æå¼SQLyog客æ·ç«¯ï¼è¿æ¥æ°æ®åºå¦ä¸å¾æ示ï¼ç¹å»connection æé® è¿æ¥æ°æ®åº
2
æçæ°æ®åºå称为edu,ç¶åæéææ¾å°æ°æ®åºä¸test2表ï¼å³é®-----ãAlter Table
3
å¦æå®è£
æ°æ®åºç æ¶å 没æéæ©å符é设置ï¼é£ä¹mysqlæ°æ®åºé»è®¤ä¸ºlatin1ï¼å¨ç®å¤´é¨åéæ©utf8å符é
END
ç¨æ°æ®åºå½ä»¤ä¿®æ¹å符é
1
é¦å
æ¥çå½åæ°æ®åºå符éï¼å¨å½ä»¤æ¡ä¸æ§è¡å¦ä¸å½ä»¤ï¼show variables like 'character_set_%';
2
æ¥çå符éæåºè®¾ç½®ï¼æ§è¡å½ä»¤ï¼show variables like 'collation_%';
3
ä¿®æ¹æå¡å¨çº§å«å符éï¼æ§è¡å½ä»¤ï¼
1ï¼ä¸´æ¶ä¿®æ¹ï¼SET GLOBAL character_set_server=utf8;
2ï¼æ°¸ä¹
ä¿®æ¹ï¼æå¼/etc/mysql/my.cnf,å¨[mysqld]åæ·»å character-set-server=utf8
4
ä¿®æ¹è¡¨çº§å«ï¼å½ä»¤å¦ä¸ï¼ALTER TABLE table_name DEFAULT CHARSET utf8;
ä¿®æ¹æ°æ®åºçº§å«ï¼å½ä»¤å¦ä¸ï¼use edu(æ¢æä½ è¦ä¿®æ¹çæ°æ®åºåï¼å¨è¿éæçæ°æ®åºä¸ºedu),ï¼ç¶åæ§è¡å½ä»¤ï¼alter database edu character set utf-8;
5
æè
ä¿®æ¹mysqlçmy.iniæ件ä¸çå符éé®å¼
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
éå¯mysql
温馨提示:答案为网友推荐,仅供参考