AL32UTF8与ZHS16GBK转换

##########################################################AL32UTF8
create user zfj identified by zfj;
grant resource,connect to zfj;
SYS DATA_PUMP_DIR         /opt/app/oracle/admin/oratest/dpdump/
grant read,write on directory DATA_PUMP_DIR to zfj;

conn zfj/zfj
create table zfj(yw varchar(10),zw char(10));
insert into zfj values('aaaaaaaaaa','aaaaaaaaaa');
insert into zfj values('b','b');
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
sqlplus zfj/zfj
insert into zfj values ('江苏','江苏');
insert into zfj values ('江苏库','江苏库');
commit;

idle> select * from zfj;


YW   ZW
---------- ----------
aaaaaaaaaa aaaaaaaaaa
b   b
江苏