Re: Locale, encoding, sort order confusion - Mailing list pgsql-general

From John Gunther
Subject Re: Locale, encoding, sort order confusion
Date
Msg-id 44E8F505.806@bucksvsbytes.com
Whole thread Raw
In response to Locale, encoding, sort order confusion  (John Gunther <postgresql@bucksvsbytes.com>)
Responses Re: Locale, encoding, sort order confusion  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
>Pretty much any locale (say, en_US for you) with a matching character
>set should work.  Unless you go out of your way, this should be the
>default setting.

>> I've tried a half dozen time-consuming configs without
>> success.

>Like what?

For example, with all LC_* parameters set to "en_US.UTF8", I get the following incorrect "order:by":

Béarn
Bécancour
Beaupré

Bécancour should be last.

Incidentally, in psql via a putty.exe session, the only character set translation I can find that displays the accented
charactersis CP437. Does this seem right? 


pgsql-general by date:

Previous
From: Q Beukes
Date:
Subject: Re: apostrophes and psql variables
Next
From: Alvaro Herrera
Date:
Subject: Re: Locale, encoding, sort order confusion