CHAR(N) storage requirement

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: CHAR(N) storage requirement
Date: 2004-01-11 15:52:17
Message-ID: 40017131.9040704@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it the 4+N (aka. same as VARCHAR(n)) or is it N? Sorry, it was 100%
not clear for me after reading the docs, though the docs imply the
first: "The storage requirement for data of these types is 4 bytes plus
the actual string, and in case of character plus the padding."

As a comparison, MySQL seems to do storage saving for fixed-length
character (it doesn't store the length of the string).

--
dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-01-11 15:56:16 Drawbacks of using BYTEA for PK?
Previous Message David Garamond 2004-01-11 14:53:09 Re: int8 version of NUMERIC?