From: Jean-Yves Garneau <Jean-Yves.Garneau@invest-quebec.com>
To: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Subject: client_encoding is WIN1252 on ErrorMessage at the StartupMessage
Thread-Topic: client_encoding is WIN1252 on ErrorMessage at the StartupMessage
Thread-Index: AdoqPiVnOUdHMVwERQuseFwrUgLmqg==
Date: Sat, 9 Dec 2023 01:23:01 +0000
Message-ID: 
 <YQBPR0101MB453883F750587BB0EF9B6738FF89A@YQBPR0101MB4538.CANPRD01.PROD.OUTLOOK.COM>
Accept-Language: fr-FR, en-US
Content-Language: fr-FR
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?Df6mv2Kwj0bu7HX/pHtNJpSlKtSl3oEOg0Ufza3SMxt0YLB03rEGy1ionk7N?=
 =?us-ascii?Q?3fHDe+z9g0e9n7b1p2NlzDQ7kugM47eADJE+kBiQqy8Qo/m9zNmXOmJNgIhp?=
 =?us-ascii?Q?IE6Z8EsuOhxYnNv1Q9l5XSMP08IbaV34J1boD5X4Q0amwrGZb7Rp3aZctbdm?=
 =?us-ascii?Q?7BP34LDgFtrAEsfu3ONrotQn+F9njxPHW1jErWZD+Q3XtihGM+CqKmVIzG/1?=
 =?us-ascii?Q?mxSwIWwOJnGRufFwfXRW9CLgob/4xb1RMUoAdtxEMWuUu2WWCXu2dd6QiFx6?=
 =?us-ascii?Q?TrGimLsSRklXpXY0lOQ/ECWVlnZRiJg6V5i6xRIa9yOU+L9MSot3kd4lDTGj?=
 =?us-ascii?Q?fQ1v1md4QlVCpKoSanMWtLy34ThecQ7/A9gNxBMxb/3wGlougGghy++gzAij?=
 =?us-ascii?Q?9nOTVVkBOm9FZqR7zLnaunNYP9Fqb2MvIZYL7x5PIg1OFPR7S+5TlHqoK0jo?=
 =?us-ascii?Q?KyddUDNdkwG0sdByJSYYbQateOuoh8ZXP6dOqD4gj8vFDRpoZbMCg/VSE6Ly?=
 =?us-ascii?Q?/w6AMNgYkHiJ1+6uTbvkb3/owu6F2UUV0H3jmWhiiCpXeTPJZM+S3uS2E25y?=
 =?us-ascii?Q?TocRqdR9jpGQgFteRUqrpo/3rdeUWkBiQtdVulEXPxqN9/n2e98eFh2RqjLm?=
 =?us-ascii?Q?dOHnsUwcHW+lNF2WUl2mehsuPOVVNn9TIlJnYV2Dxe65xAXkMByGDLDK2BjQ?=
 =?us-ascii?Q?AniJcwob7IdeIQEVA/17mBjbQA6W+SKprtX/1MgwMVR9CKdgrwXIlKVn1g1+?=
 =?us-ascii?Q?XxejOAOVF503f7tMZ9Lhmu2moBH1CzSTCRcKRb1AvCuOouIr4lERi8K8fePs?=
 =?us-ascii?Q?e0KgCq6VrLLQYg3sNSo/hsdQHJjteHAk4uCAJa3rjbzdGBmLngyeIsff/HP6?=
 =?us-ascii?Q?8bEPPaCnqACF4fMkwa99CYOrLjEeNd9CKom47zi73dS/+wZqSTiKm/IFo/pD?=
 =?us-ascii?Q?ZvvWte6wD4hAwvoxUHUsJqpfooLNUOPpu9xFHIWWxPjXl4VwxceMH49zOCQZ?=
 =?us-ascii?Q?F3JRi4RaXIJLBPfNSRojDjaWJRRB8qPqG8CtDXGswmx+bwMwXEI6idEN0EYl?=
 =?us-ascii?Q?Lz3S96JlBwzwkyzI6T385NkSlDseWnTlPDxZYtvAiSlVgdt4CIt/11IpErMp?=
 =?us-ascii?Q?IaMkkflwIaPn6YJa7neeTjeSr4FRKvKwvPyRti97F6+Tbx8HhenLTjK5dET5?=
 =?us-ascii?Q?hCx56B8j4rUKgVUKP9W8iKn0gD0dqG7qrvEr9TH8j4P3Dh+xA0W/W7wLxKz0?=
 =?us-ascii?Q?DgNE+weXp770hEJf3mTLpXiMiyk3jm55+JcFpZw5YU8qvxnYNu0fc1rhchZj?=
 =?us-ascii?Q?mnJccnEx+go76sGHmt1V9n0SwGyUshP3LSDqTNEi5DuKyNi3AApNq3XQ4AA5?=
 =?us-ascii?Q?+0MRxrfYv9WlgUkgWfwGU/lGhP1FGWa7VSoQORyEC5dih30FyWei5mfrm0wb?=
 =?us-ascii?Q?ruUxLhbywXkhXzkfGlc9cuHTe+cPb+k4Qvi76oaY4RlN5GO5Ut4j2PKvk57g?=
 =?us-ascii?Q?+kuMi6f+37paIPcATcmh6zm1eGKgBu+bjZe0oCznTsU3ZMywRRB5iB1NycMT?=
 =?us-ascii?Q?dKIcwaYrcAugB6h7lpMS/3TaTTB7QXUt35WjefTp0wJ5Pww8bjSMtbBqzofz?=
 =?us-ascii?Q?idJEjLV0Y3nGqkaIxzNijjY=3D?=
Content-Type: multipart/alternative;
	boundary="_000_YQBPR0101MB453883F750587BB0EF9B6738FF89AYQBPR0101MB4538_"
MIME-Version: 1.0
X-OriginatorOrg: invest-quebec.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: 
 YQBPR0101MB4538.CANPRD01.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 830e3595-f6d3-476b-5a45-08dbf855629c
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Dec 2023 01:23:01.2969
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: bb35297f-d33e-4877-bf86-05c24bfd97ef
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 eYQjDm8L3iaDC/wx6X6X+zXK6BAJVxqVDffb722uEl+nnlZU6/8vTKp165kqjJbOpilefMOQODdhs60oWik7LooFnkHICj/Y+k4KgdQZQswaYoC5ZVWU3Vro9VT/hATd
X-MS-Exchange-Transport-CrossTenantHeadersStamped: YT1PR01MB9241
List-Id: <pgsql-interfaces.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-interfaces@lists.postgresql.org>
List-Owner: <mailto:pgsql-interfaces-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-interfaces>
Archived-At: 
 <https://www.postgresql.org/message-id/YQBPR0101MB453883F750587BB0EF9B6738FF89A%40YQBPR0101MB4538.CANPRD01.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_YQBPR0101MB453883F750587BB0EF9B6738FF89AYQBPR0101MB4538_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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,

--_000_YQBPR0101MB453883F750587BB0EF9B6738FF89AYQBPR0101MB4538_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"FR-CA" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-CA">I&#8217;m developing the wire p=
rotocol on programmable logic controller (PLC) to communicate with the back=
end server.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">The PostgreSQL server run on Wi=
ndows 10 French Canadian.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">The client_encoding on the serv=
er and database encoding is UTF8.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">The collation and character typ=
e are French_Canada.1252.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">The PLC is UTF8.<o:p></o:p></sp=
an></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">After TCP/IP connection, the PL=
C send the &#8220;StartupMessage&#8221; but receive an &#8220;ErrorResponse=
&#8221; because no access right.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">The error message is in WIN1252=
 not UTF8!<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">If grant connect access to user=
 and get data from database all is UTF8!<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">Is it a bug or bad setup?<o:p><=
/o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-CA">Regards,<o:p></o:p></span></p>
</div>
</body>
</html>

--_000_YQBPR0101MB453883F750587BB0EF9B6738FF89AYQBPR0101MB4538_--