select CAST(field AS CHAR CHARACTER SET utf8/gbk) as body from table 转载于:https://my.oschina.net/suzm/blog/800080