Thread: RE: [SQL] VARCHAR(50), CHAR(50) or TEXT ?

RE: [SQL] VARCHAR(50), CHAR(50) or TEXT ?

From
"Jackson, DeJuan"
Date:
Use large object to deal with large objects.   lo_import, lo_export ...-DEJ

> Tuples have an 8k limit.
> 
> Doo Suk Yang wrote:
> > 
> > > > Almost none.  VARCHAR won't let you go beyond the stated maximum
> length,
> > > > whereas TEXT has no specific upper limit.  Otherwise they are stored
> >                     ~~~~~~~~~~~~~~~~~~~~~~~~~
> > > > in exactly the same way.  (At least in Postgres ... dunno about
> other
> > > > DBMSs.)
> > >
> > 
> > BTW there may be implicit limit. When I tried to insert sequence data an
> > error occured.
> > ERROR:  Tuple is too big: size 9520
> > Does that show the limit?
> > 
> > How can I deal with large object?
> > 
> >
> ==========================================================================
> =====
> > Science is the game we play with God to find out what his rules are.
> >
> --------------------------------------------------------------------------
> -----
> > Doo Suk Yang
> > Research Scientist                              Voice: 82-42-866-2222
> > LG Chemical Ltd. Research Park
> > Biotech Research Institute I                    FAX:   82-42-861-2566
> >
> --------------------------------------------------------------------------
> -----
> > A fool hath no delight in understanding, but that his heart may discover
> itself.
> > (Proverbs 18:2)
> >
> ==========================================================================
> =====