From: Tom Lane <tgl@sss.pgh.pa.us>
To: Igor Korot <ikorot01@gmail.com>
cc: Laurenz Albe <laurenz.albe@cybertec.at>,
        "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: PQexecPrepared() question
In-reply-to: <CA+FnnTwtd-YJo5zp3obQer3qfbacg5s-4b3+5PvUkL3e+5Eh4Q@mail.gmail.com>
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> <ebaca1066dfdf567d158fc48dce86a6fcc132988.camel@cybertec.at> <CA+FnnTz5tcJEL12ir1nxe9q75rxaAdfBtcFUNiD4R5gW_JR23A@mail.gmail.com> <CA+FnnTyYBNwbzFs5GqO+SMg3g60jPTsnmFwTV=_s_YboGo-68A@mail.gmail.com> <852dee881b6cc82b9d4b51d69d48c415e2a87b4d.camel@cybertec.at> <CA+FnnTwtd-YJo5zp3obQer3qfbacg5s-4b3+5PvUkL3e+5Eh4Q@mail.gmail.com>
Comments: In-reply-to Igor Korot <ikorot01@gmail.com>
	message dated "Sat, 20 Dec 2025 21:33:23 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <61120.1766295563.1@sss.pgh.pa.us>
Date: Sun, 21 Dec 2025 00:39:23 -0500
Message-ID: <61121.1766295563@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/61121.1766295563%40sss.pgh.pa.us>
Precedence: bulk

Igor Korot <ikorot01@gmail.com> writes:
> I added the following code in my app:
>     res = PQexec( m_db, "SHOW client_encoding" );
>     auto value = PQgetvalue( res, 0, 0 );
>     PQclear( res );
> and the value of the "value" variable is "UTF8".

Okay ...

> The exact error message is:
> ERROR: invalid byte sequence for encoding UTF8: 0xdf
> CONTEXT: unnamed portal parameter $1
> on the INSERT.

client_encoding governs both the encoding that the server will
send, and the encoding that it expects to receive.  You are
sending a parameter string that is not valid UTF8.

			regards, tom lane