Re: PQexecPrepared() question - Mailing list pgsql-general

From Laurenz Albe
Subject Re: PQexecPrepared() question
Date
Msg-id 5ef09c253188681e2beeb975d96d7ebf861f2b10.camel@cybertec.at
Whole thread Raw
In response to Re: PQexecPrepared() question  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: PQexecPrepared() question
Next
From: Igor Korot
Date:
Subject: Re: PQexecPrepared() question