Problem with encoding - Mailing list pgsql-odbc

From Andrea Ricci
Subject Problem with encoding
Date
Msg-id 2c7d3e5f-a192-4b73-95ff-ae934ca2d71b@dedalus.eu
Whole thread
Responses Re: Problem with encoding
List 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

--
Attachment

pgsql-odbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: ODBC SSL connection issue on Solaris with PostgreSQL 18 (OpenSSL 1.0.2)
Next
From: Thom Brown
Date:
Subject: Re: Problem with encoding