I'm trying to create a table that contains a field for websites using a
VARCHAR(500). Furthermore, I would like to define this field as
UNIQUE. This by itself is not a problem; mysql will let me do this.
The problem comes when I decided I would also like this field to permit
fast lookups by creating an index on this field.
Because the field is so big, I can only index on some initial subset of
the field, which is fine, like an INDEX website_name(100) or something.
However, at this point, it seems that mysql will no longer let ...