Skip site navigation (1) Skip section navigation (2)

Re: BUG #6056: sorting issues

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: Mike Hepworth <michael(dot)w(dot)hepworth(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6056: sorting issues
Date: 2011-06-14 06:44:35
Message-ID: BANLkTikakdSQTZx5cXApzoyOyZ414bSD5Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Jun 14, 2011 at 06:52, Mike Hepworth
<michael(dot)w(dot)hepworth(at)gmail(dot)com> wrote:
> Bug reference:      6056
> Logged by:          Mike Hepworth
> Email address:      michael(dot)w(dot)hepworth(at)gmail(dot)com
> PostgreSQL version: 8.4
> Operating system:   Ubuntu 10.4
> Description:        sorting issues
> Details:
>
> Have database that is utf-8 encoding so that I can support both english,
> french, and spanish.  Having problems with the ordering of data.
>
> I execute the following sql statment:
>
> select * from (values('HALL, ANDY'),('HALLBERG, FRANK'),('HALLDEN,
> DOUGLAS'),('HALL, DOUGLAS') ) x ORDER BY 1;
>
> and get the following results
>
> HALL, ANDY
> HALLBERG, FRANK
> HALLDEN, DOUGLAS
> HALL, DOUGLAS

What locale did you use? Sort order depends on not only
encoding but also collation.  Please check "SHOW lc_collate".
Your locale seems to just ignore symbol characters.
I have an expected result at least in C locale.

-- 
Itagaki Takahiro

In response to

Responses

pgsql-bugs by date

Next:From: hubert depesz lubaczewskiDate: 2011-06-14 11:14:15
Subject: Re: BUG #6056: sorting issues
Previous:From: Mike HepworthDate: 2011-06-13 21:52:06
Subject: BUG #6056: sorting issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group