Hi, > I have a problem when creating a table: > > > CREATE TABLE test ( > test_key varchar(255) NOT NULL default '', > test_value text NOT NULL, > PRIMARY KEY (test_key) ) TYPE=MYISAM; > > It then report error: > > mySQL Error: Specified key was too long. Max key length is 500 > > Why the varchar exceeded 500? > I have a "set-variable = default-character-set=utf8" in my.cnf, maybe > this is the cause of error? > And is there way to increase this 500 value? Or I must use InnoDB then?
Apparently, the "500" number is "bytes". Assuming UTF8 takes at least two bytes/character, then yes, your VARCHAR(255) takes up more than 500 bytes. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]