Thanks Alvaro, Mine is: | Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad) ||/ Name Version Description +++-==============-==============-========================================== == ii libc6 2.3.2.ds1-22sa GNU C Library: Shared libraries and Timezone No packages found matching Desired=Unknown/Install/Remove/Purge/Hold. -----Mensagem original----- De: Alvaro Herrera [mailto:alvherre@xxxxxxxxxxxxxxxxx] Enviada em: sexta-feira, 18 de agosto de 2006 10:54 Para: Erika Terahata Torres Prada e Silva - MPS Cc: pgsql-admin@xxxxxxxxxxxxxx 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 > GABRIEL ALCIDES KLIM PERONDI > GABRIELA LETICIA BATISTA NUNES > GABRIEL ALEXANDRE DA SILVA MANICA > > The correct would be: > > GABRIEL ALCIDES KLIM PERONDI > GABRIEL ALEXANDRE DA SILVA MANICA > GABRIELA HELEDA DE SOUZA > GABRIELA JACOBY NOS > GABRIELA LETICIA BATISTA NUNES > > As I told you, with OS Windows, it works correctly... Strange. I'm using Debian unstable here and it works fine, i.e., just as you expect. This sounds like a glibc bug to me; one corrected after 3.1. (Is that Sarge? I don't know the version numbers.) What version of the libc6 package do you have installed? I have 2.3.6-18 here. $ LC_MESSAGES=C dpkg -l libc6 Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad) ||/ Name Version Description +++-=======================-=======================-======================== ====================================== ii libc6 2.3.6-18 GNU C Library: Shared libraries -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
