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? Mysql 4.1.1, RedHat 9 Thanks. Francis Mak