| Subject | Re: [firebird-support] Collation Orders / Field-Size |
|---|---|
| Author | Lucas Franzen |
| Post date | 2004-01-30T15:05Z |
Elmar Haneke schrieb:
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
characters.
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).
Luc.
> Hi,It never could.
>
> I try to specify an collation order, when I select "PXW_INTL", an
> VARCHAR(100) can no longer be indexed.
> Using the default "WIN1252"Nothing.
> 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
characters.
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).
Luc.