[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: BUG in spanish (es_ES) locale date
From: |
Keld Jørn Simonsen |
Subject: |
Re: BUG in spanish (es_ES) locale date |
Date: |
Mon, 19 Jan 2004 18:38:30 +0100 |
User-agent: |
Mutt/1.4.1i |
On Mon, Jan 19, 2004 at 01:11:36PM +0100, German Gomez Garcia wrote:
> Hello,
>
> We were having problems with PostgresSQL ordering of strings, and
> tracing it back we have found that there is a bug in the spanish (es_ES)
> locale data.
>
> Extracted from localedata/locales/es_ES
>
> % Ordering algorithm:
> % 1. Spaces and hyphen (but not soft
> % hyphen) before punctuation
> % characters, punctuation characters
> % before numbers,
> % numbers before letters.
>
>
> % 2. Letters with diacritical marks are
>
>
> % members of equivalence classes
> % 3. A distinction is made with regards
> % to case as noted below.
> % 4. Special characters are ignored
> % when comparing letters, but then
> % they are considered
> % 5. The alphabets are sorted in order
> % of first appearance in ISO 10646:
> % Latin, Greek, Cyrillic, etc.
>
> But when in fact spaces are not considered where ordering, it seems that
> they are just ignored. Although the collation scheme is clearly about
> spaces < punct. < number < letters. The attached program is an example
> of what I mean, it uses strcoll that is supposed to use locales when
> sorting. I've compiled it both in Debian Woody, Debian Sid, Redhat 7.2
> and Redhat 9.0, the locales are correctly generated but it isn't
> working.
>
> I have doublechecked it in Microsoft Visual C++ 6.0 with the same
> program, and it is working correctly there.
I did not find an attached program, nor do I know what you expected
for output. Could you provide me/us with these data?
best regards
keld