public inbox for pgsql-general@postgresql.org  

help / color / mirror / Atom feed

From: Rob Sargent <robjsargent@gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Choosing default collation/ctype
Date: Sun, 3 May 2026 22:16:06 -0600
Message-ID: <0249361D-3CAC-41DF-9024-E154E8B02909@gmail.com> (raw)
In-Reply-To: <CA+FnnTz0bXuTUR5CqXNM5xR3UM9MbTOkYdUP5rUNGSQxZaznXg@mail.gmail.com>
References: <CA+FnnTz0bXuTUR5CqXNM5xR3UM9MbTOkYdUP5rUNGSQxZaznXg@mail.gmail.com>



> On May 3, 2026, at 3:51 PM, Igor Korot <ikorot01@gmail.com> wrote:
> 
> 
>> 
>> 
>> Then choose UTF8.
> 
> Let me give you a quick run of what I'm trying to do:
> 
> In my code I have 3 combo boxes: encoding, collation and ctype.
> 
> Initially they all have a value of "Default".
> 
> Lets say a user selected "KOI8-R" as an emcoding.
> 
> 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.
> 
> Now are you saying I should choose the one that have "UTF8"
> in it?
> 
> Thank you.
> 
>> 

What is your user trying to do? Create a database? And you are asking for server side settings to use when you invoke a create database command on the user’s behalf? And they will understand all the possibilities and their consequences?

Or are you asking the user which settings to use for this clientside user? If I were this user I would be pissed off you didn’t make some reasonable guess for a starting point from the current environment. 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: robjsargent@gmail.com, ikorot01@gmail.com, ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
  Subject: Re: Choosing default collation/ctype
  In-Reply-To: <0249361D-3CAC-41DF-9024-E154E8B02909@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox