Request a Demo
Home   >   mailing lists

Re: Setting "ucs_basic" as the default database collation - Mailing list pgsql-general

From Ron Johnson
Subject Re: Setting "ucs_basic" as the default database collation
Date
Msg-id CANzqJaAwm+rthbXq7=RMZKn4sBakUv+O6S8awhj-B+UH9FdwJg@mail.gmail.com
Whole thread Raw
In response to Setting "ucs_basic" as the default database collation  (Christophe Pettus <xof@thebuild.com>)
Responses Re: Setting "ucs_basic" as the default database collation
List pgsql-general
Tree view
On Sun, Oct 27, 2024 at 5:32 AM Christophe Pettus <xof@thebuild.com> wrote:
Is there a way to specify "ucs_basic" (or the other "standard collations" [1]) collation as the default database collation at database creation time, rather than on a per-column or per-operation basis?

[1] https://www.postgresql.org/docs/current/collation.html#COLLATION-MANAGING-STANDARD


 
The CREATE DATABASE statement has an ENCODING option.  Does that work with 'ucs_basic'?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Setting "ucs_basic" as the default database collation
Next
From: Christophe Pettus
Date:
Subject: Re: Setting "ucs_basic" as the default database collation