Re: Problem with encoding

On Mon, 25 May 2026, 16:07 Andrea Ricci, <andrea(dot)ricci(at)dedalus(dot)eu> wrote:

> 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.
>

You are using an ANSI driver, which won't work with what you are sending,
particularly because it includes what appears to be a multibyte character
(that dot in the middle).

Do you have a unicode driver available?

Thom

>
>