Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x

Поиск
Список
Период
Сортировка
От Debraj Manna
Тема Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x
Дата
Msg-id CAF6DVKOy4tadA3Acz_qp_44oF442KgSKiKU7KbSnKNRCo-Vp=g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Difference between C and en_US.UTF-8 Collate & CType inPostgres 10.x  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x  (Imre Samu <pella.samu@gmail.com>)
Re: Difference between C and en_US.UTF-8 Collate & CType inPostgres 10.x  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Дерево обсуждения
Thanks for replying.

Will there be any other difference like in terms of index size, etc?

Is there any link that I can refer that provides more details about the differences?

On Fri 14 Sep, 2018, 5:27 PM Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
Debraj Manna wrote:
> Can someone let me know what is the difference we are expected to observe if we set
> Collate & Ctype to C as against  en_US.UTF-8 with encoding set to UTF8 in both the cases ?

For one, the ordering will be substantially different.

Compare the result of these two queries:

SELECT chr(i) FROM generate_series(1, 50000) i ORDER BY chr(i) COLLATE "C";
SELECT chr(i) FROM generate_series(1, 50000) i ORDER BY chr(i) COLLATE "en_US.utf8";

Yours,
Laurenz Albe

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

Предыдущее
От: Amine Tengilimoglu
Дата:
Сообщение: postgresql HA solution for different network domain
Следующее
От: Ron
Дата:
Сообщение: Re: how to debug the postgres performance issue