On 10/16/07, yann FORTIER <[EMAIL PROTECTED]> wrote:
>
> Thanks Jim
> It's wonderful
> All is working.................;


Fabulous, that is good news.

Can you explain me how to inscribe on the mail list on this site


To make the mailing list show the messages on the site, all you
have to do is CC the mailing list address in your messages.

I'll repost the answer I gave you so that future readers can find it.

-----------------------------------

Here is a sample script that I have tested on Windows XP running
Python 2.4.4 using cx_Oracle 4.3.2 connecting a Unicode installation
of Oracle 10G R2:

import os

# Set the environ before importing
os.environ["NLS_LANG"] = ".AL32UTF8"
import cx_Oracle

cxn = cx_Oracle.connect("scott/tiger")

curs = cxn.cursor()

# This is just a sample to get some unicode data
curs.execute(r"SELECT COMPOSE(UNISTR('a\0303')) FROM dual")

row = curs.fetchone()

# You actually get back encoded data in an 8-bit string
raw_col = row[0]
print "Raw string: class=%s, len=%d" % (raw_col.__class__, len(raw_col))

# decode it into something python can use
col = raw_col.decode(cxn.encoding)

import unicodedata
print "Unicode string: class=%s, len=%d, name=%s" % (col.__class__,
len(col), unicodedata.name(col,'.'))
_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig

Reply via email to