ok I see now. So, the field itself is VARCHAR(255) and only the collation has been changed. By default the full width of the column is used for indexing, unless MySQL version is below 5.0-something. Do you think we still need it?