| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | "Dominique Devienne" <ddevienne(at)gmail(dot)com> |
| Cc: | "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>,pgsql-general(at)postgresql(dot)org |
| Subject: | Re: LOCALE C.UTF-8 on EDB Windows v17 server |
| Date: | 2025-06-05 12:40:08 |
| Message-ID: | d57d35d0-9d27-4be7-aad9-b139a18b990d@manitou-mail.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dominique Devienne wrote:
> On Linux, no error unlike on Windows (still inconsistent there IMHO),
> but the result is slightly different for datcollate and datctype (C vs
> en_US),
> while the same for datlocprovider and datlocale, what I looked at.
>
> Thus I kinda persist that there *is* a portability issue here.
"datcollate" and "datctype" refer to operating system locale names.
locale 'C.UTF-8' or lc_collate 'C.UTF-8' lc_ctype 'C.UTF-8'
cannot work on Windows because Windows does not have a locale
named C.UTF-8, whereas a Linux system does (well at least recent
Linuxes. Some old Linuxes don't).
What you are seeing is the effect of OS locales not being portable
across systems. That's confusing but not a Postgres bug.
Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dominique Devienne | 2025-06-05 13:07:49 | Re: LOCALE C.UTF-8 on EDB Windows v17 server |
| Previous Message | Karsten Hilbert | 2025-06-05 12:39:29 | Re: Feature request: Settings to disable comments and multiple statements in a connection |