pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jan Wieck <JanWieck@Yahoo.com>
To: Jerome Alet <alet@unice.fr>
Cc: Jan Wieck <JanWieck@Yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Storing image contents in TEXT fields
Date: Wed, 27 Jun 2001 15:10:57 -0400 (EDT)
Message-ID: <200106271910.f5RJAvY19366@jupiter.us.greatbridge.com> (raw)
In-Reply-To: <20010627194817.A527@nordine.ateur>

Jerome Alet wrote:
> 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 ;-)

    There  is  no  "tuple  max  size"  any  more since PostgreSQL
    version 7.1.  If you get it through the parser, planner,  and
    executor  (depends  on virtual memory), it'll make it down to
    the disk. So if you don't intend  to  store  tenth-mega-sized
    multi-frame video clips, you should be fine.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




view thread (5+ messages)

Message-ID: <200106271910.f5RJAvY19366@jupiter.us.greatbridge.com>
Permalink:  ../200106271910.f5RJAvY19366@jupiter.us.greatbridge.com/
Also on:    postgresql.org/message-id/200106271910.f5RJAvY19366@jupiter.us.greatbridge.com

 · 

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: JanWieck@Yahoo.com, alet@unice.fr
  Subject: Re: Storing image contents in TEXT fields
  In-Reply-To: <200106271910.f5RJAvY19366@jupiter.us.greatbridge.com>

* 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