[20120802]ctas与字符集问题.txt

如果数据库安装的字符集是NLS_LANG=AMERICAN_AMERICA.US7ASCII

SQL>  create table t1 as select rpad(rownum,30) name from dual connect by level<=1;

Table created.


SQL> desc t1;

Name             Null?    Type

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

NAME                      VARCHAR2(30)


SQL>  select dump(name) from t1;


DUMP(NAME)

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

Typ=1 Len=30: 49,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32


如果数据库安装的字符集是NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK


SQL> create table t1 as select rpad(rownum,30) name from dual connect by level<=1;


Table created.


SQL> desc t1;

Name          Null?    Type

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

NAME                   VARCHAR2(60)


SQL> select dump(name) from t1;

DUMP(NAME)

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

Typ=1 Len=30: 49,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32

--保存的东西一样的,但是生成的表结构不一样!

ITPub博客

[20120802]ctas与字符集问题.txt