Thank you, this worked!
On 12/6/05, Dittmar, Daniel <[EMAIL PROTECTED]> wrote: > > >I've tried parameter substitution as well, but it does not > >work for me. When > >I use session.sqlX ('INSERT INTO TMP(a) VALUES (?)', ['ā']), > >garbage gets > >inserted. Namely, I get "Ä" value in the TMP table. > >Is there anything else that I should configure, maybe some session > >parameter? > > You have to make sure that you pass an actual Unicode string as parameter. > Even when setting the encoding in the source, simple quoted strings do not > become Unicode strings. u'ā' creates an Unicode string, but make sure that > the string contains the expected characters. My own experiments using > encoded Python source and string literals are still inconclusive. > > Daniel Dittmar > > -- > Daniel Dittmar > SAP Labs Berlin > [EMAIL PROTECTED] >