Re: UTF-8 collation on Windows?

Поиск
Список
Период
Сортировка
От Dev Kumkar
Тема Re: UTF-8 collation on Windows?
Дата
Msg-id CALSLE1PuyOxSY70R_6=1=kD7abogj111K2ZVHXr6=e+AwgfTdg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: UTF-8 collation on Windows?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: UTF-8 collation on Windows?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Thu, Feb 20, 2014 at 2:01 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
Just noticed you are not specifying the template database. Try using template0:

createdb -U postgres -E utf8 --lc-ctype=american_usa --lc-collate=american_usa  -T template0 <DBNAME>

Same result i.e. LC_COLLATE and LC_CTYPE gets set as 'English_United States.1252'
Had specified template option this earlier too.

Btw in case the specified collation is incompatible then "createdb" binary complains and instructs to use template0 as template, which isn't the case here.

The codeset parameter is missed here and hence it takes the collation as the default one which is 'English_United States.1252'.

Regards...

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Timezone information
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: UTF-8 collation on Windows?