Hello,
I'm using the following for a multiple-row insert:

vals = ', '.join(["(%s,%d)" % (web.db.sqlquote(o), fldid) for o in
opts])
web.query('INSERT INTO t(val, fldid) VALUES %s' % vals, _test=True)

I run into a problem when using accented characters like
"Schrödinger":

INSERT INTO t(val, fldid) VALUES ('Foo',202), ('Schr\xf6dinger',202)

Leading in MySQL to Schrxf6dinger

I must be missing out something obvious...

Thank you

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to