mysql导出Excel格式,中文乱码如何处理
mysql导出数据,导成Excel格式,发现中文乱码,数据库字符集为utf-8,Excel字符集为GB2312,
SELECT * INTO OUTFILE '/tmp/20150709/sys_role.xls' FROM sys_role;
网上查了,有说用convert(label using gb2312)转,报错 ERROR 1115 (42000): Unknown character set: 'gb2312'
SELECT id,convert(label using gbk),parent_id,has_child,,category_type INTO OUTFILE '/tmp/sys_role.xls' FROM sys_role;
最后导出了cvs格式,打开是中文,请问有别的解决办法吗?