mysql set names gb2312 不能插入中文

来源：百度知道 编辑：UC知道 时间：2024/07/07 23:53:23
输入alter database test character set gb2312 后，可以插入中文数据，
但是用 set names gb2312,也就是将db、client、result的charcterset设为gb2312后，却不能插入中文了，哪位大侠帮一下，呵呵？

依次执行：

set character_set_client =gb2312;

set character_set_connection =gb2312;

set character_set_database =gb2312;

set character_set_results =gb2312;

set character_set_server =gb2312;

set character_set_system =gb2312; --此处utf-8也可以

然后执行：

SET collation_server = gb2312_chinese_ci

SET collation_database = gb2312_chinese_ci

SET collation_connection =gb2312_chinese_ci

set character_set_client =gb2312;

set character_set_connection =gb2312;

set character_set_database =gb2312;

set character_set_results =gb2312;

set character_set_server =gb2312;

set character_set_system =gb2312; --此处utf-8也可以