Re: sort order for UTF-8 char column with Japanese UTF-8

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: sort order for UTF-8 char column with Japanese UTF-8
Дата
Msg-id 388084.1643985521@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: sort order for UTF-8 char column with Japanese UTF-8  (Matthias Apitz <guru@unixarea.de>)
Список pgsql-general
Дерево обсуждения 
Matthias Apitz <guru@unixarea.de> writes:
> Said that, does the SORT done by the server depends on the environment
> (LANG, LC_*) in which the PostgreSQL server is started or only of the
> sp_catalog information of the database in question?

We set LC_COLLATE and LC_CTYPE from the database's relevant
pg_database fields.  The remaining LC environment variables
shouldn't affect this (and I think we force them to "C"
anyway).

            regards, tom lane

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

Предыдущее
От: Matthias Apitz
Дата:
Сообщение: Re: sort order for UTF-8 char column with Japanese UTF-8
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: increasing effective_cache_size slows down join queries by a factor of 4000x