这是在10g, Windows 2008 下执行SQLPlusw上的执行结果:
SQL>select value$ from props$ where name='NLS_CHARACTERSET'
VALUE$
--------------------------------------------------------------------------------
UTF8
SQL>create table test1(utf8char varchar2(8))
Table created.
SQL> insert into test1 values('我');
1 row created.
SQL> select utf8char, length(utf8char), dump(utf8char) from test1;
UTF8CHAR LENGTH(UTF8CHAR)
-------- ----------------
DUMP(UTF8CHAR)
--------------------------------------------------------------------------------
??
2
Typ=1 Len=6: 239,191,189,239,191,189
很明显"我"这个中文用了6个字节却存储,而后面3个字节明显是重复的!真不知道这是怎么搞的!!!
|