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 characters is CP437. Does this seem right? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
