– 查看系统保存的三种关系处理字符集
show variables like ‘character_set%’;
– 当character_set_client = character_set_results 时,插入中文就可显示出来
insert into my_bos values (‘知识’,25);
– 若不相同就修改变量
set character_set_client = gbk;
set character_set_results = gbk;
– 查看系统保存的三种关系处理字符集
show variables like ‘character_set%’;
– 当character_set_client = character_set_results 时,插入中文就可显示出来
insert into my_bos values (‘知识’,25);
– 若不相同就修改变量
set character_set_client = gbk;
set character_set_results = gbk;