max key length 500 in myisam index

[Adam Hardy]

I've got to create a table that has the following:

CREATE TABLE access (
  query VARCHAR(255) NOT NULL,
  INDEX (query)
);
and mysql is telling that the max bytes allowed is 500 for key length. 
The docs say I can change this by recompiling, which I would like to 
avoid having to do. Is there any way around this to get a 255 character 
length field with index?

This is going to store weblog entries, so it's going to be a huge table. 
Is there a different table type / column type / index type I could use 
to achieve what I need?

thanks in advance
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]