Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vWfXs-0070z5-1i for pgsql-general@arkaria.postgresql.org; Fri, 19 Dec 2025 18:49:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vWfXq-008i5R-2G for pgsql-general@arkaria.postgresql.org; Fri, 19 Dec 2025 18:49:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vWfXq-008i54-18 for pgsql-general@lists.postgresql.org; Fri, 19 Dec 2025 18:49:43 +0000 Received: from mail-yx1-xb12c.google.com ([2607:f8b0:4864:20::b12c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vWfXo-001dwS-01 for pgsql-general@lists.postgresql.org; Fri, 19 Dec 2025 18:49:42 +0000 Received: by mail-yx1-xb12c.google.com with SMTP id 956f58d0204a3-64476c85854so1881096d50.0 for ; Fri, 19 Dec 2025 10:49:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1766170178; x=1766774978; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=w3of0/crxTU/mt0ACKuet9KY9h7fe+C8BdZN2u8gruQ=; b=Vkl52eMtM+1cI0aOVu5gyLmD6F/sMSv6UmDRZadTL8/udGna/+Sitf7h6y2rYak6Bg foIGmFxx9QDITItzYLTeJUi5Yj5fHfbuernOxq0yB2+4Ng8Xcb+sHv5ACVXlRQZ/SRTq w3wEAnLYXhnuSoX5v1AgVwSKiskhbOIxjBH7NzypinrjXiiW/Svkio/9H6YpUtDhGcKM JOFwltavIHwQnChEewPpnW6XRcoqG1mQhS8a2eUs5TPVIMtY+qi85mN6IchPY5L5i/mc 0Dxbo/xEI54dXeWvyPTXxKvnHQaG5GcHAA4l5D1exQbROjdHFfOb6NWYq747qDZIdROh s3pA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766170178; x=1766774978; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=w3of0/crxTU/mt0ACKuet9KY9h7fe+C8BdZN2u8gruQ=; b=GnOP1yl0F+woVyCzbSb3fiHbM8Bu5B1haK9GKy8beqJqKV8+1v8GpB3RRt1tW9oaOt JB4+HivOdzU/9WcYOXbP4+3Zl4CQM2K2J9X5K/N7mnCXhvZ8qAs2OhU3mYWeh7pknFzb r33nrqdLLVsB0H8oZKeOcfI5bOAm0qjXAr4FG0Tbsb45lnaYIfXxtU23d0hjLceVhqMI zShY2Voo1dyaDLmPGi52oShRikBbRWvEI2fYNeaTtYJNxFs38xnduRhOoTQOzQW5c0Ae fR5Xo7iQGMsRm0I83ipgdBmfnBqTBnkQbU1uFyNgSzMD9eROA5BeuHpCrDfiA/Yytk07 1InA== X-Gm-Message-State: AOJu0YxtY7Of0oYrrTcmM3UFLsPsnd9/opdZodjFgxkcOGVc5VnZIvp0 M9ZnpYFqwhKXYwcQm5acxiFinggKn8iseoF/0uD4+a1/kICxvO8o/WI5Xs7ZcA0b1HuSiPLlHzg 7RrHlta3ReuA0LROXbOBO421RsJRBkaenmxmL X-Gm-Gg: AY/fxX4d/p/eAOPe+BFAhidoxCya1jQcT8jRSzopHfY9+miyvnMyo/tloVzt2pSuuPW O1wgbPETAZc+bKLI8GoJrrFFfqyDdw43eoYwZyeUi47c9AQ7YFGxQu0mL2/rL6AltegN8ItNMGM Vl6SR/CjMYYvcwXG5WubjHjGeL2rUqRvWEeFoHrjrCMIE+TstekXzJCqHBMJJ8rt/j9LCa8AhX0 54URI/JT/2gvpCLx2rpnp+0wFslpveQImU+fSLgvJVOH+lCk7saRGgU/DR2kUxGaLIyLCreOapl RuNRZNTLDYGnNBcRG11aW5P6H8IX X-Google-Smtp-Source: AGHT+IFZKhMwHhloqU1IivSQv//oXmbJzlmgLlV8QFqgLZPFj30FtXwRCUESKpqecbZR1hN+o4E1DrTw4UrKsYhU92U= X-Received: by 2002:a05:690c:c83:b0:788:e1b:5ee6 with SMTP id 00721157ae682-78fb40e3f6fmr73983237b3.70.1766170177716; Fri, 19 Dec 2025 10:49:37 -0800 (PST) MIME-Version: 1.0 References: <2547700.1765940917@sss.pgh.pa.us> <9a0ce31a49f149d8d982d2b359095560655f781e.camel@cybertec.at> In-Reply-To: From: Igor Korot Date: Fri, 19 Dec 2025 10:49:26 -0800 X-Gm-Features: AQt7F2rNsPx93Vnz_FhIBny2kVip8JO71q5G-uyIrtvVD543d9owvJJ-t3UPS8M Message-ID: Subject: Fwd: PQexecPrepared() question To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000e47a80646528ac2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000e47a80646528ac2 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable ---------- Forwarded message --------- From: Igor Korot Date: Fri, Dec 19, 2025 at 9:17=E2=80=AFAM Subject: Re: PQexecPrepared() question To: Laurenz Albe Hi, Lauren=E2=80=99s, On Thu, Dec 18, 2025 at 11:43=E2=80=AFPM Laurenz Albe wrote: > On Thu, 2025-12-18 at 07:20 -0800, Igor Korot wrote: > > Imagine following scenario: > > > > I have 2 machines. One is running PG server on *nix. Second is my app o= n > Windows. > > > > An application starts for the first time. > > > > What is =E2=80=9Cclientencoding in this case? > > If I read the code correctly: > > - if PGCLIENTENCODING is set in the environment of the client executable, > that No it is not. > > - otherwise, if "client_encoding" is set on the server, that I guess I is. But what is the purpose of setting client encoding on the server? It is for the client Thank you. > > - otherwise, SQL_ASCII > > Yours, > Laurenz Albe > --0000000000000e47a80646528ac2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

---------- Forwarded message ---------
From: Igor Korot <ikorot01@gmail.com><= /span>
Date: Fri, Dec 19, 2025 at 9:17=E2=80=AFAM
Subject: Re: PQexec= Prepared() question
To: Laurenz Albe <laurenz.albe@cybertec.at>


Hi, Lauren=E2=80=99s,

On Thu, Dec 18, 2025 at 11:43=E2=80=AFPM La= urenz Albe <laurenz.albe@cybertec.at> wrote:
On Thu, 2025-12-18 at 07:20 -0800, Igor Korot wrote:
> Imagine following scenario:
>
> I have 2 machines. One is running PG server on *nix. Second is my app = on Windows.
>
> An application starts for the first time.
>
> What is =E2=80=9Cclientencoding in this case?

If I read the code correctly:

- if PGCLIENTENCODING is set in the environment of the client executable, t= hat

No it is not.=



- otherwise, if "client_encoding" is set on the server, that

I guess I is.
But what is the purpose of setting client encoding on the s= erver? It is for the client=C2=A0

Thank you.



- otherwise, SQL_ASCII

Yours,
Laurenz Albe
--0000000000000e47a80646528ac2--