Re: text vs varchar(n)

On 17.02.02 21:52 -0800(+0000), Richard Emberson wrote:
> Which is faster read and write, a table with text or varchar types:
>
> ...
>
> Why would one every use varchar(n) instead of text (aside from non-sql
> standard)?
>

Varchar(n) and text have the same performance. The difference is that
varchars are silently cut if they are longer than the limit specified.
In most cases you want to stick with text.

- Einar Karttunen