Re: cx_Oracle and UTF8

2006-02-27 Thread Harald Armin Massa
Gerhard, thanks, that import os os.environ["NLS_LANG"] = "German_Germany.UTF8" import cx_Oracle con = cx_Oracle.connect("me/[EMAIL PROTECTED]") really helped. At least now the query returns something encoded differently. I dared not to believe that there is no "direct encoding change api" withou

Re: cx_Oracle and UTF8

2006-02-23 Thread Gerhard Häring
Harald Armin Massa wrote: > Dietz, > > thank you for your answer. > >>It's called NLS (national language support), >>and it is like a locale-setting in python/C. I'm too lazy to google right > > Sad thing: I allready googled that and had to learn: you CAN definitely > change some parameters, tha

Re: cx_Oracle and UTF8

2006-02-23 Thread Harald Armin Massa
Dietz, thank you for your answer. > It's called NLS (national language support), >and it is like a locale-setting in python/C. I'm too lazy to google right Sad thing: I allready googled that and had to learn: you CAN definitely change some parameters, that is sort order and language for error me

Re: cx_Oracle and UTF8

2006-02-23 Thread Diez B. Roggisch
Harald Armin Massa wrote: > Hello, > > I am looking for a method to convince cx_Oracle and oracle to encode > it's replies in UTF8. > > For the moment I have to... > > cn=cx_Oracle.connect("user","password", "database") > cs=cn.Cursor() > > cs.execute("select column1, column2, column3 from ta

cx_Oracle and UTF8

2006-02-22 Thread Harald Armin Massa
Hello, I am looking for a method to convince cx_Oracle and oracle to encode it's replies in UTF8. For the moment I have to... cn=cx_Oracle.connect("user","password", "database") cs=cn.Cursor() cs.execute("select column1, column2, column3 from table") for row in cs.fetchall(): t=[] for i