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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])