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

> -----Original Message-----
> From: rsaeger.edv@... [mailto:rsaeger.edv@...]
> Sent: Friday, July 20, 2001 8:38 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Creating Database on the Fly Part Deux
>
>
> --- In IBObjects@y..., Lucas Franzen <luc@r...> wrote:
> > You shoulkd think about using domains and adding the collation
> order to
> > it!
> > (but be aware that your maximum index length is just around one
> third of
> > the original (sth. like 84 instead of 252 then).
>
> What does it mean? The maximum index lenght WITH collation is less
> then WITHOUT collation?
> What is the maximum with collation exactly (or where to find this)?
>
> Richard
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>