Ok. It seems I get an error only on files over 1mb, and this is a timeout? "2006, MySQL server has gone away". I also had some cryptic error messages when trying to add a too large blob. The MySQLdb wait_timeout has to be set at creation of the connection?
In order to add a blob you have to do a MySQLdb.escape_string() on the field containing binary data. -Simen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: 10. august 2006 18:33 To: Dabo Users list Subject: Re: [dabo-users] Adding blobs On Aug 10, 2006, at 12:23 PM, Simen Haugen wrote: > Is there a way of adding blobs with dabo? > It breaks at cursors.py:273. AFAIK, it has never been tested. So my guess would be that no, it doesn't work now. > I get it to work if I assign the query to MySQLdb.Binary(query). Is > there another way of dealing with this? This also works on ordinary > types, but I assume there's a large performance issue involved (I > haven't checked) If you find out more information, we could possibly add that as an option: for MySQLdb first, and then to other backends. Instead of the default cursor, we could be sure to instantiate a binary-aware cursor. As long as it follows the dbapi, it should work with only minor tweaks on our end. -- Ed Leafe -- http://leafe.com -- http://dabodev.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
