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 -> Re: Unicode issues inserting data.

Re: Unicode issues inserting data.

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Mon, 27 Sep 2004 23:24:05 +0100
Message-ID: <sm4hl0p2ecunmedbpjl87qahnjk293ek1q@4ax.com>


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 tool
Received on Mon Sep 27 2004 - 17:24:05 CDT

Original text of this message

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