Length for an index

[Former user]

In MySQL is it possible to set a length for an index. This is possible for normal keys and composite keys.

Maybe it is possible to create a MySQL-Specific Index Option to set the length for an Index.

Example:

Index('my_index', my_table.c.value, mysql_length=10)

Result:

KEY `my_index` (`value`(10))

This option is especially useful in case you want to set an index on the first some characters of a blob/text without length.

Current workaround: Create a DDL

[Mike Bayer]

absolutely. a patch + a unit test would speed this along, if possible - here's a patch for a similar feature against PG: http://www.sqlalchemy.org/trac/attachment/ticket/2290/postgresql_using.patch

[Former user]

Patch to support length on indexes for mysql

[Former user]

This is the patch including a unit test.

[Mike Bayer]

yes that looks great !! two great patches in a row! I'll try to get this committed later today.

[Former user]

Thank you for the fast responses ;)

[Mike Bayer]

a0cc36c23966bb2a5884e6760ea3efde44fc3518 thanks for the patch !

[Mike Bayer]

Removing milestone: 0.7.3 (automated comment)