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 1vVm2L-007Zb9-1m for pgsql-general@arkaria.postgresql.org; Wed, 17 Dec 2025 07:33:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVm1L-00AxHx-1S for pgsql-general@arkaria.postgresql.org; Wed, 17 Dec 2025 07:32:28 +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 1vVm1L-00AxHo-0G for pgsql-general@lists.postgresql.org; Wed, 17 Dec 2025 07:32:27 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vVm1J-001BoZ-0S for pgsql-general@lists.postgresql.org; Wed, 17 Dec 2025 07:32:27 +0000 Received: by mail-ed1-x536.google.com with SMTP id 4fb4d7f45d1cf-6496a094ae1so8183684a12.2 for ; Tue, 16 Dec 2025 23:32:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1765956743; x=1766561543; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=dycJx/iddqZG9dm1W18RmowSh2+e3uLIAq7TkucU6qM=; b=g3ZDgFN4qNihLnrqP0CRGM3zne9R1ptYHsA9T+zBpHWEeeTJXSLYQ0xX0R5ukjmXZH cPk2UilvgNG/HwEN0t6Tjq1Wkhp6leW25gMBtEC9OENYCPfZV7viSVjmrwqfEAvp5Rw5 kx35i0xpTvy9prs6sLWAsLmgcct8iC+0yndJnn8CL1BCccQQnqNhcUyc8bl0P0BN3sBD +XpZumSH4W6SdLZomIfIE5P3gyEKljR9eYvvASU4WYTU0ZPdJEN26IaBDKfqMBOvDPUY m49ssJmXzu2pvjn6nV5i700OH/GxVBcMsXwHidDCJhMO4peOK6y/70qzj1umhF5R/Yz8 sWLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765956743; x=1766561543; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=dycJx/iddqZG9dm1W18RmowSh2+e3uLIAq7TkucU6qM=; b=CCFDacm86TPTQHKAz0+NLqejg0ADPFjhfHzrWLwwb922Z+f0/XxOluoSHPfDjADb5i s2fye5pOBPaceIxph+xhN14/JLcQsH+LHCqW9mcIca6qzfkadV2xaa13DoMEIkXFppoV 5AjMv+qkqOlG1glfiQYI6Hi5HD4GSqJowLnRZuQYvEu7OURMttrCViZFV4stztN1bxBT /Vsp9sNzD/LbLCbAE+99hV5pvoz+LqTC4DY81+5RViRFGMk3RgWrfpX6DQktSLj9zwbz apMNshcuFltS/JclnkuJ+d7IwCyDndbDNxTfMY/cX0Qvc/sF/WY4y8HZjcDaRkxU6JXC 4Rng== X-Gm-Message-State: AOJu0Ywjwh9zVKhlhC25xplXnFlTVCQs3sCCCe+D1BRIaQBkcd2oJPmH Mlkexih5xzDoqTKUjkFXJ0ImJCXY2A0ke/OvnYQjEdaUwyb/nv3SVFRizl69BwDFFJCSmI8biP1 t8AkD X-Gm-Gg: AY/fxX7RCm5Rx5qoIdOBTUe+aGwiicSj9jv74Wu0G8KRM47Sd+uAE47j/nA+3LwxhlJ G1TL/OHaNcCbFD/mydQ6Gf5tX4eMFpd/fCykGBY3QTAWqbYAzFPftIEI58BU8HZcScg6dp5LKcT ApWL8UXwA49SMDJK4VwPXmQ2pdb3ym/ow87JKBQvJM8YuAGbcfLAMfSwyHlnA/IJHX/ryuWu22k mJPqKJJxA7q0K7ZJ/RXpqcPAZN/lx1vEWyNi8Vvi7XEmBZt/tRctDK7qEHB6cgVKS5RnQB6dNRn rvyrK+7tDnsozY+Am80cZ/iGWzORO6y0rwAXJCLrXJB+dZB8gZl+a24iBcOUQEzOimakpvGuq69 ffXg7GFvTHxzgmQdl9IfE+/xP4GFGFTTHbqIpWwd1ArBmPHz/jVR+BYHG9t5NYceofMIjQihsQA +PITy9PlCRdzxbyu3BjseYXCyN4oQs6AaVWH/TwQ== X-Google-Smtp-Source: AGHT+IERdYxx1H+1U0b2jdjuqOU3CW8+CVjeiV6PCbZWX/fdUIGMKCBLAlpq3jy3gVPYHqBu14mFoQ== X-Received: by 2002:a05:6402:1d4e:b0:640:c9ff:c06a with SMTP id 4fb4d7f45d1cf-6499b159071mr18042091a12.15.1765956742622; Tue, 16 Dec 2025 23:32:22 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([41.66.98.235]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-64b3f56330fsm1613043a12.21.2025.12.16.23.32.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 16 Dec 2025 23:32:22 -0800 (PST) Message-ID: <9a0ce31a49f149d8d982d2b359095560655f781e.camel@cybertec.at> Subject: Re: PQexecPrepared() question From: Laurenz Albe To: Igor Korot , Tom Lane Cc: "pgsql-generallists.postgresql.org" Date: Wed, 17 Dec 2025 08:32:21 +0100 In-Reply-To: References: <2547700.1765940917@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2025-12-16 at 21:53 -0800, Igor Korot wrote: > Is there some default value for client_encoding? The default value for a client connection is whatever the parameter "client_encoding" was set to in the PostgreSQL server configuration. But that value can be overridden in several ways: - explicitly by setting "client_encoding" in the connect string - with the SQL statement SET by the client - if the client has "client_encoding=3Dauto", by the encoding set in the client's environment - by setting the PGCLIENTENCODING environment variable Yours, Laurenz Albe