Re: Setting "ucs_basic" as the default database collation

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Setting "ucs_basic" as the default database collation
Date: 2024-10-27 14:55:00
Message-ID: 8580A26C-48D2-4B37-9F06-5708060BDAB7@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

No:

xof=# create database test encoding=ucs_basic;
ERROR: ucs_basic is not a valid encoding name
LINE 1: create database test encoding=ucs_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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Costa Alexoglou 2024-10-27 15:23:44 Used memory calculation in containers - docker stats and file cache
Previous Message 黄铎彦 2024-10-27 12:52:16 Re: Building v17 Beta2 on Windows