Re: BUG #6244: Ordering Problem

On Fri, Oct 7, 2011 at 8:31 AM, Murilo Lobato <murilo@perfilweb.com.br> wro=
te:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A06244
> Logged by: =A0 =A0 =A0 =A0 =A0Murilo Lobato
> Email address: =A0 =A0 =A0murilo@perfilweb.com.br
> PostgreSQL version: 9.0.3
> Operating system: =A0 Centos 5.5
> Description: =A0 =A0 =A0 =A0Ordering 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 bei=
ng
> computed, as follown:
>
> what is happening:
> =A01 - Lucia Amaral
> =A02 - Luci Martins
>
> What we expecting:
> =A01 - Luci Martins
> =A02 - 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