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>
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 |