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
http://www.msn.co.uk/messenger