Re: Choosing default collation/ctype - Mailing list pgsql-general

From Rob Sargent
Subject Re: Choosing default collation/ctype
Date
Msg-id 0249361D-3CAC-41DF-9024-E154E8B02909@gmail.com
Whole thread
In response to Re: Choosing default collation/ctype  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general

> 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
createdatabase 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
youdidn’t make some reasonable guess for a starting point from the current environment.  




pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Choosing default collation/ctype