client_encoding is WIN1252 on ErrorMessage at the StartupMessage

From: Jean-Yves Garneau <Jean-Yves(dot)Garneau(at)invest-quebec(dot)com>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: client_encoding is WIN1252 on ErrorMessage at the StartupMessage
Date: 2023-12-09 01:23:01
Message-ID: YQBPR0101MB453883F750587BB0EF9B6738FF89A@YQBPR0101MB4538.CANPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I'm developing the wire protocol on programmable logic controller (PLC) to communicate with the backend server.
The PostgreSQL server run on Windows 10 French Canadian.
The client_encoding on the server and database encoding is UTF8.
The collation and character type are French_Canada.1252.
The PLC is UTF8.
After TCP/IP connection, the PLC send the "StartupMessage" but receive an "ErrorResponse" because no access right.
The error message is in WIN1252 not UTF8!
If grant connect access to user and get data from database all is UTF8!
Is it a bug or bad setup?

Regards,

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2023-12-09 01:30:43 Re: client_encoding is WIN1252 on ErrorMessage at the StartupMessage
Previous Message Greg Sabino Mullane 2023-12-07 14:42:10 Version 3.18.0 of DBD::Pg released (Perl DBI driver for Postgres)