>
> > * allow varchar() to only store used bytes, not maximum
>
> Hmm. Some file managers might make use of the fact that a column is of
> fixed storage size, which I would think varchar() should be. Also, it
> would possibly allow rows to be updated in place with predictable
> performance. The text type (or varchar w/o maximum specified) are
> available for truely variable length fields. I'll bet that others DBs
> make these assumptions too...
Char() is now fixed, varchar() is not, hence the varchar name. text is
unchanged.
--
Bruce Momjian
maillist@candle.pha.pa.us