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