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