Re: Setting "ucs_basic" as the default database collation

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Setting "ucs_basic" as the default database collation
Date: 2024-10-27 11:56:26
Message-ID: CANzqJaAwm+rthbXq7=RMZKn4sBakUv+O6S8awhj-B+UH9FdwJg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Oct 27, 2024 at 5:32 AM Christophe Pettus <xof(at)thebuild(dot)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
>
>
https://www.postgresql.org/docs/16/sql-createdatabase.html

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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 黄铎彦 2024-10-27 12:52:16 Re: Building v17 Beta2 on Windows
Previous Message Christophe Pettus 2024-10-27 09:31:41 Setting "ucs_basic" as the default database collation