Re: VARCHAR vs TEXT

On Wed, 10 Oct 2001, Aasmund Midttun Godal wrote:

> I am sure this question has been answered in some form or another
> before, but I can't really find anything on exactly this issue.
> 
> Are there any differences between varchar and text other than
> 
> 1. varchar has limited size
> 2. varchar is SQL 92 text is not?
> 
> Especially regarding performance.
> 
> Or am I correct to assume that if you need a place to store some text,
> and you are not sure how much (like an email address or a name) you
> are best off using text?

Pretty much yes.  text and varchar are pretty equivalent other than
the fact that varchar specifies a maximum size.