Subject Re: [firebird-support] Collation Orders / Field-Size
Author Lucas Franzen
Elmar Haneke schrieb:

> Hi,
> I try to specify an collation order, when I select "PXW_INTL", an
> VARCHAR(100) can no longer be indexed.

It never could.

> Using the default "WIN1252"
> Collation everything is ok.
> The same holds for ISO8859_1 and "DE_DE" collation.
> What can be done to solve this problem?

The maximum length for an indexed field is somewhat about 250. If you
use a certain collation (like the PXW_INTL in your case) it will need
3byte per character, so your maximum length for the field is about 80

As a workaround you can use a "shadow column" which you can index and
just store the first 80 characters (tip: store the values rigth away in
uppercase, so you can search case insensitive).