locale support

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: locale support
Date: 2003-05-07 19:34:52
Message-ID: 3EB95FDC.70609@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Just a simple question regarding which locale setting applies to which
type of sorting. I have two machines, production and development. The
development machine has LC_COLLATE and LC_CTYPE set to C and the other
has them both set to en_US.
We originally changed the development machine from en_US to C because we
were having a problem with spaces being sorted in correctly. That has
been fixed on the development box, but I now noticed it is sorting lower
case letters after all capital letters. I would prefer that case is
ignored when alphabetical sorts are completed. This type of sort is
working correctly on the machine where both locales are set to en_US.
Does this mean that one of the above mentioned locales needs to be set
back to en_US? I would like to have case ignored but I want to be
careful not to mess up the sorting of spaces, which we have already
fixed. I hate to have to test on my own and then have to reinitialize
more than once! Please advise if you can.
Thanks
Jodi
--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-05-07 20:05:14 Re: locale support
Previous Message gunther hust 2003-05-07 16:50:52 eRserver