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 "[EMAIL PROTECTED]"? 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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
