Re: Store base64 in database. Use bytea or text? - Mailing list pgsql-general

On 1/25/2011 4:27 PM, Andre Lopes wrote:
> Hi,
>
> I need to put some images on Base64 in a PostgreSQL database. Wich
> type should I use and what is the difference between using bytea or
> text to store Base64?
>
> Best Regards,
>

If they are encoded in base64, use text.  Use bytea if you dont want to
encode them.

-Andy