mysql> use xxx Database changed mysql> show variables like 'character_set_database'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | character_set_database | latin1 | +------------------------+--------+ 1 row in set (0.00 sec)
上面,我們先切換到xxx數(shù)據(jù)庫下面來,然后使用SQL語句:show variables like 'character_set_database'; 來查看了xxx數(shù)據(jù)庫的編碼。查詢得到的結(jié)果是latin1編碼。
下面,我們來修改xxx數(shù)據(jù)庫的編碼,把它修改為gb2312。
mysql> alter database xxx CHARACTER SET gb2312; Query OK, 1 row affected (0.00 sec)
mysql> show variables like 'character_set_database'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | character_set_database | gb2312 | +------------------------+--------+ 1 row in set (0.00 sec)
這里同樣做了兩件事情:
1、使用SQL語句:alter database xxx CHARACTER SET gb2312; 把xxx數(shù)據(jù)庫的編碼設(shè)置為了gb2312.
2、再次使用show variables like 'character_set_database'; 來確認(rèn)一下當(dāng)前xxx是什么編碼。經(jīng)過確認(rèn),數(shù)據(jù)庫編碼已經(jīng)修改為gb2312了。