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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: sort order for UTF-8 char column with Japanese UTF-8
Date: 2022-02-04 14:38:41
Message-ID: 388084.1643985521@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthias Apitz <guru(at)unixarea(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2022-02-04 17:01:20 Re: increasing effective_cache_size slows down join queries by a factor of 4000x
Previous Message Matthias Apitz 2022-02-04 08:29:05 Re: sort order for UTF-8 char column with Japanese UTF-8