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 1vWG7t-00G9UV-2P for pgsql-general@arkaria.postgresql.org; Thu, 18 Dec 2025 15:41:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vWG7s-002nvU-03 for pgsql-general@arkaria.postgresql.org; Thu, 18 Dec 2025 15:41: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 1vWG7r-002nvM-2C for pgsql-general@lists.postgresql.org; Thu, 18 Dec 2025 15:41:12 +0000 Received: from mail-oo1-xc32.google.com ([2607:f8b0:4864:20::c32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vWG7q-001RA5-0L for pgsql-general@lists.postgresql.org; Thu, 18 Dec 2025 15:41:12 +0000 Received: by mail-oo1-xc32.google.com with SMTP id 006d021491bc7-657c68a08a7so392437eaf.1 for ; Thu, 18 Dec 2025 07:41:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1766072468; x=1766677268; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=kHey9r4PPI0Z0iqTBojabFL+Mri7kuQKRm8Tj9XVXT0=; b=EQotT0SAKf7F156I94iTCTZ8S+DcBkxWdw9AH/bRo7QDQrTxlcH5IrU4/f3D4gLyHd Q5O+59gzw3PL5NVOyYt0KIDflKdsF3tywDSbC210zAELAgwLvpSn1gaIpkc3SSYP0JGy W6u+Dt7dfwp1QyXYoS068Ux35MWLOlWTCFMO0B87uQOBR9CUs7LJzO9EirGHz41kbfF7 p3XLXOlW/bGarvh7KkOvHBBB6oQtQSZSeN68gg87YCM/kYBwPGBa+57F6aD5kVdJGGSh UiWmShsSrcrAm9/V1Age7H54L1/pCXf/LAEpZDWRyh5lRdwJ8mkWi1kR3QFLf6bW6FYg J2rA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766072468; x=1766677268; h=cc: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=kHey9r4PPI0Z0iqTBojabFL+Mri7kuQKRm8Tj9XVXT0=; b=VdIikcIi4c0RROwJAVyQd0xR/0X5bbaTXJ37aOFZVHHEHTPc2SV6gi1sEoxozT/DyN 7I6KhdsQmk1RQhXdLwGjI72IJPsVmvYrCCviPWDF0krZ72uLlZ6lE+z3hFIBAXFxTKSa S6lJgLIf3Z9EiSiln1QQDOPPYGW9el3lVyXkYYICiRvweNaOYYKbqnzs+ZSO5NDLNwB/ WZPq2bYZjgfNQ56w6iAjY6Qm05bSQ2fYbiom1JwanODMo58NjKuIz8zmYdD/kNTiyLKt gL+6yym/hoUh2GMGU7krsAnF+5H/lfgWvqpzYDxXgrdFMCfsb7mNx6Zp6+YQszUV+kMu KYYA== X-Forwarded-Encrypted: i=1; AJvYcCULj9mlQE99m4oSBfSO5Mn37mT08WkJj6Q2IGLRHrxpbc2AsfsMwaPGXDsFs250SnKn7nVnd9f5uFcXxzVD@lists.postgresql.org X-Gm-Message-State: AOJu0YzhKsqX1dVU2F9TRxE73LHkfF6aWJqmLkSB9whKQp222Ry0giYp pscOlhIPv6qQM5yVfgjTuKjpQQCBr1q8Zh2JT7/vyS74BLzXu7xyfWrMCTGR/eO+ilg4c3SPTZz ZkfmG/fz1gDufHCOc1Goo9vSfjPNe1WY= X-Gm-Gg: AY/fxX5f9wxoiDATQwAkjOSVct4bqxLmi8HxurzGWXMHMqe/Jp4LEhHh23H2rMOsMGx 1nZtpkaCF1eyAHU1cP6Tb+L0G6hSzzE39KCQYA+VCjQYMeF7Cjt0tJYtkz7eOFMZFWj8URRlnXA 02xY9OnHbQrNmQZrEDGfhJo2hX2KhpgY7i8o59SPeDku3hflCtFxP48Ec7FqPaO+YzRDQCv1jSV jH/xub4syANnEr1TT3mU7YuVft5T0Pyr5Gk61lU2+KwvsllBLyKGmu+I2W/sbS284gAcInK X-Google-Smtp-Source: AGHT+IGJJgva1oSKd15RqOcnirHj79YoauR59UVeuXpPto5BM9Asur3TWuKctZfyidUHmrdYfK038r2hyvwCrLeogE0= X-Received: by 2002:a05:6820:168c:b0:65d:c79:8b87 with SMTP id 006d021491bc7-65d0c7990e1mr201765eaf.5.1766072468167; Thu, 18 Dec 2025 07:41:08 -0800 (PST) MIME-Version: 1.0 References: <2547700.1765940917@sss.pgh.pa.us> <9a0ce31a49f149d8d982d2b359095560655f781e.camel@cybertec.at> In-Reply-To: From: "David G. Johnston" Date: Thu, 18 Dec 2025 08:40:31 -0700 X-Gm-Features: AQt7F2q3nDZhIJnG92g7D222ypSl7YlRnJ5T0_w2cijzhmCOuavgDsbuh8QDFQI Message-ID: Subject: Re: PQexecPrepared() question To: Igor Korot Cc: Laurenz Albe , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000001ce81306463bca21" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001ce81306463bca21 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Dec 18, 2025 at 8:20=E2=80=AFAM Igor Korot wro= te: > 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? > This day in age, probably UTF-8; which is what most servers are initialized using. If you aren't having issues with encoding I suggest you just take for granted that the defaults work in 99% of the cases. If you are having issues, share the details. David J. --0000000000001ce81306463bca21 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Dec 18, 2025 at 8:20=E2=80=AFAM Igor Korot <ikorot01@gmail.com> wrote:=
Imagine following sce= nario:

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?

This day in age, probably UTF-8; which i= s what most servers=C2=A0are initialized=C2=A0using.=C2=A0 If you aren'= t having issues with encoding I suggest you just take for granted that the = defaults work in 99% of the cases.=C2=A0 If you are having issues, share th= e details.

David J.

--0000000000001ce81306463bca21--