Horton
Menu

Re: Fwd: PQexecPrepared() question

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-12-19T21:21:11Z
Lists: pgsql-general 
On 12/19/25 11:12, Ron Johnson wrote:
> On Fri, Dec 19, 2025 at 1:52 PM Tom Lane <tgl@sss.pgh.pa.us 
> <mailto:tgl@sss.pgh.pa.us>> wrote:
> 
>     Igor Korot <ikorot01@gmail.com <mailto:ikorot01@gmail.com>> writes:
>      > But what is the purpose of setting client encoding on the server?
>     It is for
>      > the client
> 
>     No, it's to tell the server what encoding to transmit to the client
>     (as well as what encoding strings coming from the client are in).
> 
> 
> If there's an encoding mismatch between the server and client, does 
> "something" (like a PQ driver) convert text in the data stream from the 
> source encoding to the target encoding?

It is explained here:

https://www.postgresql.org/docs/current/multibyte.html#MULTIBYTE-AUTOMATIC-CONVERSION
> 
> -- 
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!


-- 
Adrian Klaver
adrian.klaver@aklaver.com