Indexes are made of a "key" which isn't just strictly the bytes of the text
being stored. Certain characters can cause the key to bloat in the number of
bytes. I attended Dave Schneppers session on it since he was the original
developer for it. Some time ago he wrote a kit to allow you to write your
own collation drivers and perhaps accompanying it will be more information
to help you in this area.

I'm not sure where to find it but www.cfotogo.com or www.brookstone.com or
www.brookstonesystems.com might get you there. Just going from memory.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <rsaeger.edv@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, July 20, 2001 12:02 AM
Subject: Re: [IBO] Creating Database on the Fly Part Deux


> 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
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>