Re: Setting "ucs_basic" as the default database collation

[Christophe Pettus]

> On Oct 27, 2024, at 13:56, Ron Johnson <ronljohnso...@gmail.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.