| 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,
| 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) |