proc sql;
connect to odbc (user=xxxx password=xxxxxx datasrc=localhost);
create table work.cell as select * from connection to odbc
(select * from xdr.cell);
disconnect from odbc;
quit;
MySQL中的表xdr.cell显示中文正常,导入SAS数据集work.cell后中文出现乱码,MySQL编码格式为utf8,如下所示:
不知哪里出了问题,试了很多方法都没用,求教,谢谢!