Re: char o varchar - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: char o varchar
Date
Msg-id 20030917150857.GF2636@dcc.uchile.cl
Whole thread Raw
In response to Re: char o varchar  (Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de>)
List pgsql-general
On Wed, Sep 17, 2003 at 09:11:54AM +0200, Andreas Fromm wrote:
> As of my knowlege, varchar as the choice when you have varying lenght
> strings, because only the real string lenght is stored in the db, while
> char is usefull when most of your records ar exactly the stringlenght
> defined by the column, because no overhead is to be kept for storing the
> actual stringlenght.

No, the overhead is present for char(n) as well, because it stores the
length in _bytes_ while the "n" is the length in characters; they could
be different.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
One man's impedance mismatch is another man's layer of abstraction.
(Lincoln Yeoh)

pgsql-general by date:

Previous
From: Network Administrator
Date:
Subject: Re: Database Recovery Procedures
Next
From: Tom Lane
Date:
Subject: Re: State of Beta 2