MIME-Version: 1.0
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> <CAKFQuwYSM2xMxX+v8LAhJFG3kB1O-VBtV3eo3fj0ag3rGJ=ehQ@mail.gmail.com>
In-Reply-To: <CAKFQuwYSM2xMxX+v8LAhJFG3kB1O-VBtV3eo3fj0ag3rGJ=ehQ@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 20 Dec 2025 23:01:38 -0800
Message-ID: <CA+FnnTyn8FoYk-M9MJJLebJPRfBhS_Tv89ecwifn_eC=E5=VnQ@mail.gmail.com>
Subject: Re: PQexecPrepared() question
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTyn8FoYk-M9MJJLebJPRfBhS_Tv89ecwifn_eC%3DE5%3DVnQ%40mail.gmail.com>
Precedence: bulk

Below is my select statement:

SELECT t.table_catalog AS catalog, t.table_schema AS schema,
t.table_name AS table, u.usename AS owner, c.oid AS table_id FROM
information_schema.tables t, pg_catalog.pg_class c, pg_catalog.pg_user
u WHERE t.table_name =3D c.relname AND c.relowner =3D usesysid AND
(t.table_type =3D 'BASE TABLE' OR t.table_type =3D 'VIEW' OR t.table_type
=3D 'LOCAL TEMPORARY') ORDER BY table_name;

and INSERT statement:

            query7 =3D L"INSERT INTO \"abcattbl\" VALUES( 0, $1, (SELECT
c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid =3D c.relnamespace
AND c.relname =3D $2 AND nc.nspname =3D $3), \'\', 8, 400, \'N\', \'N\',
0, 1, 0, \'MS Sans Serif\', 8, 400, \'N\', \'N\', 0, 1, 0, \'MS Sans
Serif\', 8, 400, \'N\', \'N\', 0, 1, 0, \'MS Sans Serif\', \'\' ) ON
CONFLICT DO NOTHING;";

Thank you


On Sat, Dec 20, 2025 at 9:47=E2=80=AFPM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
>
>
> On Thursday, December 18, 2025, Igor Korot <ikorot01@gmail.com> wrote:
>>
>>
>> Using my setup above and assumng my Win locale is en_US.UTF8
>
>
> This seems like an incorrect assumption. The server is expecting UTF8 yet=
 you are passing it data that is not valid UTF8 bytes.  I infer thus your W=
indows encoding is thus not UTF8.
>
> Suggest you make an even smaller, simpler, and self-contained reproducer =
and include how you are executing the code.  You=E2=80=99ve not provided su=
fficient detail for someone else to debug your problem.
>
> David J.
>