Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: problem with dots in order by
Date
Msg-id 12862.1108485259@sss.pgh.pa.us
Whole thread Raw
In response to problem with dots in order by  (Ruben Oliveira <ruben_dig@netcabo.pt>)
Responses Re: problem with dots in order by
List pgsql-general
Tree view 
Ruben Oliveira <ruben_dig@netcabo.pt> writes:
> Can anybody tell me if there is something I can do in the Linux config
> to have the same order by result ??

Sort order is determined by locale, not encoding.  You did the Linux
initdb in the wrong locale (possibly something like en_US where you'd
rather have had C locale).

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Alternate db location
Next
From: Stephan Szabo
Date:
Subject: Re: problem with dots in order by