修改Mysql编码

最新推荐文章于 2024-11-15 16:27:37 发布

Char_CN

最新推荐文章于 2024-11-15 16:27:37 发布

阅读量502

点赞数

分类专栏： Mysql 文章标签： mysql character variables server database system

本文链接：https://blog.csdn.net/Char_CN/article/details/7954184

版权

Mysql 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

1.查询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 | C:\Program Files (x86)\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+---------------------------------------------------------------+

修改编码: set character_set_client=utf8;

原文来自:http://blog.csdn.net/char_cn/article/details/7954184