We do all of our encryption in the middleware:
1) translate our data which requires encryption into an XML string2) 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