Re: PQexecPrepared() question

Igor Korot <ikorot01@gmail.com>

From: Igor Korot <ikorot01@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-12-21T16:58:07Z
Lists: pgsql-general
Hi,

So what is the best way to make it work?

Thank you.


On Sun, Dec 21, 2025 at 7:34 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

> On 12/21/25 03:56, Igor Korot wrote:
> > Hi, David,
> >
> > Attached is a script I ran on a server (from psql).
> >
> > The offending line is:
> >
> > CREATE TABLE abcß(id integer primary key, name text);
> >
> > Script ran successfully.
> >
> > Using the ODBC driver everything works. I didn't change anything in
> > the driver setup.
> > Same setup - Windows client connecting to Linux server.
>
> It is not the same setup, in your original question you are hand writing
> code not running a script through the ODBC driver. Best bet is the ODBC
> driver is picking up the client(Windows) encoding and passing it to the
> server. Crank up the logging on both ends, the ODBC driver and the
> Postgres server and see what is hitting the server when you use the driver.
>
> >
> > Any other info needed - please do tell.
> >
> > Thank you.
> >
> >
> > On Sat, Dec 20, 2025 at 11:47 PM David G. Johnston
> > <david.g.johnston@gmail.com> wrote:
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>