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 1vXCIQ-003aQ6-2Y for pgsql-general@arkaria.postgresql.org; Sun, 21 Dec 2025 05:47:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vXCIP-00BE3x-0e for pgsql-general@arkaria.postgresql.org; Sun, 21 Dec 2025 05:47:57 +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 1vXCIO-00BE3o-2a for pgsql-general@lists.postgresql.org; Sun, 21 Dec 2025 05:47:57 +0000 Received: from mail-oo1-xc34.google.com ([2607:f8b0:4864:20::c34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vXCIN-001rq0-06 for pgsql-general@lists.postgresql.org; Sun, 21 Dec 2025 05:47:57 +0000 Received: by mail-oo1-xc34.google.com with SMTP id 006d021491bc7-6598413b604so1910797eaf.0 for ; Sat, 20 Dec 2025 21:47:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1766296072; x=1766900872; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=1KinLkZi9ko7T/98S7mMlQ4t/7RkL+oQ/LQXRlW9iuU=; b=BiW5Qt7MRkntb+0OU+YAK5lTbyj4gwfEwNmL7GjR+Nxttdg/a7yJvhn6sX7lrX4Yft q3LzQH4etZty7zGJ1HLimYKLiV61Q3KkP7H48UllKZO+6VJt7L7hhFCOQw0r0sxjnIjE 1O/p9t7HTWQTjLaBxmmK1eFj02H7y4qwRSOMoCkhPhr0NJsniRK4XMULpDbLjkMVN1Sp 4nyQRyi4/cj/UINXXVR91452Z9n9jEHrtiwm7JAWxicSUJDrgEfqEQOa6REpfvKwVqpH 50xLCo51k0YC534M8Le/LJpq6UXDLsrmfXa65sh2yC7tufxDt53iXU/U7XjVe/zHB03m Uujw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766296072; x=1766900872; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=1KinLkZi9ko7T/98S7mMlQ4t/7RkL+oQ/LQXRlW9iuU=; b=cKH19xTAkADfJ5HWbVUmosOZioaFnUFX0Fl5Jz38Fl6pEKXierDGXbzfXeYoor2Zsy qg1EgqXErioMX1l8309r0pu7ClFWZIy6oHaG9nOSIVdAdhWWzQ+0MZmqgS9jk8ioESf4 NgMflqgc69InEUTtxoAFJn6x87fzYkbFt5dSKD3oTE0MRLCx/fM6Sfzh44lp0bZZLIhQ F1/+DBovA3lW2mchkvhOmfBrpltSoGumchu2Wh/WSWdsCYrYetBWaPtLJiM1tS04txBM dXuhPCFTHiQbss6JjHvNKA2j9fi+mJ6PJBZ6PFAlAUCPhlNWpe/PrFK4S1a958yATNlV 1EOA== X-Forwarded-Encrypted: i=1; AJvYcCU0jQM9adFk1dR6nJA2IkwOQeLFrq+EYvPKcrfSlyx5wlakYUiFiU8UbceDe07wVgt/1v9acUCxrZy6lCMN@lists.postgresql.org X-Gm-Message-State: AOJu0Yzo9WUYlZF/s/CbESrHAH+Vq/6QxNyGYIkLC24U/bk5vTj25x54 DHOSN1+qrIzvHAiU+TL9OsMGqzsB4wmsLkZrZ5cs+3ouLKtnLzK99sqGxI3f0LFR/+w13raao9H ALMSLiJVyw2Mm8dqi0M0/5IaO/5Px89k= X-Gm-Gg: AY/fxX4TphJGELHGVmm5PDxPp4tEMkv1aWBWQa4+ACD05FdsYtMHXHGonM5rUnvUM8W B8WNHd0SvqjmLVljhslFrn1p7XHIRIPi4HfNIxfmeQYbQJWT3dDsqxSfxnKEofb1SfLm/HXqmMK 4Knfp4lTFfRXOYVAhP0wWNSN6K2aXL/jaeiggKsrKKPyumIQhXnVK1qgqEYYAjsKzqk86+0hd+o OSSoHBfKvcBRZOhIg7C3dBOooAOIKIhyXSa4BFe0b1q0ar8r/qSFleEUrrtiSQds5bbe8QG X-Google-Smtp-Source: AGHT+IF4lic8p8ars9alHW101xE9nUI5E1lHjxt0V91uuP4NLohoK1TxUBwH38K3CNRAaU2a0nKtGQ/XtqIjjct3yaQ= X-Received: by 2002:a05:6820:162a:b0:659:9a49:9069 with SMTP id 006d021491bc7-65d0ea9711amr3175536eaf.52.1766296072521; Sat, 20 Dec 2025 21:47:52 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:d89:b0:605:66fc:280d with HTTP; Sat, 20 Dec 2025 21:47:51 -0800 (PST) In-Reply-To: References: <2547700.1765940917@sss.pgh.pa.us> <9a0ce31a49f149d8d982d2b359095560655f781e.camel@cybertec.at> From: "David G. Johnston" Date: Sat, 20 Dec 2025 22:47:51 -0700 X-Gm-Features: AQt7F2rliMkllHC62S-5XBVKhwBAAf58cdrmIDCIhiQpR_nw3crFS5QC859RUMw Message-ID: Subject: Re: PQexecPrepared() question To: Igor Korot Cc: Laurenz Albe , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000f88cdd06466fd9dc" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f88cdd06466fd9dc Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, December 18, 2025, Igor Korot wrote: > > Using my setup above and assumng my Win locale is en_US.UTF8 This seems like an incorrect assumption. The server is expecting UTF8 yet you are passing it data that is not valid UTF8 bytes. I infer thus your Windows encoding is thus not UTF8. Suggest you make an even smaller, simpler, and self-contained reproducer and include how you are executing the code. You=E2=80=99ve not provided su= fficient detail for someone else to debug your problem. David J. --000000000000f88cdd06466fd9dc Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Thursday, December 18, 2025, Igor Korot <ikorot01@gmail.com> wrote:

Using my setup above and assumng my Win locale is en_US.UTF8

This seems like an incorrect assumption. The server is ex= pecting UTF8 yet you are passing it data that is not valid UTF8 bytes.=C2= =A0 I infer thus your Windows encoding is thus not UTF8.

Suggest you make an even smaller, simpler, and self-contained reprod= ucer and include how you are executing the code.=C2=A0 You=E2=80=99ve not p= rovided sufficient detail for someone else to debug your problem.

David J.

--000000000000f88cdd06466fd9dc--