Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDfcx-002QBv-Ti for pgsql-bugs@arkaria.postgresql.org; Wed, 20 Nov 2024 07:59:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tDfcw-0034KE-Iz for pgsql-bugs@arkaria.postgresql.org; Wed, 20 Nov 2024 07:59:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDfSd-002xUV-FQ for pgsql-bugs@lists.postgresql.org; Wed, 20 Nov 2024 07:49:15 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDfSa-002t5m-QH for pgsql-bugs@lists.postgresql.org; Wed, 20 Nov 2024 07:49:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1732088951; x=1732693751; i=radagast42@gmx.net; bh=svPGYxxjyYjT4ibdrPNnovtqV9qXU3pokLhsxp6FEeU=; h=X-UI-Sender-Class:From:To:Subject:Date:Message-ID:MIME-Version: Content-Type:cc:content-transfer-encoding:content-type:date:from: message-id:mime-version:reply-to:subject:to; b=CrwMWhu6caqUFjryoFugRaLemZhwWJXEfBXYP+nEzNswVqN3oO7up47gNYQgDPJt zbYRh7I+BqdDTgq76p4sTqIV63R84SXrvugUvh3foU1iJevAMEZa0xFx3h0cOyC6L 62YqBrWUZ8+eQ1cKEoHZ0rivj8zFztH8N+DN/5LwFMpcvwosRAstSwRXnrDmj2ej3 zBya/wz3f3bj9BU+QxUM3PHj5fkbgY38S1zNAtftgY9NYHjfmr4JYGEKPK+x1Pc/P uMHwhex8Vhk9UjhYRd4C2ottYMfgSXB075USKKJsr5Td06O+XNAcV6FtuazZyyfpL btDUU8UmA6kAsdo0NA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from Smaug ([93.244.142.245]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Mqb1c-1tZXvz0rvE-00nv4C for ; Wed, 20 Nov 2024 08:49:11 +0100 From: Sender: To: Subject: Wrong german error message encoding Date: Wed, 20 Nov 2024 08:49:10 +0100 Message-ID: <00a601db3b20$b00261e0$100725a0$@gmx.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A7_01DB3B29.11C9B010" X-Mailer: Microsoft Outlook 16.0 Thread-Index: Ads7GygEbuMq5OwORVSEY8kpIqgSjQ== Content-Language: de X-Provags-ID: V03:K1:QYuif5zcI6k1fQQSpxn4LBKq9mLVdAdtNJ2W2TUYhwXiS9WOY2z LMtwU/K0eZf0qfxjzZhiRLpzqwDJZVWDgcd6bDcSkz29vKEMC9QJQfJTgeNUE5k3+3sqyGT A/YNduE6urJeyibCpfQx58jwa4AbGUPjhU3Bx1JQlvNwPgjY2XviXQX7qi0YRWjky8d/gZd OQSzoTfHirrBgHCKFr1CA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:2+ZDdEnt1XY=;N3wqWNUM7StVlUlSDUsMQuNH4KE 7gMQx3SeCuAKDz5CObyU57iOX6ShQwgA9FJZH4VrxMebn+W8PC39WylGztwKGtErITfhtMWCK xntoA77W6TbfJG1S2RB/IDliw2gSKXBEvzWUWwv8un3Rdiui8nma71IxBdmij/HcvP8vtESUN XnNC9fJOkclCeIsqTty6DRgfc8VcrRMYG2+LuGXYh1c1+DFfIGjtMVVaRWGFdJlaF8fdHSOO+ YE8JOgjDVyVWTusC7aYZvqfQqG/+5+VwUop+dPXR27NWo/FKH8garjLOdPNRKoud+QrelrLvt nMC6RS8c8mQW/P0kzodZil/v+BNf19cb8Cgpz0aBbIKnCGFMrrljUNWzLqqZiiPRXKpid4wjC F1b6rt0gG3Aqc+rU9gSbUANGqO5X6SojAAbuP0Yfz2s+1u4h1hKdK0xh4/Vjub7tQ0cjRIVXw XVv0vGxqdgC6MvlAkoa7NRpITkF9SeWdsmvOjzBnt3did3MPMXpqqKJdMF+/tLJnsTqxQ9QZ0 DpZ1TX42+qrS62vSJ2KQjfhYQJrIgo/X9djM0j63zmNILr8y5zhulpUTpn0qMbO2PHztXSFkr swHtJa/0UrdHnmD2xh0MXgdepnLYzDfK4LhyQebvcvb/9Bsh1QUkwVu9YS+T+C7pY70vC8kma 4rgNnWxwnlVT2+zyEhfiT6PjGoE7EK9zEgl7nhocY2tLsaGINRgrTG5FYvh9pE/GC+TC5BUoT S8pPIFYyJD43csslgxeoYGxjFdSw44/btdPr6Uj9W4Hz65jb2WvoELyXjy9k1I++GEz6TQDQh LlTxyo5SzT3/kwi119AZZaH1nTSSaMQymIPwKS6NJzk8dhf24vbjgkmkz1EXyk7b8/5Nf4m2B z1a596318wenF4WLvQD4IZ1NP72dVLQJrh9MIsblgYO41XDec5mA152lf List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_00A7_01DB3B29.11C9B010 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello. I think there is a wrong encoding for (at least) German localized error = messages. =20 Setup: - Standard installation of PostgreSQL 16.4 on a German Windows 10. - Create a new database with at least one German = =E2=80=9CUmlaut=E2=80=9D in it with pgAdmin, e.g. = =E2=80=9Ctr=C3=A4shable=C3=9F=E2=80=9D =20 To reproduce the error: - Connect to the new database =E2=80=9Ctr=C3=A4shable=C3=9F=E2=80=9D via = socket (or libPq) - Connection is successful - Disconnect and connect again with a wrong dbname instead, e.g. = =E2=80=9Ctr=C3=A4shable=E2=80=9D - You get the following byte array back as error message: #[68 97 116 101 110 98 97 110 107 32 187 116 114 195 164 115 104 97 98 = 108 101 171 32 101 120 105 115 116 105 101 114 116 32 110 105 99 104 = 116] - UTF8 decoded this results in: Datenbank =EF=BF=BFtr=C3=A4shable=EF=BF=BF existiert = nicht - Note the garbled double quotes - MS-CP-1252 decoded this results in: Datenbank =C2=BBtr=C3=83=C2=A4shable=C2=AB existiert = nicht - Note the garbled =E2=80=9E=C3=A4=E2=80=9C here =20 I assume that at least this error message template is encoded with = MS-CP-1252 instead of UTF8, but it all German localized error messages = for connection errors may be affected. I can reproduce the same encoding problems when using a user with a = German =E2=80=9CUmlaut=E2=80=9D in it, e.g. = =E2=80=9C=C3=BCnkn=C3=B6wn=E2=80=9D. =20 Best regards, =20 Markus Rips=20 =20 ------=_NextPart_000_00A7_01DB3B29.11C9B010 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hello.

I = think there is a wrong encoding for (at least) German localized error = messages.

 

Setup:
- Standard installation of = PostgreSQL 16.4 on a German Windows 10.

- = Create a new database with at least one German =E2=80=9CUmlaut=E2=80=9D = in it with pgAdmin, e.g. =E2=80=9Ctr=C3=A4shable=C3=9F=E2=80=9D

=

 

To reproduce the error:
- Connect = to the new database =E2=80=9Ctr=C3=A4shable=C3=9F=E2=80=9D via socket (or libPq)

- = Connection is successful

- Disconnect and connect = again with a wrong dbname instead, e.g. = =E2=80=9Ctr=C3=A4shable=E2=80=9D

- = You get the following byte array back as error = message:

#[68 97 116 101 110 98 97 110 107 32 = 187 116 114 195 164 115 104 97 98 108 101 171 32 101 120 105 115 116 105 = 101 114 116 32 110 105 99 104 116]

- UTF8 decoded this results = in:
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Datenbank =EF=BF=BFtr=C3=A4shable=EF=BF=BF existiert = nicht

- Note the garbled double = quotes

- MS-CP-1252 decoded this results = in:

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Datenbank = =C2=BBtr=C3=83=C2=A4shable=C2=AB existiert = nicht

- Note the garbled = =E2=80=9E=C3=A4=E2=80=9C here

 

I = assume that at least this error message template is encoded with = MS-CP-1252 instead of UTF8, but it all German localized error messages = for connection errors may be affected.

I = can reproduce the same encoding problems when using a user with a German = =E2=80=9CUmlaut=E2=80=9D in it, e.g. =E2=80=9C=C3=BCnkn=C3=B6wn=E2=80=9D.

 

Best regards,

 

Markus Rips

 

------=_NextPart_000_00A7_01DB3B29.11C9B010--