Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Choosing default collation/ctype
Date: Sun, 3 May 2026 22:16:06 -0600
Message-Id: <0249361D-3CAC-41DF-9024-E154E8B02909@gmail.com>
References: <CA+FnnTz0bXuTUR5CqXNM5xR3UM9MbTOkYdUP5rUNGSQxZaznXg@mail.gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
In-Reply-To: <CA+FnnTz0bXuTUR5CqXNM5xR3UM9MbTOkYdUP5rUNGSQxZaznXg@mail.gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/0249361D-3CAC-41DF-9024-E154E8B02909%40gmail.com>
Precedence: bulk


> On May 3, 2026, at 3:51=E2=80=AFPM, Igor Korot <ikorot01@gmail.com> wrote:=

>=20
> =EF=BB=BF
>>=20
>>=20
>> Then choose UTF8.
>=20
> Let me give you a quick run of what I'm trying to do:
>=20
> In my code I have 3 combo boxes: encoding, collation and ctype.
>=20
> Initially they all have a value of "Default".
>=20
> Lets say a user selected "KOI8-R" as an emcoding.
>=20
> What I will do is populate collation and ctype combo boxes with
> values available for such encodings.
> But I want to go a little further and change the values in those
> to be the default collation/ctype for the "KOI8-R" encoding.
>=20
> Now are you saying I should choose the one that have "UTF8"
> in it?
>=20
> Thank you.
>=20
>>=20

What is your user trying to do? Create a database? And you are asking for se=
rver side settings to use when you invoke a create database command on the u=
ser=E2=80=99s behalf? And they will understand all the possibilities and the=
ir consequences?

Or are you asking the user which settings to use for this clientside user? I=
f I were this user I would be pissed off you didn=E2=80=99t make some reason=
able guess for a starting point from the current environment.=20