Inform: not handle case Error : BLOB/TEXT column {{columnname}} used in key specification without a key length

[baszealot13]

for ex: this command below is solution after diff. ALTER TABLE table_name ADD INDEX matchID USING BTREE (column_text); but i get error "BLOB/TEXT column {{columnname}} used in key specification without a key length" because that column defined "TEXT" type.

must be like command below ALTER TABLE table_name ADD INDEX matchID USING BTREE (column_text(20));

How should I do?, please suggest.

Thanks