Feedback-ID: i76984098:Fastmail
Message-ID: <699b6649-6841-48a7-8182-b92d28a70ff7@aklaver.com>
Date: Sun, 21 Dec 2025 07:34:39 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: PQexecPrepared() question
To: Igor Korot <ikorot01@gmail.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CA+FnnTygjVvSmzTHnvteuL4KEC=0P_+mF8Kn84JtNGZWUGxpUA@mail.gmail.com>
 <2547700.1765940917@sss.pgh.pa.us>
 <CA+FnnTxO6kam9=mRonvsnUA1OxJxdDdQsj+ubdgFNNb9b3WMPQ@mail.gmail.com>
 <9a0ce31a49f149d8d982d2b359095560655f781e.camel@cybertec.at>
 <CA+FnnTzE34VJWR7xkymaKEwXiiQ8j3o03m0+qcQsRr2JkRQLwQ@mail.gmail.com>
 <CAKFQuwZaf2quGaqsGAj4+rVVCebOwU3JjbMUJPxxj6NeF_O_gA@mail.gmail.com>
 <CA+FnnTwZUo-ZRZ4if_ngXXkYgtOCsmMp1uFpsMFkG5AOmRxX4Q@mail.gmail.com>
 <CAKFQuwYSM2xMxX+v8LAhJFG3kB1O-VBtV3eo3fj0ag3rGJ=ehQ@mail.gmail.com>
 <CA+FnnTzqQbBMnMyX3fz44tL0bYykDU=qcUpvT=vUy+cp8Q6vfw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CA+FnnTzqQbBMnMyX3fz44tL0bYykDU=qcUpvT=vUy+cp8Q6vfw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/699b6649-6841-48a7-8182-b92d28a70ff7%40aklaver.com>
Precedence: bulk

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