Postgres Pro
Downloads
Home   >   mailing lists

Re: sort order for UTF-8 char column with Japanese UTF-8 - Mailing list pgsql-general

From Tom Lane
Subject Re: sort order for UTF-8 char column with Japanese UTF-8
Date
Msg-id 388084.1643985521@sss.pgh.pa.us
Whole thread Raw
In response to Re: sort order for UTF-8 char column with Japanese UTF-8  (Matthias Apitz <guru@unixarea.de>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: sort order for UTF-8 char column with Japanese UTF-8
Next
From: Tomas Vondra
Date:
Subject: Re: increasing effective_cache_size slows down join queries by a factor of 4000x