>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]