Re: Locale, encoding, sort order confusion

Поиск
Список
Период
Сортировка
От John Gunther
Тема Re: Locale, encoding, sort order confusion
Дата
Msg-id 44E9E48F.90909@bucksvsbytes.com
обсуждение исходный текст
Ответ на Re: Locale, encoding, sort order confusion  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Alvaro Herrera wrote: <blockquote cite="mid20060821001057.GB1130@alvh.no-ip.org" type="cite"><blockquote
type="cite"><prewrap="">For example, with all LC_* parameters set to "en_US.UTF8", I get the 
 
following incorrect "order:by":

Béarn
Bécancour
Beaupré   </pre></blockquote><pre wrap="">
Did you initdb with locale en_US.UTF8, and also createdb with encoding
UTF8?  While you can certainly choose mismatching values in createdb and
initdb, you shouldn't because it doesn't work.</pre></blockquote> That's an interesting question. Are the LC_*
variablesset by initdb or createdb? In other words, does their value indicate what initdb settings I used? If I do a
defaultcreatedb, will the new database automatically be consistent with the cluster's initdb?<br /> 

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Queries joining views
Следующее
От: Tom Lane
Дата:
Сообщение: Re: cannot open pg_database