On 2012-11-05, Moshe Jacobson <moshe@neadwerx.com> wrote:
> --14dae93404f5f865d804cdc59353
> Content-Type: text/plain; charset=ISO-8859-1
>
> Is there any practical difference between defining a column as a
> varchar(n)vs. a varchar
> vs. a text field?
>
> I've always been under the impression that if I am wanting to index a
> varchar column, it is better to set a maximum length.
It doesn't really matter, the index itself will impose the limit
(unless you use a hash index where ther is no limit)
> But more importantly, what's the practical difference between varchar with
> no limit and text?
text is immeasurably faster.
> Thanks, and apologies if this is a FAQ...
--
⚂⚃ 100% natural
