Re: database locale and system locale - Mailing list pgsql-admin

From Tom Lane
Subject Re: database locale and system locale
Date
Msg-id 26548.1143390039@sss.pgh.pa.us
Whole thread Raw
In response to Re: database locale and system locale  (Erwin Brandstetter <brandstetter@falter.at>)
Responses Re: database locale and system locale
List pgsql-admin
Erwin Brandstetter <brandstetter@falter.at> 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 sort
ordering will be wrong.  Not "random" exactly, but not what you want.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Donald Fraser"
Date:
Subject: Initial request packet for SSL
Next
From: Tom Lane
Date:
Subject: Re: Initial request packet for SSL