oracle 8i数据导出,具体8i什么字符集不清楚.导入到oracle 10g中,显示的信息:
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set <possible charset conversion>
export server uses US7ASCII NCHAR character set <possible charset conversion>
查询显示的中文表内容都是??
查看oracle10g ,为AMERICAN_AMERICA.ZHS16GBK.怎么解决这个问题呢?
------解决方案--------------------
用2进制文件编辑工具，如uedit32打开导出的dmp文件，将2、3字节的内容，改成0354即可