> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
