Re: Add standard collation UNICODE

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Add standard collation UNICODE
Дата
Msg-id 85a3456ad3758336b8c26d0bd7545e6b5124cda1.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: Add standard collation UNICODE  (Thomas Munro <thomas.munro@gmail.com>)
Ответы Re: Add standard collation UNICODE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sun, 2023-03-05 at 08:27 +1300, Thomas Munro wrote:
> 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?

Right, makes sense.

Though in principle, shouldn't someone using another encoding also be
able to use ucs_basic? I'm not sure if that's a practical problem or
not; I'm just curious. Does ICU provide a locale for sorting by code
point?

Regards,
    Jeff Davis




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

Предыдущее
От: Joseph Koshakow
Дата:
Сообщение: Re: Date-Time dangling unit fix
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Request for comment on setting binary format output per session