[MySQL] Support for indexes with column of types BLOB, TEXT

[Former user]

Columns with BLOB or TEXT type must have a prefix length for the creation of an index (including unique indexes). source : http://dev.mysql.com/doc/refman/5.0/en/column-indexes.html

[Mike Bayer]

Correct me if I'm wrong but this is the purpose of the index_length parameter: http://www.sqlalchemy.org/docs/dialects/mysql.html#index-length

looking at that implementation I'd wonder if it needs to be modified to support multiple columns/lengths, though in practice I've never heard of putting indexes on TEXT or BLOB in any case so this is another one of those weird MySQL use cases.

will close this as worksforme if no other comments.