In response to Peter Geoghegan <peter.geoghega...@gmail.com>: > On 25 January 2011 22:27, Andre Lopes <lopes80an...@gmail.com> 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? > > I really don't think you want to do that. Base64 is used to make > binary data 7-bit safe for compatibility with legacy systems (i.e. to > embed arbitrary binary data within ASCII). Sometimes people escape > binary data as base64 to store it in their DB, but they typically > store it as bytea. Base64 probably isn't even a particularly good > choice for escaping binary, let alone storing it. > > You should just use a generic escaping function. libpq has > PQescapeByteaConn(), for example.
A warning: last I checked, PHP's pg_escape_bytea() was broken, so be cautious if you're using PHP. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
