List:General Discussion« Previous MessageNext Message »
From:Mike Thompson Date:March 6 2001 6:51pm
Subject:key lengths
View as plain text  
How is key length for a table defined?  It seems that the default is 255
bytes, but in the online docs it mentions 500 byte keys.  I happen to
have some very long case sensitive strings that I need to use as keys,
but mysql complains when I try to create a table as such

CREATE TABLE foo(
	id INT NOT NULL AUTO_INCREMENT,
	name BLOB NOT NULL,
	PRIMARY KEY(id),
	UNIQUE(name)
);

Any thoughts?
	--m
Thread
key lengthsMike Thompson7 Mar
  • Re: key lengthsPat Sherrill7 Mar
  • Re: key lengthsMike Thompson7 Mar
    • Re: key lengthsJeremy D. Zawodny10 Mar
Re: key lengthsAU)8 Mar