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