Hi, Thanks, but I get the same exception. It seems that the only role of use_unicode is to force StringCol's to be UnicodeCol's. My columns are already UnicodeCol's.
Nadav On 7/10/06, Ivan Horvath <[EMAIL PROTECTED]> wrote: > Dear Nadav, > > try using the connection string with use_unicode parameter > e.g. > connString = "mysql://root:[EMAIL PROTECTED]/test?use_unicode=1" > __connection__ = connectionForURI(connString) > > > Saturday, July 8, 2006, 12:54:35 PM, you wrote: > > NS> Hi, > > NS> I am using SQLObject-0.8dev_r1814, MySQLdb 1.2.1_p2 and MySQL 5.0.22 > NS> on Arch Linux. > NS> I am using fields of type UnicodeCol. When I try to insert such object > NS> to the database I get > NS> an exception which originates in MySQLdb: > > NS> File > NS> > "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/mysql/mysqlconnection.py", > NS> line 66, in _executeRetry > NS> return cursor.execute(query) > NS> File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line > NS> 146, in execute > NS> query = query.encode(charset) > NS> UnicodeDecodeError: 'ascii' codec can't decode byte 0xd7 in position > NS> 196: ordinal not in range(128) > > NS> I tried to pass the data both as unicode strings and as normal strings > NS> with utf8 encoding. > > NS> It seems like SQLObject is sending the query to MySQLdb as a normal > NS> string, encoded in utf8. But, MySQLdb excepts it to be a unicode > NS> string, because lines 145-156 in cursors.py are: > > NS> charset = db.character_set_name() > NS> query = query.encode(charset) > > NS> Also, it turns out that the value of charset is 'latin1'. I am not > NS> sure why it is so, but I could force it to be 'utf8' if I changed the > NS> connect() call in makeConnection() method of mysqlconnection.py to > NS> have a keyword argument charset='utf8'. > NS> Of course it does not help, since SQLObject already sends an encoded > string. > > NS> Any Ideas? > > NS> Thanks, > NS> Nadav > > NS> Using Tomcat but need to do more? Need to support web services, security? > NS> Get stuff done quickly with pre-integrated technology to make your job > easier > NS> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > NS> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > NS> _______________________________________________ > NS> sqlobject-discuss mailing list > NS> sqlobject-discuss@lists.sourceforge.net > NS> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > > > > -- > Best regards, > Ivan Horvath > Chief Programmer > > Alcatel ISD > PMS 2000 Product Team > > H-1116, Budapest > Kondorfa u. 10. > Tel.: +36 1 209 9546 > Fax.: +36 1 209 9599 > Mobil: +36 30 257 0235 > VOIP: +49 511 676 478010 > mailto:[EMAIL PROTECTED] > > Anyone who has never made a mistake has never tried anything new. > > /Albert Einstein/ > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sqlobject-discuss mailing list > sqlobject-discuss@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
