pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jerome Alet <alet@unice.fr>
To: Jan Wieck <JanWieck@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Storing image contents in TEXT fields
Date: Wed, 27 Jun 2001 19:48:17 +0200
Message-ID: <20010627194817.A527@nordine.ateur> (raw)
In-Reply-To: <200106271517.f5RFHSp18538@jupiter.us.greatbridge.com>
References: <20010627001110.A1279@nordine.ateur>
	<200106271517.f5RFHSp18538@jupiter.us.greatbridge.com>

On Wed, Jun 27, 2001 at 11:17:28AM -0400, Jan Wieck wrote:
> Jerome Alet wrote:
> > Hi,
> >
> > I wanted to know if it's possible to store an image content in a TEXT field,
> > or if another type is needed (in this case, then which one ?).
> >
> > I don't want to use BLOBs, because I modify an existing application
> > which also works with MySQL, and I can't update to postgresql-7.1.x
> > (I don't admin this server)
> >
> > in a TEXT field the image seems to be truncated at the first nul byte.
> 
>     To  have  the  highest  portability across ALL databases, you
>     might be best off by converting it to/from base64 or  similar
>     in  the  client application and store the string in a text or
>     varchar attribute.

I think that I'll modify the app anyway, since I fear to hit the 
tuple max size with some postgresql versions. I think it's better
to store images outside the database, but the original app developper 
didn't seem to think the same ;-)

bye, and thanks to all

Jerome Alet



view thread (5+ messages)  latest in thread

Message-ID: <20010627194817.A527@nordine.ateur>
Permalink:  ../20010627194817.A527@nordine.ateur/
Also on:    postgresql.org/message-id/20010627194817.A527@nordine.ateur

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: alet@unice.fr, JanWieck@yahoo.com
  Subject: Re: Storing image contents in TEXT fields
  In-Reply-To: <20010627194817.A527@nordine.ateur>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox