Unicode / cx_Oracle problem

Richard Schulman raschulmanxx at verizon.net
Fri Sep 8 18:01:14 EDT 2006


Sorry to be back at the goodly well so soon, but...

...when I execute the following -- variable mean_eng_txt being
utf-16LE and its datatype nvarchar2(79) in Oracle:

 cursor.execute("""INSERT INTO mean (mean_id,mean_eng_txt)
     VALUES (:id,:mean)""",id=id,mean=mean)

I not surprisingly get this error message:

 "cx_Oracle.NotSupportedError: Variable_TypeByValue(): unhandled data
type unicode"

But when I try putting a codecs.BOM_UTF16_LE in various plausible
places, I just end up generating different errors.

Recommendations, please?

TIA,
Richard Schulman
(Remove xx for email reply)



More information about the Python-list mailing list