mysql数据库不能存入中文

mysql数据库不能存入中文

废话不多说：

1、查看字符集编码

show variables like 'char%'

2、直接修改

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;

3、那个表得字段不能存入就直接按照下面语句修改

alter table 数据表 change 字段 VALUE varchar(255) character set utf8;