Re: Store base64 in database. Use bytea or text?

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: Store base64 in database. Use bytea or text?
Date: 2011-01-25 22:33:44
Message-ID: 4D3F4FC8.3040809@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2011-01-25 22:39:35 Re: Store base64 in database. Use bytea or text?
Previous Message Bill Moran 2011-01-25 22:31:33 Re: Store base64 in database. Use bytea or text?