Hi,

At June 10, 2003, 12:03, janaleman wrote:

> If I used UNICODE_FSS I seam to be unable to use primary keys that
> consist of more than one column and are longer than 60 characters
> (sometimes it lets me go to 100, other times to 79 as well,
> apparantly randomly). According to the release notes the length
> shouldnt be a problem:

> The new limits for indexes are:

> Page Size Single column Double Column
> ------------------------------------------------
> 1 k 60 48
> 2 k 124 99
> 4 k 252 203
> 8 k 508 406
> 16 k 1020 816

> Or am I missing something?

UNICODE_FSS characters are 3 bytes long, and WIN1252 characters are 1
byte long. So, basically divide the value above by 3 minus a few
bytes. The maximum that I can hit is a length of 80 characters(240
bytes), if I create an index on that field.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)