By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

Sort order is different on Windows and Linux

P: n/a
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 ASCIIorder. 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 simplyset 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?

Thanks in advance.

Robert

Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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).
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #2

P: n/a
Do I simply "export LC_COLLATE=C" before I initdb, or do I pass it as a
parameter?
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).

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.