>>>Hi,
>>>
>>>Is this a known issue (not mentioned in the docs AFAICS):
>>>
>>>I'm issuing the following:
>>>
>>>ALTER TABLE Printers ALTER COLUMN DeviceName C(250)
>>>
>>>There's a regular index on this field (which initially has a length of 40)
>>>
>>>I get an 'Invalid key length' message box but the field length is altered and *the index is dropped* !
>>>
>>>Surely it should completely reject the change ?
>>
>>Probably a bug. You may want drop the index yourself.
>
>Can't drop the index - existing code would blow up. I'm just going to content myself with keeping the field length below the 240 limit ......
I meant before changing the length, change the length, then restore the index (within the allowed length).
If it's not broken, fix it until it is.
My Blog