> 全面讨论字符集问题

dbchip

805 815 816 817 9i for WINDOWS
815 816 817 for AIX
816 for HP_UX
815 817 for SOLARIS
816 817 for LINUX

luckyoracle

比如SUN-64BIT，或者AIX-32BIT。。。
否则，到了现场安不上去，不是害人家吗？？？

给点专业精神好不好？？？大家都是做这个的。。。。

jimin.duan

谁知道american_america.usc??是怎么写的，我记不清了。

jimin.duan

着急！！！平台是aix 4.3 oracle 816，在AIX上导出的数据，因为是后台运行，所以，nls_lang取得是默认值。而我的.profile中设置的是NLS_LANG="simplified chinese_china.zhs16cgb231280"。现在，后台产生的dmp文件，不能再导入我的数据库了。也改动过nls_lang的参数设置。但是，不是不能导入，就是导入以后，产生乱码。请各位高手指点。

jimin.duan

着急！！！平台是aix 4.3 oracle 816，在AIX上导出的数据，因为是后台运行，所以，nls_lang取得是默认值。而我的.profile中设置的是NLS_LANG="simplified chinese_china.zhs16cgb231280"。现在，后台产生的dmp文件，不能再导入我的数据库了。也改动过nls_lang的参数设置。但是，不是不能导入，就是导入以后，产生乱码。请各位高手指点。

chao_ping

目标数据库的字符集市什么？

jimin.duan

它是把自己导出的数据再次导入回去。

mailbob

我修改了props$中的value$
     还有session; database中的所有nl_language
可是用select userenv('language') from dual; 一查，还是原来的字符集，
究竟怎样才能改变它？？

谢谢！

chao_ping

My test results:
db_svcraids> echo $NLS_LANG
AMERICAN_AMERICA.WE8DEC
db_svcraids> sqlplus system/manage

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 10:35:25 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> drop table testforlog;

Table dropped.

SQL> create table testforchar(name varchar2(90));

Table created.

SQL> insert into testforchar values('配送合同信息表');

1 row created.

SQL> commit;

Commit complete.

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
db_svcraids> exp system/manage file=testforchar tables=\(testforchar\)

Export: Release 8.1.7.2.0 - Production on Thu Dec 13 10:36:46 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
Export done in WE8DEC character set and WE8DEC NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                    TESTFORCHAR          1 rows exported
Export terminated successfully without warnings.
db_svcraids> sqlplus system/manage

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 10:36:57 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> drop table testforchar;

Table dropped.

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
db_svcraids> imp system/manage file=testforchar full=y

Import: Release 8.1.7.2.0 - Production on Thu Dec 13 10:37:22 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8DEC character set and WE8DEC NCHAR character set
. importing SYSTEM's objects into SYSTEM
. . importing table                  "TESTFORCHAR"          1 rows imported

Import terminated successfully without warnings.
db_svcraids> db_svcraids> sqlplus system/manage

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 10:37:52 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> select *from testforchar;

NAME
--------------------------------------------------------------------------------
配送合同信息表

SQL>

chao_ping

db_svcraids> echo $NLS_LANG
AMERICAN_AMERICA.WE8DEC
db_svcraids> sqlplus system/manage

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 10:39:33 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL>create table testforchar2(name varchar(90))

Table created.

SQL> insert into testforchar2 values('配送合同信息表');

1 row created.

SQL> commit;

Commit complete.

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

db_svcraids> export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
db_svcraids> exp system/manage file=testforchar2 tables=\(testforchar2\)

Export: Release 8.1.7.2.0 - Production on Thu Dec 13 10:40:50 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
Export done in ZHS16GBK character set and WE8DEC NCHAR character set
server uses WE8DEC character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                   TESTFORCHAR2          1 rows exported
Export terminated successfully without warnings.
db_svcraids> sqlplus system/manage

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 10:40:59 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> select *from testforchar2;

NAME
--------------------------------------------------------------------------------
？？？？？？？??？？？±í

SQL> drop table testforchar2;

Table dropped.

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

db_svcraids> export NLS_LANG=AMERICAN_AMERICA.WE8DEC
db_svcraids> sqlplus system/manage

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 10:42:58 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> select *from testforchar2;

NAME
--------------------------------------------------------------------------------
靠靠靠??靠勘

SQL> drop table testforchar2;

Table dropped.

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
db_svcraids> set -o vi
db_svcraids> imp system/manage file=testforchar2 full=y

Import: Release 8.1.7.2.0 - Production on Thu Dec 13 10:43:30 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8DEC character set and WE8DEC NCHAR character set
export client uses ZHS16GBK character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
. . importing table                 "TESTFORCHAR2"          1 rows imported
Import terminated successfully without warnings.
db_svcraids> sqlplus system/manage

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 10:43:43 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> select *from testforchar2;

NAME
--------------------------------------------------------------------------------
靠靠靠??靠勘

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
db_svc:oraids> echo $NLS_LANG
AMERICAN_AMERICA.WE8DEC
db_svc:oraids>