Re: Encoding/collation question

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Encoding/collation question
Дата
Msg-id 875zimb0j8.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: Encoding/collation question  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Encoding/collation question  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: Encoding/collation question  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
>>>>> "Rich" == Rich Shepard <rshepard@appl-ecosys.com> writes:

 Rich> I doubt that my use will notice meaningful differences. Since
 Rich> there are only two or three databases in UTF8 and its collation
 Rich> perhaps I'll convert those to LATIN1 and C.

Note that it's perfectly fine to use UTF8 encoding and C collation (this
has the effect of sorting strings in Unicode codepoint order); this is
as fast for comparisons as LATIN1/C is.

For those cases where you need data to be sorted in a
culturally-meaningful order rather than in codepoint order, you can set
collations on specific columns or in individual queries.

-- 
Andrew (irc:RhodiumToad)



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

Предыдущее
От: Mike Lissner
Дата:
Сообщение: Logical replication DNS cache
Следующее
От: Deepti Sharma S
Дата:
Сообщение: RE: PostgreSQL version compatibility with RHEL7.7