windows 的MySQL数据库不支持中文修改

查看当前数据库支持的编码格式：

show variables like 'char%';

image.png

直接修改

set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci; 

查看建数据库语句：

show create database 库名;

查看建表语句：

show create table 表名;