Re: what characterset to use?

> 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.

> 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. Received on Wed Aug 22 2007 - 08:08:34 CDT