Re: Locale, encoding, sort order confusion

>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?