RE: index prob

[Max]

Hi all,
i've a prob with index table ....

 a my table had a lot of varchar(250) with simple index and fulltext index
 .... now, for a particular request, I've to modify some of these varchar
field on text type ...
the problem is that now I cannot add an index to these modified fields ...

 I mean:
 alter table Mytable modify field_1 text not null; > ok
 alter table Mytable add index(field1) > ERROR 1170: BLOB column 'field1'
 used in key specification without a key length

 Are there any workaround or a solution to solve my prob?

 many thanks in advance
 max