Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Unicode issues inserting data.
On Mon, 27 Sep 2004 21:20:00 +0100, "Harry" <not_at_home.com> wrote:
>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
What's NLS_LANG on the client set to?
(environment variable or registry setting as appropriate)
-- Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk> <http://www.andyhsoftware.co.uk/space> Space: disk usage analysis toolReceived on Mon Sep 27 2004 - 17:24:05 CDT
![]() |
![]() |