Re: what characterset to use?

On Wed, 22 Aug 2007 06:08:34 -0700, Ben <balvey_at_comcast.net> wrote:

>> 1. Am I correct in thinking that if we use NLS_CHARACTERSET =
>> WE8MSWIN1252 and NLS_NCHAR_CHARACTERSET = AL16UTF16 we shouldn't have
>> any issues with losing multibyte characters?
>
>I need to clarify, we shouldn't have any issues storing multibyte
>data, as long as we use NVARCHAR data types for the data.
>

If you don't want issues you should use a multibyte characterset as *database* characterset.
>
>> 2. On my windows client I go to a command prompt and issue the
>> following c:\> echo %NLS_LANG%,
>> I get %NLS_LANG% returned back to me. I'm assuming that this means I
>> don't have the variable set. How does my client then treat the data
>> that I am getting from the database?
>
>By 'treat' I mean what character set does the client use.
>
>
>

Responded to this one earlier.

-- 

Sybrand Bakker
Senior Oracle DBA