Re: Index key prefix behaviour in MyISAM

[Hassan Bahrami]

yes, we have to do that at some point,
but the same question will remain unanswered only with different numbers for InnoDB.
InnoDB limit for a key prefix length is 3072 bytes,

so what will happen if we use a string column longer than 768 mb4-characters (3072 bytes) for a unique key?

Since we have to use the first 768 characters, although the column itself is unique, is the unique index throwing a duplication error in case there is another value with the same first 768 characters?