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

最新推荐文章于 2024-07-30 04:03:20 发布

ysu_jiang

最新推荐文章于 2024-07-30 04:03:20 发布

阅读量4.1k

点赞数 12

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

本文链接：https://blog.csdn.net/jiangpeii/article/details/84348609

版权

错误总结专栏收录该内容

4 篇文章 0 订阅

订阅专栏

在这里插入图片描述

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)