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 1vVkU9-0071VO-08 for pgsql-general@arkaria.postgresql.org; Wed, 17 Dec 2025 05:54:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVkU7-00ARW5-31 for pgsql-general@arkaria.postgresql.org; Wed, 17 Dec 2025 05:54:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVkU7-00ARVv-1y for pgsql-general@lists.postgresql.org; Wed, 17 Dec 2025 05:54:04 +0000 Received: from mail-yx1-xb12c.google.com ([2607:f8b0:4864:20::b12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vVkU7-0015yf-0g for pgsql-general@lists.postgresql.org; Wed, 17 Dec 2025 05:54:03 +0000 Received: by mail-yx1-xb12c.google.com with SMTP id 956f58d0204a3-640c9c85255so4966228d50.3 for ; Tue, 16 Dec 2025 21:54:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765950842; x=1766555642; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=BX7dimBs5y6BHjJjGNDY4557/9p8GwKF57xfoFZVRPQ=; b=gmfYdyMSPxU8VNTlRaVhIIyXUaP+ynGPf3N4ys0pdne5O73c3j8ZUCog05g6H9IV/3 UyekRDjyFLpu6NeEhci3gQTFM3FuCiAiXNAUXzhN5wUSmnjpvPWSKNGGM5WDiB80AR8C PaaZsgTrHQyHQUNscDiHMBXHVcmuQzVWmUNmkhu8BFdE1hMXr3K/X2iLyK0/n7UqTXpN gzxe1h7zEMIk9M+SSyvPdEIgUbboCSFFSVUeYJ7ghfF4FJBXq6Bjny/1hwlbbmKPh0AU a/yo+puIMK4cQYEuxCfSdHLCY1nuxAVG3LmLb3bptTipt4GCjr74t6YZ0ep7+efiVk3F 1jXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765950842; x=1766555642; h=content-transfer-encoding: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=BX7dimBs5y6BHjJjGNDY4557/9p8GwKF57xfoFZVRPQ=; b=NXI7ih9/KHaF/eR46WSL5JtwBKC70v63oWcAX1ZSv4iRu0B9flQm8cVkij0bL0cdi0 HmLHI8T88FCiyEDlE8h9odOEJ4L+IFlbSZ2IB9zchuo44nfuijF/wGCTTB1NUczZdA88 gA5voxMgeGz0miQgzSXyJHgjegO2zF8SC7eVh5h+U4i21T/GHnzLPSQyDIhgMQiOE00Y yLwLtTf7gOZwSCnT+fdRV9iewTjAV2vlshhQJ6f+BMazlAyg8bG9EhrDx5Wv1PQPm7I7 XjfAD9T0zpqutMRbulVD9AP7gBN3AB/iFV1cE0IAQBkDHrck/e6cH8gwtUBKbJPFS+Di r3Aw== X-Gm-Message-State: AOJu0Yw4m4MYUJxCU5H3BJFBOzFLrQXWuhqJUGSKoayXHG5TyYHShi1x P+yv5ggt6j+BCXhdhp7c4HghmtXWujOLOj9XrcGSeSVKEEp9jQXWC/a5+vUWX6H8IhvdcKr+FvU nbWMd5On4c1iLmOISJQ7j2pypUYuEmHQ= X-Gm-Gg: AY/fxX6QGN306Np2tya0f+Eo8jUQ0MUqznMyWMOXQNS4grblSU5ruNt2zHEGfDN4asC bemDf5UXj3moaIyYHRp5ZFC7Bc14Ng8M3RiwoRSeR5K9C82gZjn9TAbNGVyq2ItFXWC11mtR7+l FZa3EQq7W1Wt+QUELWR3DmQKn2AlAFWFtPXgv+/qVJG79NHh06QHDnumIBaGEh7t60n8ag6yuMk MRPWfckhwPUYK6yzzX3AkGxfaBPL5Wvlweuo2P/mXX+Tahld6AV9WMXfcjz9YerJZWlu9byCBLL 9e582T8ZYPdovUf+pa/i8Q5eZxY= X-Google-Smtp-Source: AGHT+IFxxrbDY6oKzOtkhB2QoWuu5wIvgl0FSygLcdoi002pWsBwLVAElvKmM98E6lbOrYgoO+RmeIkBq7UVys/Onbs= X-Received: by 2002:a05:690e:130c:b0:63f:c019:23ee with SMTP id 956f58d0204a3-645555e7c58mr12314020d50.21.1765950842322; Tue, 16 Dec 2025 21:54:02 -0800 (PST) MIME-Version: 1.0 References: <2547700.1765940917@sss.pgh.pa.us> In-Reply-To: <2547700.1765940917@sss.pgh.pa.us> From: Igor Korot Date: Tue, 16 Dec 2025 21:53:58 -0800 X-Gm-Features: AQt7F2rOVaShvsBOByiQrhdS7dUuJuzE2jhlIhQCTlwdhfRAkNqHv6f1jSV49RQ Message-ID: Subject: Re: PQexecPrepared() question To: Tom Lane Cc: "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thx, Tom.. Is there some default value for client_encoding? Thank you. On Tue, Dec 16, 2025 at 7:08=E2=80=AFPM Tom Lane wrote: > > Igor Korot writes: > > If I want to have strings (aka char *) as parameters fr the query, > > should I send UTF-8 strings or something else? > > They should be in whatever is selected as the client_encoding > on your connection. That goes for query strings too, and whatever > other text a client might send. > > regards, tom lane