lsllcm wrote:
> 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
>
It's UTF, is it not?
Use lentghC, then.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Fri Dec 16 2005 - 03:53:28 CST
