[DB-SIG] probleme with cx_oracle

Jim Patterson unixdude at gmail.com
Sat Oct 6 17:27:55 CEST 2007


On 10/4/07, yann FORTIER <fortier at atmoauvergne.asso.fr> wrote:

> But I have a problem between what I  have in my base (with sqlplus) and
> what I recover with python. I don't have any accent. I'm french so it's
> important for us. Can you help us.

The key to extracting non-ASCII data is to set your NLS_LANG environment
before you import cx_oracle.  I would suggest using AL32UTF8 as the Oracle
language.  That will get you a nice modern UTF-8 that you can decode into
a unicode string in python.

You may also want to ask cx_oracle questions on the cx_oracle list.  It will
get you faster response.

Jim P.


More information about the DB-SIG mailing list