At 12:04 PM 8/07/2003 +0000, you wrote:

>unicode uses 3 chars per char

3 bytes per char

>and yes, the max size of an index is 255

It's actually about 253 bytes (less than 255, anyway).
The max size of an index in unicode_fss is therefore 84 characters.

heLen

> >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
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/