spanish locale question

From: jbiskofski <jbiskofski(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: spanish locale question
Date: 2012-04-18 19:40:46
Message-ID: CAHpPzY6imyhsAbpFdfRPoqFYB_GvYyojqAc2W+Nhg7NqxA5mGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

I have a lc_collate problem. Im in Mexico and I need the following three
lastnames to be sorted this way :

álvarez ( accent on first a )
chavez
cota

Using the default locale on my mac ( en_US ) I end up with :

chavez
cota
álvarez

So I switched to es_ES.ISO8859-15 and that gives me :

álvarez
cota
chavez

... There was a time when the "Real Academia Española" considered "CH",
"LL" and "SH" as letters. They changed that in 1994 :

I*n 1994, the RAE ruled that the Spanish consonants **"CH" (ché) and "LL" (
elle) would hence be alphabetized under "C" and under "L", respectively,
and not as separate, discrete letters, as in the past. The RAE eliminated
monosyllabic accented vowels where the accent did not serve in changing the
word's meaning, examples include: "dio" ("gave"), "vio" ("saw"), both had
an acutely-accented vowel "ó"; yet the monosyllabic word "sé" ("I know",
the first person, singular, present of "saber", "to know"; and the singular
imperative of "ser", "to be") retains its acutely-accented vowel in order
to differentiate it from the reflexive pronoun "se".*
*
*
*http://en.wikipedia.org/wiki/Real_Academia_Espa%C3%B1ola*
*
*
*
*
I think thats where the problem comes from.

Anyway, any hints/clues/suicide-method-suggestions would be greatly
appreciated!

Thanks!

- Jose Biskofski
www.algebraix.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jose Hales-Garcia 2012-04-18 19:45:02 Two instances show same databases
Previous Message Raghavendra 2012-04-18 19:31:17 Re: - tablespace and directory