CHAR(N) storage requirement - Mailing list pgsql-general

From David Garamond
Subject CHAR(N) storage requirement
Date
Msg-id 40017131.9040704@zara.6.isreserved.com
Whole thread Raw
Responses Re: CHAR(N) storage requirement
List 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

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: int8 version of NUMERIC?
Next
From: David Garamond
Date:
Subject: Drawbacks of using BYTEA for PK?