方案1.设置编码命令:
set character_set_client =utf8;
set character_set_connection =utf8;
set character_set_database =utf8;
set character_set_results =utf8;
set character_set_server =utf8;
set character_set_system =utf8;
方案2.直接创建时设置编码:
创建一个编码为utf8的数据库:
create database ssh2 character set 'utf8' collate 'utf8_general_ci';
查看编码是否一致命令:show variables like 'character%';
显示结果:
