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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
