Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA09574 for ; Thu, 27 May 1999 11:17:37 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id KAA06759; Thu, 27 May 1999 10:17:35 -0500 (CDT) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma006613; Thu, 27 May 99 10:17:16 -0500 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Thu, 27 May 1999 10:17:31 -0500 Message-ID: From: "Jackson, DeJuan" To: Chris Bitmead , pgsql-sql@postgreSQL.org Subject: RE: [SQL] VARCHAR(50), CHAR(50) or TEXT ? Date: Thu, 27 May 1999 10:17:30 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain 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) > > > ========================================================================== > =====