Re: UTF-8 question

From: lsllcm <lsllcm_at_gmail.com>
Date: 11 Dec 2005 20:37:51 -0800
Message-ID: <1134362271.148194.43060@g49g2000cwa.googlegroups.com>

Sorry, there are four insert statements, and I correct the create table statement

CREATE TABLE TEST (C1 VARCHAR2(20)); 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

But both the first and second rows have two bytes, and the function LENGTHB returns 2, but the function LENGTH returns different values, The result for the first row is 1, and for the second row is 2. It is stange, right?

The document stats "The LENGTH functions return the length of char."

But both the first row and second row has one Chinese set char.

Thanks for your answer Received on Sun Dec 11 2005 - 22:37:51 CST