>
> On Fri, Jun 20, 1997 at 02:31:02PM -0400, Bruce Momjian wrote:
>
> > Now I am confused. Does varchar() store only used bytes? Then the FAQ
> > is wrong. It says char() and varchar() always store maximum length.
>
> varchar() stores maximum length only (and only!) if length is
> specified. varchar(100) will always store 100 bytes, while
> varchar will store only entered bytes:
>
> create table tab (v varchar);
>
> This will work as text. But:
>
> create table tab (v varchar(100));
>
> will *always* store 100 characters. The only difference from
> char() - varchar() is not padded with spaces...
I feel better now.
- --
Bruce Momjian
maillist@candle.pha.pa.us
------------------------------
