Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Setting "ucs_basic" as the default database collation
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CANzqJaAwm+rthbXq7=RMZKn4sBakUv+O6S8awhj-B+UH9FdwJg@mail.gmail.com>
Date: Sun, 27 Oct 2024 16:55:00 +0200
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <8580A26C-48D2-4B37-9F06-5708060BDAB7@thebuild.com>
References: <C078C414-9780-490E-9CB9-A9604C44251F@thebuild.com>
 <CANzqJaAwm+rthbXq7=RMZKn4sBakUv+O6S8awhj-B+UH9FdwJg@mail.gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/8580A26C-48D2-4B37-9F06-5708060BDAB7%40thebuild.com>
Precedence: bulk


> On Oct 27, 2024, at 13:56, Ron Johnson <ronljohnsonjr@gmail.com> =
wrote:
>=20
>  The CREATE DATABASE statement has an ENCODING option.  Does that work =
with 'ucs_basic'?

No:

xof=3D# create database test encoding=3Ducs_basic;
ERROR:  ucs_basic is not a valid encoding name
LINE 1: create database test encoding=3Ducs_basic;
                             ^

Although that's not too surprising; it's a UTF-8 collation, not an =
encoding as such.  Experimenting with the various other CREATE DATABASE =
parameters hasn't gotten me any farther.=