设置mysql的字符集

ALTER DATABASE test DEFAULT CHARACTER SET utf8;

 

show variables like 'char%';