Re: Problem with encoding

Yep !

That was the problem, actually using an *UNICODE* driver, everything works

thanks

A

Il 25/05/2026 17:44, Thom Brown ha scritto:
>
> *CAUTION* - This e-mail originates outside of Dedalus. Be vigilant
> with content, links and attachments!
>
> 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
>
>

--