----------------------------------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