Re: Locale C vs Local English, United States

[<operationsengineer1(at)yahoo(dot)com>]

> > i've done a few pgsql installs and this item never
> > really resonated in my head.  i have been
> defaulting
> > to "C" for the locale.  Is this right?  I see
> there is
> > an option for "English, United States" - this
> would
> > seem to be a more obvious choice given my location
> in
> > 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
> topic.
> 
> 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.
> 
> Regards,
> 
> 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
later.

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.
http://smallbusiness.yahoo.com/r-index