Tom Lane escribió:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > The assumption here is that all locales will choose the same sort order as
> > long as they're dealing only with the core 26 letters.
>
> Nope. For instance, on HPUX I get this sort order in English:
[...]
> because the Spanish treat LL as a single collating element. (Actually,
> my very-rusty recollection is that they sort LL the same as one L, which
> would mean that HPUX's behavior is not quite right here: it's treating
> LL as one symbol that sorts after L. Linux seems to have no clue that
> LL is special at all though...)
HPUX's behaviour is broken, because in spanish LL (as well as CH)
stopped being a special symbol some five years ago (it used to be
treated as one collating element sorted after "L", so HPUX behaviour was
right then).
> > We could also cut down the number of affected tests by making the
> > select_implicit and select_having not use mixed-case strings in the test
> > tables. Then we have only char, varchar, and select_views left.
Maybe it would be better to prepare various results, one for each of a
subset of the locales supported (C, en_EN, some other "western" and
maybe a couple multibyte?). That way at least you make sure the C
library is working as expected.
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"No deja de ser humillante para una persona de ingenio saber
que no hay tonto que no le pueda enseñar algo." (Jean B. Say)
