If you are on a version prior to 4.1.2 the max index size is 500 bytes {not sure why the error mentions 1024}
>From section 14.1 of documention The maximum key length is 1000 bytes (500 before MySQL 4.1.2). This can be changed by recompiling. For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used. -----Original Message----- From: javabuddy [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 12:30 PM To: mysql@lists.mysql.com Subject: Index - max key length is 1024 bytes I am trying to create an index with multiple fields. The sixe of each of the column is listed and thier sum is 560bytes. But when I try to create an index with the colums, it complains on the size exceeded 1024 bytes. Below is the query and the size of each.. create index selectTechnologyClubsThread_idx on content (club_id, date_update, subject, message_id, id, date_published, comment_count_d, display_usr_name_d, short_content) COLUMN_NAME TYPE SIZE club_id Bigint 8 date_update Bigint 8 Subject Varchar(120) 121 message_id varchar(120) 121 Id Bigint 8 date_published Datetime 8 comment_count_d Int 4 short_content Varchar(250) 251 display_usr_name_d Varchar(30) 31 TOTAL : 560 Any sort of help would be great.... - javabuddy ------------------------------------------------------------------------ ---------------------------- People are conversing... without posting their email or filling up their mail box. ~~1123867827435~~ roomity.com http://roomity.com/launch.jsp No sign up to read or search this Rich Internet App ------------------------------------------------------------------------ ---------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]