Re: [GENERAL] spanish locale question

Thank you Laurenz for your answer. I think I understand the meaning of ORDER BY my problem is the understanding of COLLATE functionality. I thought that if I collate in es.PE (Spanish) the o has the exact value of ó so if I INSERT INTO pru VALUES (8, 'leo','zara', 'juan'); How can I obtain

Re: [GENERAL] spanish locale question

Tulio wrote: Let me expand the collate situation. I´m from Perú and I have turned everything in postgresql.conf as 'es_PE.UTF-8' even the default_text_search_config = 'pg_catalog.spanish'. Even my Ubuntu 12.04 works in English I have es_PE locale too. if I do SELECT * FROM pru order by

Re: [GENERAL] spanish locale question

On Fri, May 4, 2012 at 1:22 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote: But would you really order 'leon', 'mendoza', 'juan' before 'leo', 'zara', 'juan'? No, I guess that Tulio would not do that, because (usually) 'leo' goes before 'leon'. What Tulio is saying is that 'leon' and 'león'

Re: [GENERAL] spanish locale question

Al Eridani al.erid...@gmail.com writes: What Tulio is saying is that 'leon' and 'león' are the same thing from the point of view of sorting in Spanish, but his PostgreSQL seems to think that 'leon' goes before 'león'. Postgres never considers that two distinct strings are equal. If the locale

Re: [GENERAL] spanish locale question

On 05/04/2012 07:31 PM, Tom Lane wrote: Al Eridanial.erid...@gmail.com writes: What Tulio is saying is that 'leon' and 'león' are the same thing from the point of view of sorting in Spanish, but his PostgreSQL seems to think that 'leon' goes before 'león'. Postgres never considers that two

Re: [GENERAL] spanish locale question

Hi there, Let me expand the collate situation. I´m from Perú and I have turned everything in postgresql.conf as 'es_PE.UTF-8' even the default_text_search_config = 'pg_catalog.spanish'. Even my Ubuntu 12.04 works in English I have es_PE locale too. In Spanish vowels as u is equal as ú or even ü.

Re: [GENERAL] spanish locale question

jbiskofski wrote: 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

Re: [GENERAL] spanish locale question

Laurenz, thank you so much for your help. I had a hard time getting the es_MX locale installed on my freebsd system, but once I did it worked perfectly. Thanks for your help again. - Jose On Thu, Apr 19, 2012 at 2:30 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote: jbiskofski wrote: I have a

[GENERAL] spanish locale question

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

[GENERAL] spanish

Please, exists postgres forum in spanish? Thanks Gustavo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] spanish

On Thu, Dec 4, 2008 at 4:44 PM, Gustavo Rosso [EMAIL PROTECTED] wrote: Please, exists postgres forum in spanish? http://archives.postgresql.org/pgsql-es-ayuda/ -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] spanish

On Thu, 2008-12-04 at 13:44 -0300, Gustavo Rosso wrote: Please, exists postgres forum in spanish? http://archives.postgresql.org/pgsql-es-ayuda/ Thanks Gustavo -- PostgreSQL Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL

Re: [GENERAL] spanish

Gustavo Rosso wrote: Please, exists postgres forum in spanish? Thanks Gustavo aqui se habla español : http://archives.postgresql.org/pgsql-es-ayuda/ Saludos .. Leonel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: