Search Postgresql Archives

Problem with sorting on PostgreSQL 9.0.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



I'm having a problem with the sort of names with accents 
In the version of postgres 8.4.3, I run the following command: 

SELECT name FROM person ORDER BY name 

And I have the following result: 

                       
name 
-------------------------------------------------- 
 
Abel Clara Valentin 
 
Abel Felipe Mundel 
 
Abel Lopes de Amorin 
 
Abel Rodriguez 
 
... 
 
Eric Alves de Lima 
 
Erico Borinelli 
 
Eric Brizola 
 
Eric Correa 
 
Eric Eichenberger 
 
Erico Eichstadt 
 
... 
 
Zulmira Fatima Ribeiro Albrecht 
 
Zulma Siewe 
 
Zulmira Dutra da Rocha 
(26,445 rows) 


The bank orders usually, he puts his name with an accent in the right order, or 
That is, he does not think the accent to order, from what I saw. 

In the PG version 9.0.3 
I run the same command and got the following result: 

                       
name 
-------------------------------------------------- 
 
Abel Clara Valentin 
 
Abel Felipe Mundel 
 
Abel Lopes de Amorin 
 
Abel Rodriguez 
 
... 
 
Eric Alves de Lima 
 
Erico Borinelli 
 
Eric Correa 
 
Eric Eichenberger 
 
Erico Eichstadt 
 
Erico Eischstaedt 
 
... 
 
Zulma Siewe 
 
Zulmira Fatima Ribeiro Albrecht 
 
Zulmira Dutra da Rocha 
 
<C3> <89> Rich Brizola 
(26,445 rows) 


The "<C3> <89> Brizola rich" equals "Eric Brizola" the outcome of PG 8.4.3. 

If someone can help me I appreciate it. 

Hug.

[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux