Encryption/Compression problem using a RDBMS

[Thomas Weholt]

Hi,

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.

Thanks.

Thomas