Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UTF-8 question

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US