Search Postgresql Archives

Re: Locale, encoding, sort order confusion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux