mysql设置字符集

字符集设置主要涉及下面两类

SET character_set_system = 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 collation_connection = gb2312_chinese_ci;
SET collation_database = gb2312_chinese_ci;
SET collation_server = gb2312_chinese_ci;

分别可以用下面的语句看结果

SHOW VARIABLES LIKE 'collation%';

SHOW VARIABLES LIKE 'character%';

 

需要注意的是collation的设置用的是字符集全名，character用的是简称