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
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.
-Mensagem original-
De: Peter Eisentraut [mailto:[EMAIL
I just experienced this. I changed the collating sequence to POSIX
and sorting worked as I had expected.
To change the collating sequence you will have to backup the database,
issue initdb with the --lc-collate=POSIX and then restore the data. In
my case, the encoding is still UTF8.
Paul
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
10 matches
Mail list logo