Re: [sqlalchemy] Encoding issue with SqlAlchemy + cxOracle

2010-11-18 Thread Guilherme Menezes
An update: It seems that cx_Oracle always sends data in UTF-16 if WITH_UNICODE is unset and unicode() objects are passed. http://sourceforge.net/mailarchive/message.php?msg_name=AANLkTinTVdfPCn15HgXL6zo7cvRdSoE1t0_Z4eqXTGmQ%40mail.gmail.com Regards, Guilherme. On Wed, Nov 17, 2010 at 2:16 PM,

Re: [sqlalchemy] Encoding issue with SqlAlchemy + cxOracle

2010-11-18 Thread Michael Bayer
SQLAlchemy can do the encoding for you as Anthony suggests, in this case if you use the Unicode() type with the flag convert_unicode='force'. Unfortunately the 'force' value isn't accepted at the create_engine() level (thought it was, apparently not).Its likely that WITH_UNICODE is the

[sqlalchemy] Encoding issue with SqlAlchemy + cxOracle

2010-11-17 Thread Guilherme Menezes
Hi, I am having an encoding issue using Python 2.6.2, SqlAlchemy 0.6.5 and cxOracle 5.0.4 to access an Oracle 11g database. I am using the NLS_LANG=.AL32UTF8 enviroment variable. My table in Oracle is correctly configured to accept Unicode. First, I compiled cxOracle without the WITH_UNICODE

Re: [sqlalchemy] Encoding issue with SqlAlchemy + cxOracle

2010-11-17 Thread Michael Bayer
On Nov 17, 2010, at 10:26 AM, Guilherme Menezes wrote: Hi, I am having an encoding issue using Python 2.6.2, SqlAlchemy 0.6.5 and cxOracle 5.0.4 to access an Oracle 11g database. I am using the NLS_LANG=.AL32UTF8 enviroment variable. My table in Oracle is correctly configured to accept

Re: [sqlalchemy] Encoding issue with SqlAlchemy + cxOracle

2010-11-17 Thread Guilherme Menezes
Thank you. I will report the problem to the cx_Oracle list and see what they have to say. Regards, Guilherme. On Wed, Nov 17, 2010 at 2:16 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Nov 17, 2010, at 10:26 AM, Guilherme Menezes wrote: Hi, I am having an encoding issue using