RES: RES: [ADMIN] Issue on Varchar Ordering

2006-08-18 Thread Erika Terahata Torres Prada e Silva - MPS
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: > GABRIEL

Re: RES: [ADMIN] Issue on Varchar Ordering

2006-08-18 Thread Alvaro Herrera
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 SILV

RES: [ADMIN] Issue on Varchar Ordering

2006-08-18 Thread Erika Terahata Torres Prada e Silva - MPS
lto:[EMAIL 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 ALE

Re: RES: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Peter Eisentraut
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 corre

Re: RES: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Alvaro Herrera
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 GABRI

RES: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Erika Terahata Torres Prada e Silva - MPS
da em: 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 n

Re: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Peter Eisentraut
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 int

Re: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Alvaro Herrera
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 stil

Re: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Paul B. Anderson
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

RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Erika Terahata Torres Prada e Silva - MPS
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 PROTEC