Re: char o varchar

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 ()
One man's impedance mismatch is another man's layer of abstraction.
(Lincoln Yeoh)