Subject Re: [firebird-support] Unique Index with Unicode_FSS
Author Daniel Rail

At July 8, 2003, 08:59, Tomas wrote:

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

Any indexes can't be longer than 255(or is it 252) bytes. There has
been discussions to change this, hopefully in FB 2.0.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (