Re: Collation Order Change

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Collation Order Change
Дата
Msg-id 23964.1022077219@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Collation Order Change  ("Len Morgan" <len-morgan@crcom.net>)
Список pgsql-general
"Len Morgan" <len-morgan@crcom.net> writes:
> The problem shows up in names that contain more than one word.  It seems
> that the "new" alphabetical order doesn't look at spaces or dashes when
> deciding on order.  For example:

Sounds like you have selected a non-C locale (most likely en_US, which
is the system default in recent RH releases).  Unfortunately the only
way to change PG's locale is a fresh initdb :-(.  Try

    export LANG=C
    locale        --- make sure it says "C" for everything
    initdb

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: psql -l gives bad output
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: .doc .rtf database in PostgreSQL+PHP