Thanks for all the reply's. I will be using PHP for now to insert data.
So I shouldn't use base64 to store images or any other kind of files. I'm new to storing files in the database. This will be my first experience. I will research about PQescapeByteaConn. Thanks for the help. Best Regards, On Tue, Jan 25, 2011 at 10:46 PM, Bill Moran <wmo...@potentialtech.com> wrote: > 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
