| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Murilo Lobato <murilo(at)perfilweb(dot)com(dot)br> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #6244: Ordering Problem |
| Date: | 2011-10-07 15:41:30 |
| Message-ID: | CAHyXU0zn5JsJjMK4xmjjvV2KNipm5hURXP2j3EnCeJ_n+9VLSQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Oct 7, 2011 at 8:31 AM, Murilo Lobato <murilo(at)perfilweb(dot)com(dot)br> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6244
> Logged by: Murilo Lobato
> Email address: murilo(at)perfilweb(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2011-10-07 16:25:08 | Re: [v9.2] make_greater_string() does not return a string in some cases |
| Previous Message | Murilo Lobato | 2011-10-07 13:31:37 | BUG #6244: Ordering Problem |