| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Choosing default collation/ctype |
| Date: | 2026-05-06 06:05:15 |
| Message-ID: | ccbb58ad-7136-49ae-a11f-07b2a5b6d0a7@eisentraut.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 03.05.26 21:52, Igor Korot wrote:
> Is there a way to select a default collation/ctype for a specific encoding?
>
> Or maybe I'm overthinking it and I should let the user choose and if
> nothing - just keep those 2 as "Default" and let the server pick it
> up. However it will be weird, especially from me as a user POV.
There is no default collation/ctype (locale) for an encoding, only the
other way around. So if a user picks as locale, let's say, de_DE(at)euro,
then the encoding is automatically LATIN9 (obsolete), if the locale is
de_DE.utf8, then the encoding is UTF8, and so on.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Torsten Krah | 2026-05-07 17:37:38 | untracked child process (PID XXXXX) exited with exit code 120 |
| Previous Message | Daniel Verite | 2026-05-05 18:28:43 | Re: Choosing default collation/ctype |