Hi All, Setting the value of a BLOB type in MySQL crashes with the following: Traceback (most recent call last): File "/jeeves_home/knightly/knightly/Build.py", line 173, in ? sys.exit(main(sys.argv)) File "/jeeves_home/knightly/knightly/Build.py", line 167, in main targetResults.log = made.GetLog() File "<string>", line 1, in <lambda> File "/jeeves_home/knightly/knightly/lib/sqlobject/main.py", line 1061, in _SO_setValue self._connection._SO_update( File "/jeeves_home/knightly/knightly/lib/sqlobject/dbconnection.py", line 511, in _SO_update self.query("UPDATE %s SET %s WHERE %s = (%s)" % File "/jeeves_home/knightly/knightly/lib/sqlobject/dbconnection.py", line 342, in query return self._runWithConnection(self._query, s) File "/jeeves_home/knightly/knightly/lib/sqlobject/dbconnection.py", line 255, in _runWithConnection val = meth(conn, *args) File "/jeeves_home/knightly/knightly/lib/sqlobject/dbconnection.py", line 339, in _query self._executeRetry(conn, conn.cursor(), s) File "/jeeves_home/knightly/knightly/lib/sqlobject/mysql/mysqlconnection.py", line 113, in _executeRetry query = unicode(query, self.encoding) UnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position 1180: ordinal not in range(128)
Should the converter take care of properly escaping the python string to be included in the BLOB field? Or should I be doing this and how should I be doing this? Thanks, Brian ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss