Problem with encoding

From: Andrea Ricci <andrea(dot)ricci(at)dedalus(dot)eu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Problem with encoding
Date: 2026-05-25 15:07:23
Message-ID: 2c7d3e5f-a192-4b73-95ff-ae934ca2d71b@dedalus.eu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I'm using Powerbuilder via ODBC on a PostgreSQL 17 database (13.02.00.00
ANSI).

The setting of server encoding is 'UTF8', and in the "Connect Setting"
parameter of ODBC voice I have "SET CLIENT_ENCODING TO 'UTF8'".

The problem appears when I attempt to update a char(4) column with '4· '
(34 B7 20 20 in hex)vor similar value with "high" characters, via
explicit sql instruction.
The same update instruction via pgAdmin works, of course.

Thanks in advance

A

--

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Thom Brown 2026-05-25 15:44:36 Re: Problem with encoding
Previous Message Tom Lane 2026-05-05 13:57:03 Re: ODBC SSL connection issue on Solaris with PostgreSQL 18 (OpenSSL 1.0.2)