Re: [cx-oracle-users] Unicode support

[Michael S. <ms...@co...>]

Anthony Tuininga schrieb:
> Hi,
> 
> select * from nls_database_parameters where instr(parameter,
> 'CHARACTERSET') != 0;
> 
> For example, with the Windows instant client:
> 
> Oracle Instant client version 10.2.0.3
> connection.encoding = "WINDOWS-1252"
> connection.nencoding = "WINDOWS-1252"
> 
> PARAMETER                      VALUE
> ------------------------------ ----------------------------------------
> NLS_NCHAR_CHARACTERSET         AL16UTF16
> NLS_CHARACTERSET               WE8MSWIN1252
> 
Another thing that might be interesting is the value for
NLS_LENGTH_SEMANTICS, it defaults to Bytes. Wouldn't be surprised if it was
set to chars (which is more useful usually, unless you need to really
allocate buffers in C).

Michael


-- 
Michael Schlenker
Software Engineer

CONTACT Software GmbH           Tel.:   +49 (421) 20153-80
Wiener Straße 1-3               Fax:    +49 (421) 20153-41
28359 Bremen
http://www.contact.de/          E-Mail: ms...@co...

Sitz der Gesellschaft: Bremen
Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe
Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215