| 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: | Whole Thread | Raw Message | 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 |