> > i've done a few pgsql installs and this item never
> > really resonated in my head. i have been
> > to "C" for the locale. Is this right? I see
> there is
> > an option for "English, United States" - this
> > seem to be a more obvious choice given my location
> > the united states.
> > from what I've been able to dig up, it appears the
> > locale may have an impact on different queries.
> > anyway, I'd appreciate some insight so i can learn
> > something and add it to my windows pgsql install
> > tutorial.
> You might what search the pg_general list on this
> What you will find is that each local has different
> rules for sorting. One problem is that other
> locales (other than c) will not produce the same
> sort ordering between various platforms. Also
> FWIRC, I think there may be some unexpected gotchas
> caused by unpredictable sort orders.
> Richard Broersma Jr.
Richard, thanks. from what i gather, locale C is a
pretty good default, even if it's name is entirely
cryptic on the surface. i think i'll stick with C for
the time being and, perhaps, research it more a bit
I would be interested in seeing your batch file.
right now, i only develop on windows (backups aren't
that important, however, it would still be a nice
option. my production server is linux. however, that
could change if i ever develop something useful
outside of my current environment.
Want to start your own business?
Learn how on Yahoo! Small Business.
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2006-12-15 00:46:58|
|Subject: Upgrade Backup Issue|
|Previous:||From: Richard Broersma Jr||Date: 2006-12-14 21:31:23|
|Subject: Re: Locale C vs Local English, United States|