Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Unicode issues inserting data.
Hi,
I'm having problems inserting unicode values into my DB. I'm using OCCI on windows and have a string downloaded in UTF-8 format thus
£322
which is
0xc200a300330032003200
I copy this to a CString which converts it to
0xc2a3333232
I hive off the currency
0xc2a3
and insert it through a char program variable into a varchar field.
It isnt converted to unicode it is stored as two separate characters c2 and a3.
What am I doing wrong?
Thanks
My database (10g) is set up with
SQL> select * from nls_database_parameters 2 where parameter like '%CHARACTERSET';
PARAMETER VALUE ------------------------------ --------------- NLS_CHARACTERSET WE8MSWIN1252 NLS_NCHAR_CHARACTERSET AL16UTF16Received on Mon Sep 27 2004 - 15:20:00 CDT
![]() |
![]() |