Error when adding index to 2 fields

[youradds]

Hi,

I'm trying to setup a new index in a table ... but I'm getting an error:

ALTER TABLE `Clients_Per_Destination` ADD INDEX `c_n_c_n` ( `continent_name_flat` , `country_name_flat` )

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes

At first I thought it was due to the name being too long (the index name), but I've shrunk it to only 7 charachters, and I still get the same error. I also checked the format of those 2 fields, and they are both CHAR(255) .. so I'm at a but of a loss as to where that error is coming from :/

Anyone got any ideas?

TIA

Andy

 

[feherke]

Hi

key length is 1000 bytes [gray](...)[/gray] they are both CHAR(255)

There can be difference between the byte and character count in case of charsets supporting multi-byte characters. ( See the descriptions of [tt]lentgh()[/tt] and [tt]char_length()[/tt] functions. )

Feherke.

http://free.rootshell.be/~feherke/

 

[youradds]

Ah ok - thanks for the reply

Cheers

Andy