Maybe this is more an issue for the cx-oracle mailing list? (Google for it.)
I'd be interested in hearing the answer too. On 5/5/05, Mark Bennett <[EMAIL PROTECTED]> wrote: > > Good morning Folks, > > I've looked around on Google for this a few times and really haven't come up > with anything definitive. > > I'm trying to update values in Oracle with the .execute() method from > cx_Oracle. > > If I create a Python unicode string object and try to pass it in, Python > complains that .execute() expects a None or string. > > If I convert the unicode string to a regular "byte" string beforehand with > .encode() and utf-8, Python accepts it but when we pull the data back from > Oracle we get garbage characters. > > Some details: > > Python 2.4 with a recent version of cx_Oracle (don't have the exact version > here) Running on Solaris. > > And from our DBA: > > Oracle 9 on Solaris. The database was told to support Unicode. > > The character fields are currently VARCHAR2; he believes he's seen > conflicting evidence online about whether or not that is supposed to work. > We've also talked about using NVARCHAR2 and NCLOB. > > We have not set any environment variables on Solaris. > > Thanks in advance, > Mark > > _______________________________________________ > DB-SIG maillist - DB-SIG@python.org > http://mail.python.org/mailman/listinfo/db-sig > > > -- --Guido van Rossum (home page: http://www.python.org/~guido/) _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
