英文系统下exp和imp 中文显示乱码问题
以下是导入新建的库的操作日志，操作完成后查看数据，中文显示乱码，从日志判断，有人知道哪里不对吗？
注意日志中的字符集提示哦。
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.01.00 via direct path
import done in UTF8 character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
. . importing table "BASE_ANALYSE" 267 rows imported
. . importing table "BASE_CODE" 14 rows imported
. . importing table "BASE_CODEMX" 202 rows imported
. . importing table "BASE_CONTROLS" 7 rows imported
. . importing table "BASE_PHENOMENON" 276 rows imported
. . importing table "BASE_TECHNICSFLOW" 24 rows imported
. . importing table "BASE_TECHNICSFLOWMX" 42 rows imported
. . importing table "MH_USERLINE" 0 rows imported
. . importing table "MH_USERLINEMX" 0 rows imported
. . importing table "ORD_CUSTOMER" 2 rows imported
. . importing table "ORD_PRODUCE" 4 rows imported
. . importing table "ORD_PRODUCELOG" 90 rows imported
. . importing table "ORD_PRODUCEMX" 300 rows imported
. . importing table "ORD_PRODUCESCHEME" 527 rows imported
. . importing table "ORD_PRODUCE_FENPEI" 0 rows imported
. . importing table "ORD_PRODUCE_TFGDKZTF" 13 rows imported
. . importing table "PP_ERRORDATA" 668 rows imported
. . importing table "PP_METERTOKENCHANGE" 0 rows imported
. . importing table "PP_OPERATEMX" 1909954 rows imported
. . importing table "PP_OPERATEMX_SUB" 86996 rows imported
. . importing table "PP_PEOPLEOPT" 0 rows imported
. . importing table "PP_PEOPLEOPTBY_QTY" 0 rows imported
. . importing table "PP_POWER_CHECK_ITEM" 20 rows imported
. . importing table "PP_PRODUCT" 300 rows imported
. . importing table "PP_PRODUCTERROR" 0 rows imported
. . importing table "PP_PRODUCTTEST" 0 rows imported
. . importing table "PRO_FUNPLAN" 595 rows imported
. . importing table "PRO_FUNPLANITEM" 185 rows imported
. . importing table "PRO_FUNPLANITEM_BAK" 66 rows imported
. . importing table "PRO_FUNPLANMX" 1833 rows imported
. . importing table "PRO_FUNPLANMX_BAK" 658 rows imported
. . importing table "PRO_FUNPLAN_BAK" 200 rows imported
. . importing table "PRO_PRODUCTMODEL" 12 rows imported
. . importing table "PRO_TECHNICSFLOW" 244 rows imported
. . importing table "PRO_TECHNICSFLOWMX" 1109 rows imported
. . importing table "PRO_TMODELTESTTYPE_MX" 4 rows imported
. . importing table "Q_FAULT" 0 rows imported
. . importing table "Q_FAULTREP_MX" 0 rows imported
. . importing table "Q_FAULT_MX" 0 rows imported
. . importing table "SYS_DEBUG_LOG" 0 rows imported
. . importing table "SYS_DEBUG_SQLLOG" 0 rows imported
. . importing table "SYS_DEPARTMENT" 8 rows imported
. . importing table "SYS_FUN" 46 rows imported
. . importing table "SYS_IDENTITY" 9 rows imported
. . importing table "SYS_LOG" 0 rows imported
. . importing table "SYS_MENU" 29 rows imported
. . importing table "SYS_QUERY" 4 rows imported
. . importing table "SYS_ROLE" 6 rows imported
. . importing table "SYS_ROLEFUN" 1570 rows imported
. . importing table "SYS_ROLEPOWER" 0 rows imported
. . importing table "SYS_ROLEQUERY" 229 rows imported
. . importing table "SYS_SCHEDULEJOB" 0 rows imported
. . importing table "SYS_USER" 9 rows imported
. . importing table "SYS_USERROLE" 2666 rows imported
About to enable constraints...
Import terminated successfully without warnings.
乱码 character Oracle 服务器
[解决办法]
执行下面的SQL查看服务端使用字符集，客户端的NLS_LANG环境变量指定的字符集要和它兼容
select * from database_properties where property_name='NLS_CHARACTERSET'
另外执行imp/exp的终端使用的LANG环境变量也最好调整成兼容的字符集，如果客户端是Windows就不用那么麻烦了~
[解决办法]
字符集不兼容问题引起的