Postgres Pro
Downloads
Home   >   mailing lists

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

From Dmitriy Igrishin
Subject Re: Store base64 in database. Use bytea or text?
Date
Msg-id AANLkTi=0mgmuG41bVHKBWaN1suNUWqENHrdRKqRGYrZ_@mail.gmail.com
Whole thread Raw
In response to Re: Store base64 in database. Use bytea or text?  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Tree view


2011/1/26 Andy Colson <andy@squeakycode.net>
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.
Or *store* in bytea by using decode() function and retrieve
in base64 by using encode() function.
http://www.postgresql.org/docs/9.0/static/functions-string.html

-Andy


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
// Dmitriy.


pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Store base64 in database. Use bytea or text?
Next
From: Peter Geoghegan
Date:
Subject: Re: Store base64 in database. Use bytea or text?