Re: max key length 500 in myisam index

2004-02-05 Thread Mikhail Entaltsev
Adam, > 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 > avo

Re: max key length 500 in myisam index

2004-02-03 Thread Victoria Reznichenko
Adam Hardy <[EMAIL PROTECTED]> wrote: > 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,

max key length 500 in myisam index

2004-02-02 Thread 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