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 1vWV8q-002HLQ-1D for pgsql-general@arkaria.postgresql.org; Fri, 19 Dec 2025 07:43:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vWV8p-006rR7-1C for pgsql-general@arkaria.postgresql.org; Fri, 19 Dec 2025 07:43:12 +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 1vWV8p-006rQz-01 for pgsql-general@lists.postgresql.org; Fri, 19 Dec 2025 07:43:11 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vWV8n-001YyQ-04 for pgsql-general@lists.postgresql.org; Fri, 19 Dec 2025 07:43:11 +0000 Received: by mail-wr1-x42b.google.com with SMTP id ffacd0b85a97d-42b3b0d76fcso872128f8f.3 for ; Thu, 18 Dec 2025 23:43:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1766130188; x=1766734988; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=ODDaERXoKqkdt12JZE+vxu956wu2IVjAyBGzPt0aY08=; b=KnC2CGI7cdHhIm+fewG5iLchDUuyv2n3UCyXM/CD/oEugylP5zBbGqBfOWj8fO1U4D SwArTNLH/jvjTTH1cAxPxGT+cU9y9EOpJvYeE2ObqAknBTUaVIWjjd5QRuf50LPaUIKS kpwp91v++gaKOwgcJ5QrXlQ6p9BPr1mGSP/9Uzqnqa2PKNghqIE3arFc0kHBcqIrSJre SaPJctnMn3AfhY5XfMpEt2Ae8yKUd7x5ay/hHFZsNduRYmDWrgLIyZ7gbdl9Kt+wWNgd JmyDWpe8rUjAkUfWVFcZMatGD32ZMFW0NQy5dyvFGU2bTMvHrSPjzJlB0xXN01ekY+kk uuMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766130188; x=1766734988; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ODDaERXoKqkdt12JZE+vxu956wu2IVjAyBGzPt0aY08=; b=tpTKI+vBM3kXGgHCQMcq8fL3n8USGJ8xcgd84o7sy6HVBRf4cMC0qFae9sgFDsh6mz Fe8TiUlRCzsP3PWf2Syx25GWIwHtCwGZv9HCXNJ68HCTpw7WaCNCFm15YeM4Sbf9BIjv SUNWu7Z0vzE3kM/FJUeDerDSnmp6+06IvL5knfywxOCV/qLbo3uiHm02kw+ZyYem7FXp fPI1cDqtKZNGt2gcL4c+kJiUetNp/dVk7xdrM1PbUTOBh6mVE+g/T/7AFEYcUs/YmWih oRpNI8I1w+znwXMS2JhszeytRgogTNsW/+b6ZZyoFDUcN173SuR64CV+OcRintKIRbgJ Dy8g== X-Forwarded-Encrypted: i=1; AJvYcCVjGY6VoxmL5CT9yijwHIw7xtt7424lNV7p5qoGgl0v59cO/V2GL1AhCQTyyt2Fg+H385uUonIYuHdzAV3O@lists.postgresql.org X-Gm-Message-State: AOJu0Yya/bDhnAKWKNobLTvcunHvNfaw0T8U3bGSKTWCDKOXZTq80w70 NPRERpcBJqOztWQkRKqpoHO94pEM7X3+uoUT3rLO2Az3m6Hn9LC2GgUpJS4udMwSnfQ= X-Gm-Gg: AY/fxX6xvbd3gYct1L+FyxeFPxCOX0TpFK7SSZ3TCM2+UUsOc3gIR0+dLXGb3Fbq8cn bldOduOCLx75VAQR+VwRwSAHqWyPmAvsyAD+10TFtwhIpsQXXUHYp2ZHsYDJvPE8xmpzyW0+6+3 CfOavqAPAgUmph466ql8D0DhYhc2Q4hZr0zuCiJvLvWJhwqtPoIQSLcAyOcvP1vnBzTsHoiCsPs 9/PJnQW3yhSh6cbNPGReW6t1hKHP5xCWUcvq6Jd+InIDGpDGQjNt3z8r9y58y3ZsIyMz3fwTuon qi/XUGzfG1EzZiZI5t9DiIGTSn+Qg7TkoGisYQQcBWO1mldfTNZgAvCl15eSgkUtGc6jjZawJSB orjaKfPA1E785qoCXiqDqminXFBEA3iTNzVZiSTYMfmdbPOyNWLvJHDOq8XqHhaUbKKFBvuW3Mu V3aEFnThSiC8iq9e7eCibreqB1Q2njhhbb1xDz7fWwHao= X-Google-Smtp-Source: AGHT+IEYRQGtNkkgFlfxO/XAKNQYHT6fV/fVyv7+nUAT2IBC2mcDAXKfRv7/SyTjXk/XXr9OERELjA== X-Received: by 2002:a05:6000:1a8d:b0:42f:a8d6:865b with SMTP id ffacd0b85a97d-4324e4ce0e9mr2301878f8f.24.1766130187597; Thu, 18 Dec 2025 23:43:07 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:4cf9:1875:33eb:6694:f468]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-4324ea1aef7sm3452517f8f.7.2025.12.18.23.43.07 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 18 Dec 2025 23:43:07 -0800 (PST) Message-ID: Subject: Re: PQexecPrepared() question From: Laurenz Albe To: Igor Korot , "pgsql-generallists.postgresql.org" Date: Fri, 19 Dec 2025 08:43:06 +0100 In-Reply-To: References: <2547700.1765940917@sss.pgh.pa.us> <9a0ce31a49f149d8d982d2b359095560655f781e.camel@cybertec.at> 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 Thu, 2025-12-18 at 07:20 -0800, Igor Korot wrote: > Imagine following scenario: >=20 > I have 2 machines. One is running PG server on *nix. Second is my app on = Windows. >=20 > An application starts for the first time. >=20 > 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 - otherwise, if "client_encoding" is set on the server, that - otherwise, SQL_ASCII Yours, Laurenz Albe