>
> On Wed, 7 Jan 1998, Bruce Momjian wrote:
>
> > In my experience, char() is full size as defined by create, and
> > varchar() is the the size of the actual data in the field, like text,
> > but with a pre-defined limit.
>
> Can you remind me what the difference is between text and varchar? Why
> would you use varchar over text?
Only because SQL people are used to varchar, and not text, and sometimes
people want to have a maximum size if they are displaying this data in a
form that is only of limited size.
--
Bruce Momjian
maillist@candle.pha.pa.us