Re: Problem with encoding - Mailing list pgsql-odbc

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.ricci@dedalus.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

--