Re: problem with dots in order by

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.