public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Igor Korot <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: PQexecPrepared() question
Date: Sat, 20 Dec 2025 18:02:13 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+FnnTxOzSBj-YZmsCcQ-2khU4pG=O1C5qdX8huyTwvRXHA9qg@mail.gmail.com>
References: <CA+FnnTygjVvSmzTHnvteuL4KEC=0P_+mF8Kn84JtNGZWUGxpUA@mail.gmail.com>
<[email protected]>
<CA+FnnTxO6kam9=mRonvsnUA1OxJxdDdQsj+ubdgFNNb9b3WMPQ@mail.gmail.com>
<[email protected]>
<CA+FnnTzE34VJWR7xkymaKEwXiiQ8j3o03m0+qcQsRr2JkRQLwQ@mail.gmail.com>
<[email protected]>
<CA+FnnTz5tcJEL12ir1nxe9q75rxaAdfBtcFUNiD4R5gW_JR23A@mail.gmail.com>
<CA+FnnTyYBNwbzFs5GqO+SMg3g60jPTsnmFwTV=_s_YboGo-68A@mail.gmail.com>
<[email protected]>
<CA+FnnTxOzSBj-YZmsCcQ-2khU4pG=O1C5qdX8huyTwvRXHA9qg@mail.gmail.com>
On Fri, 2025-12-19 at 23:04 -0800, Igor Korot wrote:
> > SQL_ASCII as client encoding means that no conversion will take place.
> >
> > Still, the database encoding (I suspect UTF8) will govern what can be stored
> > in the database. Anything that is not valid UTF-8 will be rejected.
>
> Rejected how?
As you experienced: by throwing an error.
> > A SELECT will never cause an error - the client will just receive data
> > in UTF-8.
>
> And then what?
The *client application* will receive UTF-8 data.
Yours,
Laurenz Albe
view thread (19+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PQexecPrepared() question
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox