(I am using mysql-5.0.15-win32) Why I am getting this error and is there any way I can fix it, or is it a bug? Between I don't get this error if I change the field size to 767 or below: drop table Address;
CREATE TABLE `Address` ( `RecId` CHAR(32) NOT NULL, `WebAddress` VARCHAR(1000), CONSTRAINT PKAddress PRIMARY KEY(RecId) ); CREATE INDEX AddressWebAddressWebAddress ON Address (WebAddress);