Re: database locale and system locale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
Cc: pgsql-admin(at)postgresql(dot)org, peter_e(at)gmx(dot)net
Subject: Re: database locale and system locale
Date: 2006-03-26 16:20:39
Message-ID: 26548.1143390039@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Erwin Brandstetter <brandstetter(at)falter(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-03-26 16:25:50 Re: Initial request packet for SSL
Previous Message Donald Fraser 2006-03-26 15:58:20 Initial request packet for SSL