Re: [HACKERS] varchar/char size
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: scrappy@hub.org (The Hermit Hacker)
Cc: hackers@postgreSQL.org
Date: 1998-01-07T23:04:08Z
Lists: pgsql-hackers
> > 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