[SQLObject] SQLite fails for binaries

[Joshua R. <Jos...@mi...>]

In an attempt to store binary files in a database, I tried using the
previously suggested method of base64 encoding them. Whereas this method
works fine with PostgreSQL, it fails with SQLite. The string retrieved
from the database is completely garbled from the (encoded) string entered
into the database. I also tried using hexadecimal encoding with the same
result. I have no idea what's causing this; is there anything I can do to
work around this problem? In this instance I wish to avoid using a full
RDBMS, and I was really hoping to be able to store some images in the
database (both those for the same reason: at least for now I want all the
data to reside in one file).  I'm using python 2.3 and had this result
with both the 0.4 and CVS versions of SQLObject.

Ah, also, (I would respond to the proper message about this, but I wasn't
subscribed when it was posted), concerning Firebird, there is a pdf at
http://www.ibphoenix.com/downloads/qsg.pdf that seems to cover all the
basics of creating databases, etc. (it's linked to via a small image to
the left of the front page; it's not linked to under documentation or
anything reasonable like that....)

Joshua Rothenberg