Re: [cx-oracle-users] Can't have access to a corrupted VARCHAR2.

[Stéphane J. <ste...@ju...>]

Hi,

Thanks a lot you for your help.

With Python 2, I have no problem. I set encoding to 'WINDOW-1252' and my
output type handler decodes using errosr='ignore'.

The result of
select * from nls_database_parameters where parameter in
('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
is :
NLS_NCHAR_CHARACTERSET    AL16UTF16
NLS_CHARACTERSET          WE8MSWIN1252

In Python 3, I always use :
*cx_Oracle.Connection(user, password, dsn, threaded, encoding =
'WINDOWS-1252',nencoding = "UTF-8")*
and my python 3 crashes. Data are not corrupted by a Python program but by
an old power builder program we can't correct.

I tried setting NLS_LANG with the same result.

I will log a request to add a mean to specify the errors parameter in the
decode at least for Python 3.

Best wishes.

Stéphane