Subject Re: [firebird-support] Unique Index with Unicode_FSS
Author Nick Upson
unicode uses 3 chars per char and yes, the max size of an index is 255

>From: "Tomas" <Tomas@...>

> 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?

Use MSN Messenger to send music and pics to your friends