Re: Migration: Informix to PostgreSQL Case Study - Mailing list pgsql-advocacy

From Alvaro Herrera
Subject Re: Migration: Informix to PostgreSQL Case Study
Date
Msg-id 20050812133327.GA12367@alvh.no-ip.org
Whole thread Raw
In response to Re: Migration: Informix to PostgreSQL Case Study  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-advocacy
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)

pgsql-advocacy by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Migration: Informix to PostgreSQL Case Study
Next
From: "Andy Astor"
Date:
Subject: An Open Letter from EnterpriseDB