Re: Difference between varchar and text?

On 11/05/12 12:46 PM, Moshe Jacobson wrote:
> Is there any practical difference between defining a column as a
> varchar(n) vs. a varchar vs. a text field?

varchar(n) has a length constraint on it.  the other two don't.
otherwise all three are identical in implementation.

>
> 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. Is this correct?

no, unless you want to ensure the field will never exceed a specified
length.

> But more importantly, what's the practical difference between varchar
> with no limit and text?

none.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast