1
Vote

MySQL Table "Type" unique index length to large for UTF8 encoding.

description

Due to a bug/"feature" in MySQL currently all versions the max size for a unique index is 1000 bytes. (UTF8 encoding uses 3 bytes per char, therefore max size is 333 chars).
So unfortunately on the table "TYPE" the index "TYPE_UQ01" has a length of 384 chars which is invalid.
 
,TYPE_FULL_NAME VARCHAR(128) NOT NULL
,ASSEMBLY_FULL_NAME VARCHAR(256) NOT NULL
 
The only current solution would be to create a regular index out of it and enforce the uniqueness in the app logic.

comments