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;

豐
榮
张三
暗

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