On Tue, Jun 14, 2011 at 06:52, Mike Hepworth
<michael.w.hepworth@gmail.com> wrote:
> Bug reference: =C2=A0 =C2=A0 =C2=A06056
> Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Mike Hepworth
> Email address: =C2=A0 =C2=A0 =C2=A0michael.w.hepworth@gmail.com
> PostgreSQL version: 8.4
> Operating system: =C2=A0 Ubuntu 10.4
> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0sorting issues
> Details:
>
> Have database that is utf-8 encoding so that I can support both english,
> french, and spanish. =C2=A0Having 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.
--=20
Itagaki Takahiro