Thomas,

I try to avoid char/varchar fields in primary keys as I can (comming
from xBase <g>).
But weeks ago I got error saying something like "index too long..."
trying index on varchar(40), varchar(40). I haven't found time to
play with this, so I "cut" it in varchar(30), varchar(30) and it was
OK. But it will come ... therefore my question.

I've read http://www.mers.com/IBINDEXLENGHT.HTML, but I don't
understand it 100%. Is there a clear answer for dummies like "max
lenght is 80 bytes"?

Regards
Richard

--- In IBObjects@y..., "Thomas Steinmaurer" <thomas.steinmaurer@a...>
wrote:

> Richard,
>
> In my database using WIN1252 or ISO8859_1 with a collation

different to the

> default I cannot create varchar primary key columns greater than

84. Take a

> look on http://www.mers.com/IBINDEXLENGHT.HTML.
>
> Also a comparison of WIN1252 and ISO8859_1 could be useful
> http://www.equitania.de/interbase/
>
> Thomas