[cx-oracle-users] Antw: Bad conversion of a unicode value?

[matilda m. <ma...@gr...>]

>>> Michael Schlenker <ms...@co...> 26.11.2007 18:24 >>>
>
>I created a Table with sqlplus with some unicode characters in it:
>
>CREATE TABLE nls_testing ( unicp NVARCHAR(10));
>INSERT INTO nls_testing (nchar(8365)); -- euro symbol uses 2 utf-8 bytes
>INSERT INTO nls_testing (nchar(9305)); -- some cjk idogram uses 3 utf-8 =
bytes
>COMMIT;

Hi Michael,

I just wanted to reproduce your problem, but:
1) CREATE TABLE nls_testing ( unicp NVARCHAR(10));
doesn't work.

2) a) INSERT INTO nls_testing (nchar(8365))
   b) INSERT INTO nls_testing (nchar(9305))
are syntactically wrong.

Decimal 8365 =3D Hex 20AD  and NOT 20AC
Decimal 9305 =3D Hex 2459  and NOT 2456


Can you check this, so that we can have a look at this?

Best regards
Andreas Mock