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

case-sensitive sorting and locale settings?

P: n/a
CSN
On my windows/cygwin/PG 7.3.1 box, results are sorted
with lowercase appearing after uppercase. On my
redhat/PG 7.3.3 boxes results are sorted without
regard to case. Is there some locale (or other)
setting that controls this? If so, which locales do
which?

Or is this due to something else entirely - such as
the OS's?

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
CSN writes:
On my windows/cygwin/PG 7.3.1 box, results are sorted
with lowercase appearing after uppercase. On my
redhat/PG 7.3.3 boxes results are sorted without
regard to case. Is there some locale (or other)
setting that controls this? If so, which locales do
which?


The first box apparently uses no locale (set to "C"), the second box uses
some locale (all locales behave that way).

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.