mysql 插入不了中文

1  检查编码

show variables like ‘%character%’;

show variables like’%collation%’;

2 如不是utf-8  设置编码

et 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;

 

可以建立数据的时候设置编码

create database name character  set utf8;