Anthony Tuininga

One possible solution: add a `convert_nulls` parameter to `cursor.var()` which has a default value of `False`. When `True`, however, None would be passed through to the `outconverter` and `inconverter` functions....

To answer your first question: you can get the encoding from the connection. There is an attribute on connections called "encoding" which you would use for CLOBs and "nencoding" which...

Thanks for these comments.

I am able to replicate with the script you provided. It is not, in fact, intermittent, but very consistent. It depends on the data that is being supplied to the...

To provide a little more information: the issue has nothing to do with *insertng* the data, only with *fetching* it using the output type handler.

I already tried that...and I don't get any failures that way! I am using 21.3 database, however, so not sure if this is something that may have been fixed? I'll...

Ok. I tried with a 12.1 database. It works fine, there. I *did* need to add this code: ``` cursor.setinputsizes(y=cx_Oracle.DB_TYPE_NVARCHAR) ``` That's because that database is using a single-byte character...

I am able to replicate with 18c. I will look into that as well and get back to you!

@zzzeek, can you adjust your test case to add the following? ``` cursor.setinputsizes(y=cx_Oracle.DB_TYPE_NVARCHAR) ``` just prior to the execute that inserts the row into the database? That resolves the issue...

Replace the line in the output type handler that creates the variable with this one: ``` return cursor.var(cx_Oracle.DB_TYPE_NVARCHAR, 131072, cursor.arraysize) ``` That appears to resolve the issue. The size has...