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: 16 Dec 2005 18:01:01 -0800
Message-ID: <1134784861.835020.222590@g47g2000cwa.googlegroups.com>


SQL> select * from test;

C1





张三

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

LENGTHC(C1) LENGTH(C1) LENGTHB(C1) DUMP
----------- ---------- -----------


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

          2                 2                    2            Typ=1
Len=2 CharacterSet=AL32UTF8: b0,b5

The upper is the results, Both the first row and second row only has one chinese font char. But the function lengthc and length result is different. The function lengthb return 2 bytes, Can any one explain it?

Thanks in advance. Received on Fri Dec 16 2005 - 20:01:01 CST

Original text of this message

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