查看数据库所有属性编码格式：
mysql> show variables like 'character%';
+--------------------------+-------------------------------+
| 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:\soft\mysql\share\charsets\ |
+--------------------------+-------------------------------+
查看数据库编码格式
mysql> show create database test;
+----------+---------------------------------------------------------------+
| Database | Create Database |
+----------+---------------------------------------------------------------+
| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+---------------------------------------------------------------+
查看表编码格式
mysql> show create table user;
+-------+------------------------------------
| Table | Create Table
+-------+------------------------------------
| user | CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`age` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------
创建数据库时指定编码格式
mysql> create database <要创建的数据库的名字> charset utf8;
Query OK, 1 row affected (0.01 sec)
修改单个数据库的编码格式
mysql> alter database myblog character set utf8;
Query OK, 1 row affected (0.00 sec)
修改数据库默认编码
mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)
---------------------
原文：/weixin_44278512/article/details/86366192