Oracle and Unicode

[Former user]

Greetings,

I'm sorry to submit a ticket with only a question, but couldn't figure out where I could post it instead. Feel free to ignore it, if find my dumbness offensive. Anyways, I'm currently working on developing a data replication system that works with either postgres (psycopg2), oracle (cx_Oracle) or ms-sql (adodbapi), but stepped into a problem: cx_oracle doesn't seem to handle Unicode objects (NotSupported exception). Until now I didn't manage to get a satisfatory workaround this, and would like to know how do you handle the situation. In the meantime, I'll continue analysing your code searching for the answer. Thank you for your time, and once again my apologies for the inconvinience.

Best regards, Ricardo Nuno Almeida

[Mike Bayer]

use the Unicode sqlalchemy type or use the 'convert_unicode' flag on the create_engine call. see the SA docs for details on both.

the mailing list is being worked on...(supposedly).