Re: [cx-oracle-users] maintaining multiple connections with different encodings

[Doug H. <djh...@te...>]

On 2011-05-09 13:28, Dana Pieluszczak wrote:
> <snip>
> The table below is defined as (NLS_LENGTH_SEMANTICS IS 'BYTE' for both
> databases):
>
> CREATE TABLE test (str VARCHAR2(30 BYTE));
>
> <snip>
What are the values of NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET from
the sys.nls_database_parameters view? Mine are AL32UTF8 and AL16UTF16
respectively.

It may be illuminating to use this query:

select str, dump(str) from test;

to see what is actually stored in the table. This is what I get:
dätä    Typ=1 Len=6: 100,195,164,116,195,164

-- 
Doug Henderson, Calgary, Alberta, Canada