On Fri, Aug 12, 2005 at 08:22:39AM -0400, Merlin Moncure wrote:
> One small correction: the PostgreSQL char(n) type takes n bytes, where n
> is the maximum size of the string. Varchar takes m + 4 for each row,
> where m is the actual string length (space delimited).
Not quite true -- char(n) also takes n+4, but only in single byte
encodings. It can take more -- AFAIU it can be up to n*4 + 4 (worst
case) in UTF8.
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Et put se mouve" (Galileo Galilei)