[sqlalchemy] Re: Again MySQL/unicode - roundtrip failed

2006-12-15 Thread Stefan Meretz
On 2006-12-13 22:38, Shannon -jj Behrens wrote: > My memory is that MySQLdb recently changed a bunch of stuff and that > it was a simple logic bug. You mean, that just the entire logic is reversed? This would explain, why reading is working (from Mike's Mail): > def convert_result_value(sel

[sqlalchemy] Re: Again MySQL/unicode - roundtrip failed

2006-12-12 Thread Stefan Meretz
On 2006-12-12 22:31, Shannon -jj Behrens wrote: > > When I do it on pure MySQLdb, everything works fine. Not > > surprisingly, because I explicitly say: > > > > cursor.execute("update testtable set test=%s", s) > > > > having s as given above (only one row, no where-clause needed). > > Have you re

[sqlalchemy] Again MySQL/unicode - roundtrip failed

2006-12-12 Thread Stefan Meretz
Hi, using MySQL in an entirely utf8-environment I got the following: class Testtable(ActiveMapper): class mapping: pkey = column(Unicode(10), primary_key=True) test = column(Unicode(4)) sqlalchemy.dburi="mysql://test:[EMAIL PROTECTED]/testdb?use_unicode=1" MySQLdb.__version