Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0ODR2000140 for ; Wed, 24 Jan 2001 08:27:02 -0500 (EST) (envelope-from pgsql-docs-owner@postgresql.org) Received: from router.skin.dhs.org (cr285016-a.slnt1.on.wave.home.com [24.112.212.40]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0N2pj097951 for ; Mon, 22 Jan 2001 21:51:46 -0500 (EST) (envelope-from skin@skin.dhs.org) Received: from MARS (mars.skinz [10.10.50.3]) by router.skin.dhs.org (8.9.3/8.8.7) with SMTP id XAA19785 for ; Mon, 22 Jan 2001 23:12:33 -0500 Message-ID: <001e01c084e8$69015cf0$03320a0a@skinz> From: "Paul Skinner" To: Subject: Text Type Date: Mon, 22 Jan 2001 21:58:47 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001B_01C084BE.7EB38200" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-Archive-Number: 200101/92 X-Sequence-Number: 227 This is a multi-part message in MIME format. ------=_NextPart_000_001B_01C084BE.7EB38200 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Character Types SQL defines two primary character types: character and character varying. P= ostgres supports these types, in addition to the more general text type, wh= ich unlike character varying does not require an explicit declared upper li= mit on the size of the field.=20 Table 3-4. Postgres Character Types Character Type Storage Recommendation Description=20 character(n), char(n) (4+n) bytes SQL-compatible Fixed-length blank p= added=20 character varying(n), varchar(n) (4+n) bytes SQL-compatible Variable-= length with limit=20 text (4+n) bytes Most flexible Variable unlimited length=20 ----------------------- Text type is not unlimited but rather limited by tuple size of 8140 bytes. Paul ------=_NextPart_000_001B_01C084BE.7EB38200 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Character Types

SQL defines two primary character types: character and character varying. Postgres supports these types, in addition to th= e more=20 general text type, which unlike character varying does not require an explicit declared= upper=20 limit on the size of the field.

Table 3-4. Postgres Character Types<= /B>

Character Type Storage Recommendation Description
character(n), char(n) (4+n) bytes SQL-compatib= le Fixed-length blank padded
character varying(n), varchar(n) (4+n) bytes SQL-compatib= le Variable-length with limit
text (4+n) bytes Most flexible Variable unlimited=20 length
 
 
 
-----------------------
 
Text type is not unlimited but rather limited by tuple s= ize of=20 8140 bytes.
 
Paul
------=_NextPart_000_001B_01C084BE.7EB38200--