Re: Sort order is different on Windows and Linux

On Wed, 17 Sep 2003, Robert Wille wrote:

> I have found that the sort order is different on Windows and Linux (same
> version of Postgres). On Windows, it sorts in what appears to be normal
> ASCII order. On Linux, lowercase comes before uppercase, and all
> non-alphanumerics appear to come before all alphanumerics. I really need
> it to sort on Linux the same as it does on Windows. The docs seem to
> imply that I can simply set the LANG environment variable to C to get an
> ASCII sort order, but that seem to make a difference. How do I change
> the sort order?

You need to have the database initdb'd with the appropriate collation set
in LC_COLLATE. Changing LANG/LC_COLLATE after the fact won't help (in
recent versions anyway).