Re: Effect of VARCHAR length?

[Mike Rains]

> I'm just curious to know if the length of the indexes on a varchar
> column work in the same way or if they have a fixed lenght.
> anybody knows ?

I don't see how they could be fixed length, since VARCHAR itself is
not fixed-length. Ergo, it makes sense that the prefix limitation is
the upper prefix length limit.

Reference:
http://dev.mysql.com/doc/mysql/en/mysql-indexes.html
http://dev.mysql.com/doc/mysql/en/create-index.html