mysql存储过程乱码

在写测试的时候mysql的存储过程传入的参数存在乱码问题，代码如下：

CREATE PROCEDURE `getCountByName`(IN uname varchar(32) , OUT sum int)
BEGINselect uname;
        select count(*) as counts from `user` where username=uname;
END
;;

结果如下：

问题便是输入的参数编码有问题，改为utf8应该就好啦

CREATE PROCEDURE `getCountByName`(IN uname varchar(32) character set utf8, OUT sum int)
BEGIN
    #Routine body goes here...
        select uname;
        select count(*) as counts from `user` where username=uname;
END

将输入参数uname通过 character set utf8设置为utf8编码格式，结果正常了