Re: PQexecPrepared() question

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PQexecPrepared() question
Date: 2025-12-21 15:34:39
Message-ID: 699b6649-6841-48a7-8182-b92d28a70ff7@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2025-12-21 16:58:07 Re: PQexecPrepared() question
Previous Message Greg Sabino Mullane 2025-12-21 15:10:22 Re: Dealing with SeqScans when Time-based Partitions Cut Over