Christophe Pettus writes:
> 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?
CREATE DATABASE wants you to specify a locale, which ucs_basi
> On Oct 27, 2024, at 13:56, Ron Johnson 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;
On Sun, Oct 27, 2024 at 5:32 AM Christophe Pettus 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
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
