On 04/10/2019 18:58, Mark W. Farnham wrote:
ah, SQLAlchemy, so python, so cx_oracle....
in theory that makes sense but dumping out the values passed into bind doesn't show any out of the ordinary characters. when we substitute the binds for literals with literal_binds, those literals all look like standard ascii values.I imagine that Oracle knows the CSID of your binds - after all, it prints the CSID for binds in a 10046 trace, and also, in the ORA-12704 error line(s). I rather suspect that it is simply saying "are these two data items of a compatible characterset? No? Ok, ORA-12704 and dump out the details"