mysql更改數(shù)據(jù)庫(kù)字符編碼的方法:首先調(diào)出“運(yùn)行”,輸入cmd;然后登錄數(shù)據(jù)庫(kù),查看數(shù)據(jù)庫(kù);最后修改數(shù)據(jù)庫(kù)的字符集,代碼為【mysql>use mydb】。
相關(guān)免費(fèi)學(xué)習(xí):mysql數(shù)據(jù)庫(kù)(視頻)
mysql更改數(shù)據(jù)庫(kù)字符編碼的方法:
1、win+R,調(diào)出“運(yùn)行”,輸入cmd,回車
2、mysql 更改數(shù)據(jù)庫(kù)字符編碼的方法
登錄數(shù)據(jù)庫(kù),
3、查看數(shù)據(jù)庫(kù)
4、查看數(shù)據(jù)庫(kù)字符編碼
5、通過MySQL命令行修改:(編碼可選)
mysql> set character_set_client=utf8; mysql> set character_set_connection=utf8; mysql> set character_set_database=utf8; mysql> set character_set_results=utf8; mysql> set character_set_server=utf8; mysql> set character_set_system=utf8; mysql> set collation_connection=utf8; mysql> set collation_database=utf8; mysql> set collation_server=utf8;
6、當(dāng)然還有:
修改數(shù)據(jù)庫(kù)的字符集mysql>use mydb
mysql>alter database mydb character set utf8;
7、創(chuàng)建數(shù)據(jù)庫(kù)指定數(shù)據(jù)庫(kù)的字符集
mysql>create database mydb character set utf8;