Mysql自定义函数:
create function showme(a varchar(255) )
returns varchar(255) CHARACTER SET utf8
begin
return (a) ;
end=========================================select showme(di.districtName) from district di=========================================结果集乱码:
create function showme(a varchar(255) )
returns varchar(255) CHARACTER SET utf8
begin
return (a) ;
end=========================================select showme(di.districtName) from district di=========================================结果集乱码:
mysql配置文件里,将my.ini中
default-character-set=gbk
2处中默认字符集改成gbk