UTF-8 question

I have a oracle test server 10.2.0.1 on windows 2000, created a db with UTF-8 charset.

CREATE TABLE TEST (C1 VARCHAR2(20); INSERT INTO TEST VALUES ('豐'); --BIG5 tranditional chinese font

INSERT INTO TEST VALUES ('榮');

INSERT INTO TEST VALUES ('张三'); --simplied chinese font

SQL> select dump(c1,1016) from test;

DUMP(C1,1016)

Typ=1 Len=2 CharacterSet=AL32UTF8: d8,53
Typ=1 Len=2 CharacterSet=AL32UTF8: 98,73
Typ=1 Len=4 CharacterSet=AL32UTF8: d5,c5,c8,fd

SQL> select length(c1) from test;

LENGTH(C1)

          1
          2
          2
          2

SQL> select lengthb(c1) from test;

LENGTHB(C1)

          2
          2
          4
          2

1. The lengthb and length has different result result.
2. The first row and second row has two bytes space, but the length function return 1 and 2 value, it is strange. Can anyone help on this one?

Thanks in advance! Received on Sun Dec 11 2005 - 07:27:05 CST