Re: Locale, encoding, sort order confusion

Поиск
Список
Период
Сортировка
От John Gunther
Тема Re: Locale, encoding, sort order confusion
Дата
Msg-id 44E8F505.806@bucksvsbytes.com
обсуждение исходный текст
Ответ на Locale, encoding, sort order confusion  (John Gunther <postgresql@bucksvsbytes.com>)
Ответы Re: Locale, encoding, sort order confusion
Список 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 по дате отправления:

Предыдущее
От: Q Beukes
Дата:
Сообщение: Re: apostrophes and psql variables
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Locale, encoding, sort order confusion