Re: [ADMIN] database locale and system locale

2006-03-27 Thread Peter Eisentraut
Am Montag, 27. März 2006 10:56 schrieb Erwin Brandstetter: > Would the system locale of the _server_ OS mess with the sort order? (Or > with anything at all?) No. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--

Re: [ADMIN] database locale and system locale

2006-03-27 Thread Erwin Brandstetter
[EMAIL PROTECTED] wrote: Erwin Brandstetter <[EMAIL PROTECTED]> writes: Wait .. not that great! The system locale is more or less ignored, but my sort order will approach randomness? Peter's point is that a given locale setting will expect a particular encoding, and if you try to use a

Re: [ADMIN] database locale and system locale

2006-03-26 Thread Tom Lane
Erwin Brandstetter <[EMAIL PROTECTED]> writes: > Wait .. not that great! The system locale is more or less ignored, but > my sort order will approach randomness? Peter's point is that a given locale setting will expect a particular encoding, and if you try to use a different encoding then your so

Re: [ADMIN] database locale and system locale

2006-03-26 Thread Erwin Brandstetter
[EMAIL PROTECTED] wrote: 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 matter

Re: [ADMIN] database locale and system locale

2006-03-26 Thread Peter Eisentraut
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 da

[ADMIN] database locale and system locale

2006-03-25 Thread Erwin Brandstetter
Hi everyone! 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)? (In my case, I am speaking of postgresql 8.1 on debian sarge. But general understanding is what I am l