Another thing i noticed, when creating a BLOBCol sqlobject makes a tinyblob col in mysql, when making normal, medium or large blobcol it creates a text, medium text and large text respectively, i went into the db and changed it blob cols manually but that didn't help.
Fabian -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rupert Redington Sent: 08 February 2007 13:47 To: [email protected] Subject: [TurboGears] Re: Getting images into and out of a database...retry Hi Fabian, I suspect I've been having a similar problem to you - do you get UnicodeDecodeErrors when trying to store the image data to your BLOBCol? It seems to me that SQLObject is trying to encode the whole query to unicode - which fails when the query contains a base64 string (which is what I get when I read() the file data presented to me by FieldStorageUploadConverter) This all works as I expect it to when using sqllite for storage, but fails when using MySql. I'll try to test with Postgres soon. Rupert --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
