[SQLObject] Error writing binary data to a blob
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Aaron R. <aar...@mo...> - 2009-07-23 05:52:45
|
Hi All, I'm new to SQLObject, but have picked through the documentation as much as possible and done numerous searches and am still at a loss... I'm wanting to write some binary data to the database - specifically the data is produced by something like: array.array('H',[1,2,3]).tostring() and the database is Postgres 8.3 with a sqlobject.BLOBCol(default=None) column. Currently when I try this I receive this error: DataError: invalid byte sequence for encoding "UTF8": 0x83 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". I ran into a vaguely similar post, and the suggestion was to useUnicodeCol(), which I have tried and received the same result. Basically the main focus here is on keeping the storage size in the DB as low as possible, as we want to store many groups of numbers (all below 65536), and there is no need (or desire) to store them in individual columns. Thanks in advance, -Aaron. |