We do all of our encryption in the middleware:
1) translate our data which requires encryption into an XML string
2) compress + encrypt, yielding byte [].
3) Store byte [] as a bytea column.
The resulting byte arrays are relatively small in our case (1 -> 3K),
so bytea has seemed to suit us just fine.
----
James Robinson
Socialserve.com