pg.ddx.io pgsql-bugs@postgresql.org mailing list archive help / color / mirror / Atom feed From: Rahul Pandey <pandeyrah@microsoft.com>
To: Haifang Wang (Centific Technologies Inc) <v-haiwang@microsoft.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Vishwa Deepak <Vishwa.Deepak@microsoft.com>
Cc: Shawn Steele <Shawn.Steele@microsoft.com>
Cc: Amy Wishnousky <amyw@microsoft.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Cc: Shweta Gulati <gulatishweta@microsoft.com>
Cc: Ashish Nawal <nawalashish@microsoft.com>
Cc: 🎯dev <targetdev@microsoft.com>
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
Date: Wed, 5 Jun 2024 09:10:30 +0000
Message-ID: <PSAP153MB0439B5E53B80F6D4EF37AD49BDF92@PSAP153MB0439.APCP153.PROD.OUTLOOK.COM> (raw )
In-Reply-To: <PH8PR21MB3902C10CE3A1B07FE8C3EEF2E5F82@PH8PR21MB3902.namprd21.prod.outlook.com >
References: <PH8PR21MB390263C479B81A1B7330E744E5182@PH8PR21MB3902.namprd21.prod.outlook.com >
<PH8PR21MB3902F334A3174C54058F792CE5182@PH8PR21MB3902.namprd21.prod.outlook.com >
<CA+hUKG+b_XqMZ6xkFhMCEwLXbGSN1rDYYY-En8MgFe81auRAAg@mail.gmail.com >
<PH8PR21MB39022E5B54CE6E03E194B30FE5E22@PH8PR21MB3902.namprd21.prod.outlook.com >
<CA+hUKGKrzGnCW3MoVC7gayHCtJQPEJKgpfQWD6c7eUvFp+ac+A@mail.gmail.com >
<PH8PR21MB39027F1F4EAFEAE33EB4BA39E5E22@PH8PR21MB3902.namprd21.prod.outlook.com >
<CA+hUKG+GUcSzk7UwvuLr4p84BQV8k2xvVAjToW=fQ5rCrciJ4A@mail.gmail.com >
<872239.1715641638@sss.pgh.pa.us >
<CA+hUKGJJgyc9xg+g_8_jPUV08Kr0NFdgq2_H9mm7-eZd7YVRQg@mail.gmail.com >
<PH8PR21MB3902402C3C3C20DD8CB40AFFE5EC2@PH8PR21MB3902.namprd21.prod.outlook.com >
<PH8PR21MB39027671C218DE448D8C091CE5EE2@PH8PR21MB3902.namprd21.prod.outlook.com >
<CA+hUKG+oS+rriPvML+j6mZgCkJDsGP9bP7qopVxSLeTWsAOtsA@mail.gmail.com >
<2682258.1716011233@sss.pgh.pa.us >
<CA+hUKG+j5YwGtoV0_q3NxjD3EygxdwYeedUAFKamcLzR+PrcpQ@mail.gmail.com >
<DS0PR21MB390450195D21634ABCA26F4FE5E92@DS0PR21MB3904.namprd21.prod.outlook.com >
<CA+hUKGJDv3pCnQXY13uYW1oe9CvFw8Y2j8mBMh2HGk_X0qYEcw@mail.gmail.com >
<PH8PR21MB3902C3DB0535FD33CBF2E8C2E5E92@PH8PR21MB3902.namprd21.prod.outlook.com >
<KL1P15301MB0387AF8D3B2FE878BF1B576AE3EA2@KL1P15301MB0387.APCP153.PROD.OUTLOOK.COM >
<PSAP153MB0439B2D8386BDFF643A7B5A2BDEB2@PSAP153MB0439.APCP153.PROD.OUTLOOK.COM >
<PH8PR21MB3902C9024782A8A3E26370ACE5F12@PH8PR21MB3902.namprd21.prod.outlook.com >
<PH8PR21MB39022FCDB4806CD57694F50AE5FF2@PH8PR21MB3902.namprd21.prod.outlook.com >
<CA+hUKGK-G=DB5MttZzzZf7mzTMxRVSACNg-WGK59Tk1Q9vY3cA@mail.gmail.com >
<PH8PR21MB3902C10CE3A1B07FE8C3EEF2E5F82@PH8PR21MB3902.namprd21.prod.outlook.com >
Hi,
"Do "Turkish_Turkey.1254", "Turkish_Türkiye.1254" and "tr-TR.1254" all behave identically?"
You are correct, they all behave in exactly the same way.
I too would recommend using "tr-TR.1254" since BCP47 tags have a defined structure and this would make the implementation more future proof.
As for translation files, apologies I neither have a preference nor expertise to comment on this.
________________________________
From: Haifang Wang (Centific Technologies Inc) <v-haiwang@microsoft.com>
Sent: Tuesday, June 4, 2024 5:39 AM
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Rahul Pandey <pandeyrah@microsoft.com>; Vishwa Deepak <Vishwa.Deepak@microsoft.com>; Shawn Steele <Shawn.Steele@microsoft.com>; Amy Wishnousky <amyw@microsoft.com>; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; Shweta Gulati <gulatishweta@microsoft.com>; Ashish Nawal <nawalashish@microsoft.com>
Subject: RE: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
Thanks, Thomas. I would leave the questions to Vishwa and Rahul to answer.
Regards!
Haifang
-----Original Message-----
From: Thomas Munro <thomas.munro@gmail.com>
Sent: Monday, June 3, 2024 2:22 PM
To: Haifang Wang (Centific Technologies Inc) <v-haiwang@microsoft.com>
Cc: Rahul Pandey <pandeyrah@microsoft.com>; Vishwa Deepak <Vishwa.Deepak@microsoft.com>; Shawn Steele <Shawn.Steele@microsoft.com>; Amy Wishnousky <amyw@microsoft.com>; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-bugs@lists.postgresql.org; Shweta Gulati <gulatishweta@microsoft.com>; Ashish Nawal <nawalashish@microsoft.com>
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
On Tue, Jun 4, 2024 at 1:00 AM Haifang Wang (Centific Technologies
Inc) <v-haiwang@microsoft.com> wrote:
> Just would like to follow up with you about this bug. Hope Rahul and Vishwa have answered all your questions below. Did you get chance to do investigations? Any other questions?
Hi,
Thanks for all your feedback! Sorry for my late replies, I was travelling and at a conference last week (at which one of the topics was "what are we going to do about the sorry state of PostgreSQL on Windows", but that's a wider topic than this thread...)
The answers are all useful, thank you. There was just one thing I wanted to clarify. Vishwa said:
"Yes, its exactly the same code and driving data , only spelling is changed which included replcement of u with ü"
That sounds like it is answering the question 'Do "Turkish_Turkey.1254" and "Turkish_Türkiye.1254" behave identically?', which I had already assumed to be true, but I was actually asking 'Do ""Turkish_Turkey.1254", "Turkish_Türkiye.1254" and "tr-TR.1254" all behave identically?'. It sounds like the answer is probably yes, but the mention of "u" vs "ü" implied a narrower answer than I was looking for... It's important, because we're proposing to translate to "tr-TR.1254".
Since no one has come forward to test the patch I wrote on Windows, I think my next move will be to try to make a build option that can also do locale name renaming on Unix, so that I have something that I could test myself and push for the next release of PostgreSQL which will be in October.
One open question is whether we should ship a translation file ourselves. I have heard two opinions: Tom Lane proposed in this thread that there should be no file initially, we let the user figure out what to put in there. Magnus Hagander proposed at the pgconf.dev conference last week that we should ideally ship a complete translation file and maintain it over time, and it should be installed not in pgdata but rather in the install directory. I am not personally able or willing to maintain such a file, I'm only offering to supply the C code to read it and do what it says, but perhaps a group such as the EDB Installer maintainer group, or at least someone with a vested interest in PostgreSQL on Windows, might like to own that job.
view thread (73+ messages) latest in thread
Message-ID: <PSAP153MB0439B5E53B80F6D4EF37AD49BDF92@PSAP153MB0439.APCP153.PROD.OUTLOOK.COM>
Permalink: ../PSAP153MB0439B5E53B80F6D4EF37AD49BDF92@PSAP153MB0439.APCP153.PROD.OUTLOOK.COM/
Also on: postgresql.org/message-id/PSAP153MB0439B5E53B80F6D4EF37AD49BDF92@PSAP153MB0439.APCP153.PROD.OUTLOOK.COM
copy link · copy postgr.es
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-bugs@postgresql.org
Cc: pandeyrah@microsoft.com, v-haiwang@microsoft.com, thomas.munro@gmail.com, Vishwa.Deepak@microsoft.com, Shawn.Steele@microsoft.com, amyw@microsoft.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org, gulatishweta@microsoft.com, nawalashish@microsoft.com, targetdev@microsoft.com
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
In-Reply-To: <PSAP153MB0439B5E53B80F6D4EF37AD49BDF92@PSAP153MB0439.APCP153.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox