Encryption/Compression problem using a RDBMS

Aahz Maruch aahz at panix.com
Mon May 21 12:14:32 EDT 2001

In article <HfaO6.1777$556.149792 at juliett.dax.net>,
Thomas Weholt <thomas at cintra.no> wrote:
>I want to store encrypted and/or compressed XML in a text-field in a RDBMS,
>currently PostgreSQL. But it crashes in inserts due to the fact that the
>process of compressing or encrypting gives a lot of "unprintable" characters
>in the result data to be stored.
>Does anybody know any way of doing this? Can a algoritm return data that's
>friendly in the sense that it doesn't contain special characters that may
>cause trouble?
>Any hints are welcome, even if applicable to PostgreSQL only.

I'm assuming you meant "even if not".  IME, most databases have a
special field for storing binary info, and they often have a special API
for getting data in and out of those fields.  Try looking for "BLOb" or
"binary" in the PostGreSQL docs.
                      --- Aahz  <*>  (Copyright 2001 by aahz at pobox.com)

Androgynous poly kinky vanilla queer het Pythonista   http://www.rahul.net/aahz/
Hugs and backrubs -- I break Rule 6

Cole's Law: thinly sliced cabbage

More information about the Python-list mailing list