Re: Unicode issues inserting data.

On Tue, 28 Sep 2004 11:29:02 +0100, "Harry" <not_at_home.com> wrote:

>"Andy Hassall" <andy_at_andyh.co.uk> wrote in message
>news:sm4hl0p2ecunmedbpjl87qahnjk293ek1q_at_4ax.com...
>> On Mon, 27 Sep 2004 21:20:00 +0100, "Harry" <not_at_home.com> wrote:
>>
>
>> >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)
>>
>The registry variable NS_LANG is:
>
>ENGLISH_UNITED KINGDOM.WE8MSWIN1252
 The character set part of NLS_LANG basically means "all character data I send is encoded in this character set, and I want to receive all data in this character set" (there's also the 'N' variants e.g. NVARCHAR2 which use the national character set settings instead).

 So if you try to send a 2-byte encoding of a UTF8 character with NLS_LANG set like this, you're really sending two WE8MSWIN1252 characters.

 Set that part to UTF8 if you want to send UTF8 data, or use the other method from your other followup to set the client-side character set.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool