修改mysql数据库的默认编码

一、先通过mysql命令 show variables like 'character%'; 查看mysql的各种默认编码。

看看其中character_set_client,character_set_connection,character_set_database,character_set_system的编码是否都是utf-8(如果需要的话)。不是的话可以修改

修改mysql默认字符集，可以用mysql的命令：

 mysql>SET character_set_client = utf8 ;

mysql>SET character_set_connection= utf8 ;

mysql>SET character_set_database= utf8 ;

最后再查看一下mysql的编码，发现mysql的编码都改成utf-8了。

+--------------------------+----------------------------------------+
| Variable_name            | Value                                  |
+--------------------------+----------------------------------------+
| character_set_client     | utf8                                   |
| character_set_connection | utf8                                   |
| character_set_database   | utf8                                   |
| character_set_filesystem | binary                                 |
| character_set_results    | gbk                                    |
| character_set_server     | utf8                                   |
| character_set_system     | utf8                                   |
| character_sets_dir       | D:\mysql-5.6.24-winx64\share\charsets\ |
+--------------------------+----------------------------------------+

 

 

二、如果不想修改mysql的编码，只想修改数据库，表以及字段的编码，就可用下面的方式：

　　1.修改数据库的编码：ALTER DATABASE `test` DEFAULT CHARACTER SET utf8;

　　2.修改表的编码：ALTER TABLE `user` DEFAULT CHARACTER SET utf8;

　　3.修改字段的编码：ALTER TABLE `user` CHANGE `username` `username` VARCHAR( 45 ) CHARACTER SET utf8 NOT NULL;

转载于:https://www.cnblogs.com/checkingpei/p/5125141.html