Re: RES: Issue on Varchar Ordering

["Paul B. Anderson" <paul.a@xxxxxxxxxxxxxxxxx>]

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.



-----Mensagem original-----
De: Peter Eisentraut [mailto:peter_e@xxxxxxx] 
Enviada em: quinta-feira, 17 de agosto de 2006 10:04
Para: pgsql-admin@xxxxxxxxxxxxxx
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, nome varchar(60));

rodrigo=# select * from aluno order by nome offset 35 limit 5;
 id |               nome
----+-----------------------------------
 36 | GABRIELA HELEDA DE SOUZA
 37 | GABRIELA JACOBY NOS
 38 | GABRIEL ALCIDES KLIM PERONDI
 39 | GABRIELA LETICIA BATISTA NUNES
 40 | GABRIEL ALEXANDRE DA SILVA MANICA
(5 registros)

The problem is that records with id 38 and 40 might come before the
others. It seems that the spacing isn't considered on ordering.
    

That is, for practical purposes, correct.

May I suggest that you properly normalize your tables, by putting given 
name and family name into separate columns.