Date: Sun, 21 Dec 2025 11:10:58 +0100
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: PQexecPrepared() question
Message-ID: <exzgttcvkt27rlddmioxcrxymzz4ks4lefwltwpl4d7sal6sc5@3ackekqorauo>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <CA+FnnTygjVvSmzTHnvteuL4KEC=0P_+mF8Kn84JtNGZWUGxpUA@mail.gmail.com>
 <2547700.1765940917@sss.pgh.pa.us>
 <CA+FnnTxO6kam9=mRonvsnUA1OxJxdDdQsj+ubdgFNNb9b3WMPQ@mail.gmail.com>
 <9a0ce31a49f149d8d982d2b359095560655f781e.camel@cybertec.at>
 <CA+FnnTzE34VJWR7xkymaKEwXiiQ8j3o03m0+qcQsRr2JkRQLwQ@mail.gmail.com>
 <CAKFQuwZaf2quGaqsGAj4+rVVCebOwU3JjbMUJPxxj6NeF_O_gA@mail.gmail.com>
 <CA+FnnTwZUo-ZRZ4if_ngXXkYgtOCsmMp1uFpsMFkG5AOmRxX4Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="67tlfyke26vjksrp"
Content-Disposition: inline
In-Reply-To: <CA+FnnTwZUo-ZRZ4if_ngXXkYgtOCsmMp1uFpsMFkG5AOmRxX4Q@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/exzgttcvkt27rlddmioxcrxymzz4ks4lefwltwpl4d7sal6sc5%403ackekqorauo>
Precedence: bulk


--67tlfyke26vjksrp
Content-Type: text/plain; protected-headers=v1; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Subject: Re: PQexecPrepared() question
MIME-Version: 1.0

On 2025-12-18 18:10:45 -0600, Igor Korot wrote:
>              std::wcstombs( params[1], table.c_str(), table.length() );

I assume that the C++ function std::wcstombs() is just a wrapper around
the C function wcstombs(). According the the C standard:

| The behavior of the multibyte character functions is affected by the
| LC_CTYPE category of the current locale.

So you need to know what your current locale is. You can find out
(somewhat unintuitively) by calling setlocale().

> Invalid byte sequence for parameter $1 in UTF8

So your locale is probably not using UTF8.

        hjp

--=20
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

--67tlfyke26vjksrp
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmlHx6kACgkQ8g5IURL+
KF1C8hAAmUgHlsgQ56LdwsfR3LZDjoRVRHrS9Awrm/8mdhZ1aqCCeCxfRyMnWnZg
4R7k9cuv8vLXA5ZgB2wGlbSBxYScLV0BmaxsNFETE+UsZqk/K2JsMskplqivXCeV
A7c2A3XlXl1fnILnO5FjDhEyfc8GvXnyczsnScFtHiEwW+tyx1dcXItVhA3imsT9
qXYy4Q4FVYUfBuC3CFaOtq33Xwv+NejtR8ppYNF5pI3mq90HmrymWKssZnF8AyQy
5SZwsN0p7A5kuUT1T1wY59A981r0RcswWUzGAI4O/59UADBDs3rTGBifySRpJrgG
dTjpPMFb+c32/BagqFyENoNaGKbxkDkUvZQ/dc8pAFqEFv8PSRQH+iw0DU+N3l96
XWC8Y00oHYHDAab5QOCuy95K8HbndkZ1AvBAL3rO0/XThnWTS9VNZdPlyCaWyQ0D
3rU8U5LF0sKvexjh2AlzCVb1CGQgRhtNdC0SoKcgeSd96+gJRwtRcaToCU93J8Bz
IbOJ4nq229EzbvquTw04Gw+SWeogzUWmj540Dpay5rZoT1ui5h9WjZCA7O6ldrLg
T1nqk+05Isde2iju+MKFcwBMnGG7tgo5cfOjz/MVob+blVnWaevg5u1g2KuO/XWK
y2SgxIZ+bHLkxHnM6CPLKnQz33tfafKn5Vo1BkQ8/cvfvrbHqh8=
=oy4d
-----END PGP SIGNATURE-----

--67tlfyke26vjksrp--