On Wednesday 18 February 2004 06:44, Dana Hudes wrote:
>
> At least with base64 I have ample libraries and can convert my data
> before sending to sql or after receiving from sql. It becomes my
> application's issue. Mind, this bloats the data considerably.
> escape is less bloat but I have to recreate the encode/decode in my app,
> so far as I see.
Less bloat than you might expect - large values are TOASTed and compressed.
I'm guessing a lot of your redundancy will be eliminated.
Having said that, bytea's purpose in life is to store your binary data.
--
Richard Huxton
Archonet Ltd