设置mysql的字符集

ALTER DATABASE test DEFAULT CHARACTER SET utf8;

show variables like 'char%';