Re: UTF-8 question

"lsllcm" <lsllcm_at_gmail.com> a écrit dans le message de news: 1134362271.148194.43060_at_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
|

Why not posting select length(c1), lengthb(c1), dump(c1,1016) from test;

Then we can see which one is which one.

Regards
Michel Cadot Received on Sun Dec 11 2005 - 23:52:09 CST