MySQL Document Says. Maximum key length is 500 bytes by default (can be changed by recompiling). In cases of keys longer than 250 bytes, a bigger key block size than the default of 1024 bytes is used for this key.
how can i recompile to enlarge maximum key length??? i want to create table like this... create table test( field1 text not null,primary key (field1(1024)) ) <- it dosen't work that is, i want primary key length to be more than 1024... \ I can enlarge key field size to 255 while no recompiling. . create table test( field1 text not null,primary key (field1(255)) ) <- it works According to mysql document, I can enlarge key field length by recompliling. how can I do??? Please. answer me ASAP Thanks --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php