PROTECTED]
Enviada em: sexta-feira, 18 de agosto de 2006 02:58
Para: pgsql-admin@postgresql.org
Cc: Alvaro Herrera; Erika Terahata Torres Prada e Silva - MPS
Assunto: Re: RES: RES: [ADMIN] Issue on Varchar Ordering
Alvaro Herrera wrote:
LC_COLLATE=pt_PT sort EOF
GABRIEL ALEXANDRE DA SILVA MANICA
Erika Terahata Torres Prada e Silva - MPS wrote:
OS Debian 3.1
Show lc_collate:
pt_BR.ISO-8859-1
It returns:
GABRIELA HELEDA DE SOUZA
GABRIELA JACOBY NOS
GABRIEL ALCIDES KLIM PERONDI
GABRIELA LETICIA BATISTA NUNES
GABRIEL ALEXANDRE DA SILVA MANICA
Terahata Torres Prada e Silva - MPS
Cc: pgsql-admin@postgresql.org
Assunto: Re: RES: [ADMIN] Issue on Varchar Ordering
Erika Terahata Torres Prada e Silva - MPS wrote:
OS Debian 3.1
Show lc_collate:
pt_BR.ISO-8859-1
It returns:
GABRIELA HELEDA DE SOUZA
GABRIELA JACOBY NOS
Erika Terahata Torres Prada e Silva - MPS wrote:
I'm having the following issue:
create table aluno (id serial, nome varchar(60));
rodrigo=# select * from aluno order by nome offset 35 limit 5;
id | nome
+---
36 | GABRIELA HELEDA DE SOUZA
PROTECTED]
Enviada em: quinta-feira, 17 de agosto de 2006 10:04
Para: pgsql-admin@postgresql.org
Cc: Erika Terahata Torres Prada e Silva - MPS
Assunto: Re: [ADMIN] Issue on Varchar Ordering
Erika Terahata Torres Prada e Silva - MPS wrote:
I'm having the following issue:
create table aluno (id serial
original-
De: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 17 de agosto de 2006 10:04
Para: pgsql-admin@postgresql.org
Cc: Erika Terahata Torres Prada e Silva - MPS
Assunto: Re: [ADMIN] Issue on Varchar Ordering
Erika Terahata Torres Prada e Silva - MPS wrote:
I'm
Erika Terahata Torres Prada e Silva - MPS wrote:
Peter,
Thanks for answering.
But it's not correct to my language pt_BR and it worked correctly with
PostgreSQL at Windows and FreeBSD. I have this problem only with Debian and
now I'm looking for some Debian related issue.
It's still
Erika Terahata Torres Prada e Silva - MPS wrote:
But it's not correct to my language pt_BR and it worked correctly
with PostgreSQL at Windows and FreeBSD. I have this problem only with
Debian and now I'm looking for some Debian related issue.
String ordering is determined by national and
: quinta-feira, 17 de agosto de 2006 11:53
Para: Erika Terahata Torres Prada e Silva - MPS
Cc: pgsql-admin@postgresql.org
Assunto: Re: RES: [ADMIN] Issue on Varchar Ordering
Erika Terahata Torres Prada e Silva - MPS wrote:
Peter,
Thanks for answering.
But it's not correct to my language pt_BR
Erika Terahata Torres Prada e Silva - MPS wrote:
Thanks everybody.
The correct order in Portuguese would return as brazilian telephone guide
order as below:
select * from aluno order by nome
id nome
38 GABRIEL ALCIDES KLIM PERONDI
40 GABRIEL
Alvaro Herrera wrote:
LC_COLLATE=pt_PT sort EOF
GABRIEL ALEXANDRE DA SILVA MANICA
GABRIELA JACOBY NOS
GABRIELA HELEDA DE SOUZA
GABRIELA LETICIA BATISTA NUNES
GABRIEL ALCIDES KLIM PERONDI
EOF
On my system it outputs the order you show above, which shows that my
locale is correctly
I´m with the
same problem at order by at version 8.0.3 and O.S. Debian.
I´ve tried
with locale C, UTF8, encoding LATIN1, UNICODE and it did't
work.
From: Rodrigo Hjort
rodrigo ( dot ) hjort ( at ) gmail ( dot ) com
To: pgsql-hackers ( at ) postgresql ( dot ) org
12 matches
Mail list logo