[cx-oracle-users] Problem with internal buffer sizes

[matilda m. <ma...@gr...>]

Hi all, hi Anthony,

I have the following problem:

The Oracle database I'm using has the internal encoding
WE8ISO8859P1. The frontend (shell, python) has the
default encoding UTF-8 (NLS_LANG=GERMAN_GERMANY.UTF8).
The Oracle client library is handling encoding convertion, BUT:
If I fetch a varchar2 (byte) column consisting of a character
that is encoded with two bytes in UTF-8, I get the following
error while fetching:

cx_Oracle.DatabaseError: column at array pos 0 fetched with error:
1406

I think it's a problem with internal buffers of the bind variables.

1) What can I do to get rid of that without changing NLS_LANG?
2) Is there or probably will there a way to transparently circumvent
this problem. (automatic claiming of bigger buffers).

Thanks in advance
Andreas Mock