mysql> alter table snapshots modify doc varchar(996);
Query OK, 25116 rows affected (0.58 sec)
Records: 25116  Duplicates: 0  Warnings: 0

mysql> alter table snapshots modify doc varchar(997);
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes