Re: Store base64 in database. Use bytea or text?
От
Dmitriy Igrishin
Тема
Re: Store base64 in database. Use bytea or text?
Дата
Msg-id
AANLkTi=0mgmuG41bVHKBWaN1suNUWqENHrdRKqRGYrZ_@mail.gmail.com
Ответ на
Re: Store base64 in database. Use bytea or text? (Andy Colson)
Список
Дерево обсуждения
Re: Store base64 in database. Use bytea or text? Jasen Betts <jasen@xnet.co.nz>
2011/1/26 Andy Colson <andy@squeakycode.net>
On 1/25/2011 4:27 PM, Andre Lopes wrote:If they are encoded in base64, use text. Use bytea if you dont want to encode them.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,
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
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 по дате отправления
