MySQL写入时中文变成繁体字，解决方法

最新推荐文章于 2021-01-27 23:13:54 发布

ysu_jiang

最新推荐文章于 2021-01-27 23:13:54 发布

阅读量4.3k

点赞数 12

分类专栏：错误总结文章标签： MySQL写入中文乱码

本文链接：https://blog.youkuaiyun.com/jiangpeii/article/details/84348609

版权

错误总结专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了在MySQL中如何设置和转换字符集，包括客户端、连接、数据库和结果集的字符集设置，以及通过ALTER DATABASE和ALTER TABLE命令更改数据库和表的字符集。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在这里插入图片描述

mysql>  set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql>  set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> alter database enterprises character set utf8
    -> alter table employees character set utf8
    -> alter table employees change name name char(10) character set utf-8;
 mysql> show variables like 'char%';
 +--------------------------+---------------------------------------------------------------+
| Variable_name            | Value                                                         |
+--------------------------+---------------------------------------------------------------+
| character_set_client     | utf8                                                          |
| character_set_connection | utf8                                                          |
| character_set_database   | utf8                                                          |
| character_set_filesystem | binary                                                        |
| character_set_results    | utf8                                                          |
| character_set_server     | utf8                                                          |
| character_set_system     | utf8                                                          |
| character_sets_dir       | D:\Program Files (x86)\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------------+
mysql> SET NAMES GBK;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'char%';
+--------------------------+---------------------------------------------------------------+
| Variable_name            | Value                                                         |
+--------------------------+---------------------------------------------------------------+
| character_set_client     | gbk                                                           |
| character_set_connection | gbk                                                           |
| character_set_database   | utf8                                                          |
| character_set_filesystem | binary                                                        |
| character_set_results    | gbk                                                           |
| character_set_server     | utf8                                                          |
| character_set_system     | utf8                                                          |
| character_sets_dir       | D:\Program Files (x86)\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------------+
8 rows in set (0.00 sec)