Re: problem with dots in order by - Mailing list pgsql-general

From Stephan Szabo
Subject Re: problem with dots in order by
Date
Msg-id 20050215083524.C67893@megazone.bigpanda.com
Whole thread Raw
In response to problem with dots in order by  (Ruben Oliveira <ruben_dig@netcabo.pt>)
List pgsql-general
On Tue, 15 Feb 2005, Ruben Oliveira wrote:

> Hello everybody !
>
> I have this order by :
> select lalala from tablex order by field_y;
> where field_y is a text column.
>
> that returns something like :
> 2.1004.11
> 21.00.461
> 2.1006.21
>
> in  PostgreSQL 7.3.2 in Linux Mandrake 9.1
>
> but in PostgreSQL 8.0.0 in Windows XP it works as I expected ...
>
> 2.1004.11
> 2.1006.21
> 21.00.461
>
> the two config share the same Encoding when the database was created and
> the client enconding is the same in the two cases :

It's not encoding that's important.  It's locale (LC_COLLATE).
The linux box is probably running the server with en_US which sorts like
you've shown the above (ignoring most/all symbols and spaces in first pass
sorting).

You could re-initdb in "C" locale to change the sort ordering.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem with dots in order by
Next
From: "Serguei A. Mokhov"
Date:
Subject: Re: database encoding "WIN" -- Western or Cyrillic?