字符集转换的问题~

刚在网上搜了些文章 可还是感觉自己对这个字符集理解的不够透彻 如果哪位有好点的文章给推荐一份吧

先来说说现在碰到的问题吧 如下面代码所示

C:\Documents and Settings\Admin>chcp

活动的代码页: 936

C:\Documents and Settings\Admin>set nls_lang=AMERICAN_AMERICA.UTF8



C:\Documents and Settings\Admin>sqlplus "/ as sysdba"



SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 23 13:28:24 2009



Copyright (c) 1982, 2005, Oracle.  All rights reserved.





Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> create table tt(name varchar2(100));



Table created.



SQL> insert into tt values('一');



1 row created.



SQL> insert into tt values('二');



1 row created.



SQL> commit;



Commit complete.



SQL> select * from tt;



NAME

--------------------------------------------------------------------------------



一

二



SQL>

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

 - Production

With the Partitioning, OLAP and Data Mining options



C:\Documents and Settings\Admin>set nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBK



C:\Documents and Settings\Admin>sqlplus "/ as sysdba"



SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 10月 23 13:29:49 2009



Copyright (c) 1982, 2005, Oracle.  All rights reserved.





连接到:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options



SQL> select * from tt;



NAME

--------------------------------------------------------------------------------



？

??



SQL> insert into tt values('三');



已创建 1 行。



SQL> insert into tt values('四');



已创建 1 行。



SQL> commit;



提交完成。



SQL> select * from tt;



NAME

--------------------------------------------------------------------------------



？

??

三

四



SQL>

SQL> 从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options 断开



C:\Documents and Settings\Admin>set nls_lang=AMERICAN_AMERICA.UTF8



C:\Documents and Settings\Admin>sqlplus "/ as sysdba"



SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 23 13:30:27 2009



Copyright (c) 1982, 2005, Oracle.  All rights reserved.





Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options



SQL> select * from tt;



NAME

--------------------------------------------------------------------------------



一

二

涓

鍥



SQL>

1、
用chcp显示出来的936应该代表的是我操作系统的字符集吧?

2、
为什么
用SIMPLIFIED CHINESE_CHINA.ZHS16GBK插入的数据在UTF8下显示不出来
用UTF8插入的数据在set nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBK后也显示不出来
一个显示乱码 一个显示问号?

3、
我的环境是WINDOWS XP+ORACLE 10GR2
记得前几天看EYGLE的一本书上写着字符集分三个
数据库字符集 客户端字符集 客户端应用字符集
那SQL*PLUS算是客户端还是客户端应用呢

SQL> select * from nls_database_parameters;



PARAMETER                      VALUE

------------------------------ ------------------------------

NLS_LANGUAGE                   AMERICAN

NLS_TERRITORY                  AMERICA

NLS_CURRENCY                   $

NLS_ISO_CURRENCY               AMERICA

NLS_NUMERIC_CHARACTERS         .,

NLS_CHARACTERSET               UTF8

NLS_CALENDAR                   GREGORIAN

NLS_DATE_FORMAT                DD-MON-RR

NLS_DATE_LANGUAGE              AMERICAN

NLS_SORT                       BINARY

NLS_TIME_FORMAT                HH.MI.SSXFF AM



PARAMETER                      VALUE

------------------------------ ------------------------------

NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM

NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR

NLS_DUAL_CURRENCY              $

NLS_COMP                       BINARY

NLS_LENGTH_SEMANTICS           BYTE

NLS_NCHAR_CONV_EXCP            FALSE

NLS_NCHAR_CHARACTERSET         UTF8

NLS_RDBMS_VERSION              10.2.0.1.0



20 rows selected.



SQL>

注册表里所有的NLS_LANG都设置的是AMERICAN_AMERICA.UTF8

希望通过这个帖子能让我彻底搞清楚字符集~大家帮帮忙~