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