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.