oracle用sqluldr在Linux服务器导出txt文件乱码

----------------------------------Oracle端的编码：

select userenv('language') from dual

 

 

-----------------------LINUX服务器的编码

locale命令

----------------------------------------------//导出命令

sqluldr  user="usrname/mpassword@132.35.224.1:1521/dssdw" field=0x09 record=0x0d0x0a query="select AREA_ID,AREA_DESC,IS_UP,IS_NECESSARY,IS_VALID,PROV_ID,AREA_ID_NEW,ORD_ID,AREA_CODE,AREA_ID_JS,AREA_DESCRIPTION,ORD_LEVEL,CODE_UPDATE_DATE from zb_out.dim_bi_area_js ;" file="/data/all_roamsett_pro/bonc/dim_bi_area_js.file.txt" charset=ZHS16GBK;

-------------------------------------------------//修改

将charset=ZHS16GBK改为charset=AL32UTF8