On Fri, Oct 7, 2011 at 8:31 AM, Murilo Lobato <mur...@perfilweb.com.br> wrote: > > The following bug has been logged online: > > Bug reference: 6244 > Logged by: Murilo Lobato > Email address: mur...@perfilweb.com.br > PostgreSQL version: 9.0.3 > Operating system: Centos 5.5 > Description: Ordering Problem > Details: > > We have a clients table, and when we run a select on the table ordering by > name we get unexpected results. The whitespaces on the string are not being > computed, as follown: > > what is happening: > 1 - Lucia Amaral > 2 - Luci Martins > > What we expecting: > 1 - Luci Martins > 2 - Lucia Amaral > > Resuming, the whitespace is being ignored during the order.
problems like this are usually encoding/locale related. what's database encoding, and what's database lc_collate? merlin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
