MySQL統(tǒng)一編碼

主要是解決中文亂碼的問題，下面的命令是統(tǒng)一成gb2312的··要用gbk的話將gb2312換成gbk就行了 。

進(jìn)入命令行模式，

如果MySQL數(shù)據(jù)庫已經(jīng)安裝好，可以使用下列SQL命令查看MySQL當(dāng)前的字符集設(shè)置：
mysql> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------+
-
 

| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'collation_%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)

依次執(zhí)行：

set character_set_client =gb2312;

set character_set_connection =gb2312;

set   character_set_database =gb2312;

set character_set_results =gb2312;

set character_set_server =gb2312;

set character_set_system =gb2312; --此處utf-8也可以

然后執(zhí)行：

SET collation_server = gb2312_chinese_ci

SET collation_database = gb2312_chinese_ci

SET collation_connection =gb2312_chinese_ci

-----------------------------------以下是查看和修改MSQL數(shù)據(jù)庫、表、字段編碼的命令---------------------

mysql在創(chuàng)建數(shù)據(jù)庫時默認(rèn)指定了database,table,column的字符集；

當(dāng)現(xiàn)有database支持的字符集不符合條件時，可以進(jìn)行修改，需要將database,table,column的字符集均進(jìn)行修改。在允許的情況下重新建database比較簡單，

重新建立database：
1。查看數(shù)據(jù)庫支持的字符集
mysql>SHOW CHARACTER SET
2.創(chuàng)建數(shù)據(jù)庫
create database db_name DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
或create database db_name DEFAULT CHARACTER SET gbk ;
3.創(chuàng)建table,則table的缺省字符集同database

修改已有的database和table
1。查看數(shù)據(jù)庫支持的字符集：
    mysql>show create database lian;
或 mysql>show create database lian\G;
2. 修改數(shù)據(jù)庫的字符集：
   mysql>alter DATABASE lian DEFAULT CHARACTER SET gbk;
注:在修改后的database中建立table,則新的table使用同數(shù)據(jù)庫一致的字符集
3. 查看table的字符集,注意column的字符集
   mysql>show create table user_info;
4.修改table的字符集
   mysql>alter TABLE user_info DEFAULT CHARACTER SET gbk;
5.修改column的字符集
   mysql>ALTER TABLE user_info MODIFY id varchar(50) character set gbk NOT NULL;

服務(wù)器租用/服務(wù)器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]