Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Unicode issues inserting data.

Unicode issues inserting data.

From: Harry <not_at_home.com>
Date: Mon, 27 Sep 2004 21:20:00 +0100
Message-ID: <415875f0$0$20250$cc9e4d1f@news-text.dial.pipex.com>


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         AL16UTF16
Received on Mon Sep 27 2004 - 15:20:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US