Re: index prob

[Benjamin Pflugmann]

Hi.

On Thu, Aug 02, 2001 at 05:49:12PM +0200, max@stripped wrote:
[...]
>  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 ...
> 
>  I mean:
>  alter table Mytable add index(field1) > ERROR 1170: BLOB column 'field1'
>  used in key specification without a key length

As the error message tells, you have to specify a length for the
index, because it would make no sense (or at least be very
problematic) to index fields with abitrary lengths.

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

You need something like

ALTER TABLE Mytable ADD INDEX(field1(100))

Bye,

	Benjamin.