Subject Re: [firebird-support] Re: ISO-8859-2 problems
Author Peter Jacobi
Hi Gabor,

I CC may message to the list again, as it then can be found by
everyone searching the archives for similiar problems.

> I use COLLATE PXW_HUN(DC) creating index on a VARCHAR(90) fails with:
[...]
> key size too big for index IDX."

The sorting mechanism implemented by all the language specific collations
is somewhat complicated. Ask or search the archives if you are interested in
the details.

The negative side effect of this, is that the index size has to be larger
than
8bit/character, even for 8bit character sets.

The current implementation is not that optimized and claims whopping
24bit/character, which is quite a burden. So indexing stops at about 80
chars.

If you don't need the Hungarian sort order, and only want correct
uppercasing,
declare the column without COLLATE clause and give the COLLATE clause only
when using the UPPER function:
UPPER(mycol COLLATE CS_CZ)

If you really want the Hungarian sort order and 80 chars is not enough for
you,
what about being a beta tester for a new implemention?

Regards,
Peter Jacobi


--
COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test
--------------------------------------------------
1. GMX TopMail - Platz 1 und Testsieger!
2. GMX ProMail - Platz 2 und Preis-Qualit├Ątssieger!
3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post