mysql字符设置

show variables like 'character_set_%';

要进入mysql数据库，然后对字符集重新进行配置，注意，每次使用安装mysql数据库的时候都要设置
SET character_set_system= gbk;
SET character_set_server=gbk;
SET character_set_client=gbk;
SET character_set_connection=gbk;
SET character_set_database=gbk;
SET character_set_results=gbk;
SET collation_connection=gbk_chinese_ci;
SET collation_database=gbk_chinese_ci;
SET collation_server=gbk_chinese_ci;