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 1vXb8A-00G8VB-2B for pgsql-general@arkaria.postgresql.org; Mon, 22 Dec 2025 08:19:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vXb89-00DkjB-05 for pgsql-general@arkaria.postgresql.org; Mon, 22 Dec 2025 08:19:01 +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 1vXb88-00Dkj2-24 for pgsql-general@lists.postgresql.org; Mon, 22 Dec 2025 08:19:01 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vXb88-001vtv-00 for pgsql-general@lists.postgresql.org; Mon, 22 Dec 2025 08:19:00 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-477632d9326so22072645e9.1 for ; Mon, 22 Dec 2025 00:18:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1766391538; x=1766996338; 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=U518KclfP1RQx2lM7sVwEWyOE4SFKavy69OBFyE00yA=; b=oS+OBOspzGYw5UDTkSMuHQP2WCO59Nqt+4TFUjNlXMKIKnfCunVCdRVd7zZD6sdgnS Fit+pU8VkOtBjA4uLY40s1OmuGZEAs+KiL+4i3Nuif/DNudUARQueIx+XB/ZYkka5WlK X9Ov5sJoGBgQSBrkHIB6l64wNNVsH/RMy6tBId+eD9Ol0VOzIY8XeUyaKTJ60Cqg2yv0 +DePCVpX76PxGwC11vBItH0mdrPMbvJL1pwqRDXSSLFoEDrl8/N1tCIE+YhFULRW6Tfk JJLvBfIpDKHkmXSfTms0zcQn3YKA0lwChx8KE+1SSoqTLckLmiERAaCeqpDLYk+z/K71 dq+w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766391538; x=1766996338; 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=U518KclfP1RQx2lM7sVwEWyOE4SFKavy69OBFyE00yA=; b=WhXG+WYyZT517rY9FJr89rr7X9k8/eEsD0ex1VW5rTEn2SS/ajm617SI6q8G5Ah1YH Wu8vs1XY26cXGesTJp3pt9BU4vtufm3eJm0M/KkcpTQ0q2qzf1Ase9YNUJnirzyEmiGQ yuzthOCBS0epbl2iQl5q18L27RWjvzHrwp9QzCpyymHqKReJRvljBg4psYcbNQqMm3N7 XSNhmRPewmQHo7J+4Ph87p/Nb1HA7f/mjyBpjB1Hy6ghUqzsaC3fRQ91dgkXm+5n3MwI 50WsksW+SHAcHWlMUumOr4wt6ocRNXqRlq/aeDpFzK2InQjzZB5RWOUdqGhLUdeOWhPc 6N9g== X-Forwarded-Encrypted: i=1; AJvYcCV8yH+s7oqJ0iuS9820BW7/Tl124mnWo0zrOs7fhD9JyW/sy+WFsrrZlvQPCybaNQjLhep7mrxJ70yrCCyp@lists.postgresql.org X-Gm-Message-State: AOJu0YxyntmPU+tXugSo1STNir2XZ19DpfKw19R/372CqdGv/pGWIG20 r457r9245Rv+5Ls7MHaRiQI4spuELX/VIdZJc4gQ5nViF85uQIkHZZpECO50Hclm3kY= X-Gm-Gg: AY/fxX6biFYkANNLuPlA1dsx/+IlWAlnTYHmPQQVf9nwgrr1IcXhItfCJvuPh4lNmuL v4XGvhTZjAfZPA6eKspiTdNjKE6SejWt7tfpM7Is1CMsAE53YvRGfUM1T0he0bqwLBV0cqawd8q 2kVcPcZ30HBMj8IR6g4XsGY8EISDuI+L8T5aPM68o9T3nAVqabVYrmYQ3iQncQ7zfGfX9lygzsU YI5okWq3nfRNmObJ1IxneYU48+dBzkVYDeCG88KyxEYDgsL4BbVNHskGq/aLX11jEsHojUqLLrR 3WDQ7L93QoDGvOf2zTxKvhxnlI/MKJPG9kXOB7TtJmgfjW/x80cLbQN9nJF17Ish+IEhzDKr9e3 Oc6DXdDAurNMZtl6lcQeuhHgS0d6Q7OIH7F+n1cG3/BeCX/UM/RnlF48ovdMVFDQvIDl8GSY/+y y/M57YLI4i6aRMdRo703sLAEZoC4aaqDiiY6exwuJX X-Google-Smtp-Source: AGHT+IHzj4SIjMhnDdXWYpOGgtKtSW1XdTMujw0auhYgY/fElx2SiYWrMt+qSx+BFS4dE+VAgdHQkg== X-Received: by 2002:a05:600c:4e90:b0:471:1717:411 with SMTP id 5b1f17b1804b1-47d19595f54mr106048205e9.24.1766391538001; Mon, 22 Dec 2025 00:18:58 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:9cab:32f3:f835:77a9:5bbe]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-47d193d4f09sm177787765e9.12.2025.12.22.00.18.57 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 22 Dec 2025 00:18:57 -0800 (PST) Message-ID: <61e006772d8f0d8fb461d2da59b4f31ca22f4733.camel@cybertec.at> Subject: Re: PQexecPrepared() question From: Laurenz Albe To: Igor Korot , Tom Lane Cc: Adrian Klaver , "David G. Johnston" , "pgsql-generallists.postgresql.org" Date: Mon, 22 Dec 2025 09:18:57 +0100 In-Reply-To: References: <2547700.1765940917@sss.pgh.pa.us> <9a0ce31a49f149d8d982d2b359095560655f781e.camel@cybertec.at> <699b6649-6841-48a7-8182-b92d28a70ff7@aklaver.com> <138367.1766337436@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 Sun, 2025-12-21 at 11:44 -0800, Igor Korot wrote: > Adding following code: >=20 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 SQLHSTMT stmt; > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 SQLWCHAR value[25]; > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ret =3D SQLAllocHandle( SQL_HA= NDLE_STMT, m_hdbc, &stmt ); > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ret =3D SQLExecDirect( stmt, L= "SHOW client_encoding", SQL_NTS ); > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ret =3D SQLBindCol( stmt, 1, S= QL_C_WCHAR, &value, 25, 0 ); > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ret =3D SQLFetch( stmt ); > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ret =3D SQLFreeHandle( SQL_HAN= DLE_STMT, stmt ); >=20 > the value of the "value" variable is still "UTF8". The ODBC driver comes in a "unicode" and an "ANSI" flavor. If you are using the "unicode" driver, it will always set the client encoding to UTF8. Yours, Laurenz Albe