MIME-Version: 1.0
References: <C078C414-9780-490E-9CB9-A9604C44251F@thebuild.com>
In-Reply-To: <C078C414-9780-490E-9CB9-A9604C44251F@thebuild.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sun, 27 Oct 2024 07:56:26 -0400
Message-ID: <CANzqJaAwm+rthbXq7=RMZKn4sBakUv+O6S8awhj-B+UH9FdwJg@mail.gmail.com>
Subject: Re: Setting "ucs_basic" as the default database collation
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000062c4a80625740b8b"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAwm%2BrthbXq7%3DRMZKn4sBakUv%2BO6S8awhj-B%2BUH9FdwJg%40mail.gmail.com>
Precedence: bulk

--00000000000062c4a80625740b8b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, Oct 27, 2024 at 5:32=E2=80=AFAM 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 tim=
e,
> 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'?

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

--00000000000062c4a80625740b8b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sun, Oct 27, 2024 at 5:32=E2=80=AFAM C=
hristophe Pettus &lt;<a href=3D"mailto:xof@thebuild.com">xof@thebuild.com</=
a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmai=
l_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,20=
4,204);padding-left:1ex">Is there a way to specify &quot;ucs_basic&quot; (o=
r the other &quot;standard collations&quot; [1]) collation as the default d=
atabase collation at database creation time, rather than on a per-column or=
 per-operation basis?<br>
<br>
[1] <a href=3D"https://www.postgresql.org/docs/current/collation.html#COLLA=
TION-MANAGING-STANDARD" rel=3D"noreferrer" target=3D"_blank">https://www.po=
stgresql.org/docs/current/collation.html#COLLATION-MANAGING-STANDARD</a><br=
>
<br></blockquote><div><br></div><div><a href=3D"https://www.postgresql.org/=
docs/16/sql-createdatabase.html">https://www.postgresql.org/docs/16/sql-cre=
atedatabase.html</a></div><div>=C2=A0</div></div>The CREATE DATABASE statem=
ent has an=C2=A0<span style=3D"color:rgb(0,0,0);font-family:monospace,monos=
pace;font-size:14.4px">ENCODING</span>=C2=A0option.=C2=A0 Does that work wi=
th &#39;ucs_basic&#39;?<div><div><br></div><span class=3D"gmail_signature_p=
refix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D=
"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I=
&#39;m still alive.<br><div><div>&lt;Redacted&gt; crustacean!</div></div></=
div><div><br></div></div></div></div></div>

--00000000000062c4a80625740b8b--