Re: Add standard collation UNICODE

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Add standard collation UNICODE
Дата
Msg-id CA+hUKGKZEDiXeGFcPw2GAGxdPCr2L+9yPdWeHvS3v+C9ipgpKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add standard collation UNICODE  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: Add standard collation UNICODE  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
Дерево обсуждения 
On Sun, Mar 5, 2023 at 7:30 AM Jeff Davis <pgsql@j-davis.com> wrote:
> Sorting by codepoint should be encoding-independent (i.e. decode to
> codepoint first); but the C collation is just strcmp, which is
> encoding-dependent. So is UCS_BASIC wrong today?

It's created for UTF-8 only, and UTF-8 sorts the same way as the
encoded code points, when interpreted as a sequence of unsigned char
by memcmp(), strcmp() etc.  Seems right?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [Proposal] Allow pg_dump to include all child tables with the root table
Следующее
От: Joseph Koshakow
Дата:
Сообщение: Re: Date-time extraneous fields with reserved keywords