Re: database locale and system locale

Erwin Brandstetter wrote:
> I've been reading tons of stuff on locale and postgresql. I am still
> not in the clear about some details, though: how do system locale and
> database locale work together (or not)?

The system locale is more or less ignored. What matters are the locales
set in the database.

> If I am running a database cluster with --encoding= UTF8, are there
> any troubles to be expected if the system locale remains "C" or
> somehting like "de_AT(dot)iso885915(at)euro"?

Your sort order will approach randomness.

> Is it enough to have an UTF8 locale installed on the system?

You need to have it installed and you need to tell initdb to use it.

> Or does it actually have to be the system locale?

No.

> Do multiple UTF8 system locales have any effect?

No.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/