Re: Can't have access to a corrupted VARCHAR2.

--===============0245390750662711196==
Content-Type: multipart/alternative; boundary="001a113cc6c2650dd80567d4c2b9"

--001a113cc6c2650dd80567d4c2b9
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=3D'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 =3D
'WINDOWS-1252',nencoding =3D "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=C3=A9phane

--001a113cc6c2650dd80567d4c2b9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div class=3D"gmail_extra">Hi,<br><br></div><div class=
=3D"gmail_extra">Thanks a lot you for your help.<br><br></div><div class=3D=
"gmail_extra">With Python 2, I have no problem. I set encoding to &#39;WIND=
OW-1252&#39; and my output type handler decodes using errosr=3D&#39;ignore&=
#39;.<br></div><div class=3D"gmail_extra"><br></div><div class=3D"gmail_ext=
ra">The result of<br><span style=3D"color:rgb(0,0,255)"><span style=3D"font=
-family:monospace,monospace">select * from nls_database_parameters where pa=
rameter in (&#39;NLS_CHARACTERSET&#39;, &#39;NLS_NCHAR_CHARACTERSET&#39;);<=
/span></span><br>is :<br><span style=3D"color:rgb(0,0,255)"><span style=3D"=
font-family:monospace,monospace">NLS_NCHAR_CHARACTERSET=C2=A0=C2=A0=C2=A0 A=
L16UTF16<br>NLS_CHARACTERSET=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 WE8MSWIN1252</span></span><br><br></div><div class=3D"gmail_extra=
">In Python 3, I always use :<br><b>cx_Oracle.Connection(user, password, ds=
n, threaded, encoding =3D &#39;WINDOWS-1252&#39;,nencoding =3D &quot;UTF-8&=
quot;)</b><br></div><div class=3D"gmail_extra">and my python 3 crashes. Dat=
a are not corrupted by a Python program but by an old power builder program=
 we can&#39;t correct.<br><br></div><div class=3D"gmail_extra">I tried sett=
ing NLS_LANG with the same result.<br></div><div class=3D"gmail_extra"><br>=
</div><div class=3D"gmail_extra">I will log a request to add a mean to spec=
ify the errors parameter in the decode at least for Python 3.<br></div><div=
 class=3D"gmail_extra"><br clear=3D"all"></div><div class=3D"gmail_extra"><=
div><div class=3D"gmail_signature">Best wishes.<br><br>St=C3=A9phane<br></d=
iv></div>
<br><div class=3D"gmail_quote"><br></div><br></div></div>

--001a113cc6c2650dd80567d4c2b9--


--===============0245390750662711196==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
--===============0245390750662711196==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

--===============0245390750662711196==--