Re: [EXTERNAL] Re: BUG #18707: Installation issue

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
Cc: PANESAR Gursharan <gursharan(dot)panesar(at)bnpparibas(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: [EXTERNAL] Re: BUG #18707: Installation issue
Date: 2024-11-20 22:41:29
Message-ID: CA+hUKGL3W_nXk0Si9P=smGq5NHUxu4HASJwZ+gq80SHMF0tWpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Nov 20, 2024 at 12:15 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> Idea: could the Visual Basic program actually be using a different
> ACP, not the one in the registry, due to some explicit locale setting
> or environment variable somewhere? Would it be better to call
> GetACP() instead of that registry lookup[2]?

Guessing harder, in more actionable form: something like
LANG="fr-FR.UTF-8" might be enough to break your script, if VB itself
or something in your VB code calls setlocale(LC_ALL, ""). I have no
idea if it does, but if so, that could change the ACP for the process,
I think. Perhaps Gursharan might like to check whether LANG or any of
the LC_ is set in the environment where the installer runs, and if so
whether the value implies a codepage that doesn't match
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage\ACP.
If so, just as an experiment, changing the variable to something with
a matching codepage (I think for example "fr-FR" without suffix
implies 1252, traditional encoding used for French) might work, just
to confirm what's happening, or kill this theory :-) And if that's
it, and if GetACP() is the solution, then: the intergoogles told me
that you should be able to 'Declare Function GetACP Lib "kernel32" ()
As Long' to access it.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2024-11-21 00:42:19 Re: Can not open Postgre SQL 17.1 after update
Previous Message Nathan Bossart 2024-11-20 22:36:44 Re: BUG #18711: Attempting a connection with a database name longer than 63 characters now fails