Unicode / cx_Oracle problem

Diez B. Roggisch deets at nospam.web.de
Sat Sep 9 05:38:24 EDT 2006


Richard Schulman schrieb:
> 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.

Show us the alleged plausible places, and the different errors. 
Otherwise it's crystal ball time again.

Diez



More information about the Python-list mailing list