leimingbuaa 发表于 2011-11-30 15:35
我说的情况就是 plsql developer查询或者exp导出再导入,都是乱码呢
跟os字符集设置还是有关的呢,只是具 ...
exp导出后,再导入到其他用户,查询显示正常,再导出csv文件还是乱码
exp:
Export: Release 11.2.0.1.0 - Production on Wed Nov 30 16:27:05 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
imp:
Import: Release 11.2.0.1.0 - Production on Wed Nov 30 16:33:21 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.02.00 via conventional path
Warning: the objects were exported by USERETL, not by you
import done in ZHS16GBK character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion) |