Subject | Unique Index with Unicode_FSS |
---|---|
Author | Tomas |
Post date | 2003-07-08T11:59:05Z |
Hi,
Is there any restrictions on creating primary or unique indexes on
fields with character set UNICODE_FSS?
I try to create unique index on VCHAR(100) with UNICODE_FSS character
set and get message "Unsuccsessful metadata update. Key size too big for
index ...". If I use VCHAR(84) - everything is OK.
Does it mean that unique index can not be longer than 255 bytes?
Thanks in advance.
Tomas
[Non-text portions of this message have been removed]
Is there any restrictions on creating primary or unique indexes on
fields with character set UNICODE_FSS?
I try to create unique index on VCHAR(100) with UNICODE_FSS character
set and get message "Unsuccsessful metadata update. Key size too big for
index ...". If I use VCHAR(84) - everything is OK.
Does it mean that unique index can not be longer than 255 bytes?
Thanks in advance.
Tomas
[Non-text portions of this message have been removed]