From: <radagast42@gmx.net>
Sender: <markus.rips@gmx.de>
To: "'Daniel Gustafsson'" <daniel@yesql.se>
Cc: <pgsql-bugs@lists.postgresql.org>
References: <00a601db3b20$b00261e0$100725a0$@gmx.net>
 <D4471278-CED7-405A-92EA-8E5B0FCBB69A@yesql.se>
In-Reply-To: <D4471278-CED7-405A-92EA-8E5B0FCBB69A@yesql.se>
Subject: AW: Wrong german error message encoding
Date: Thu, 21 Nov 2024 13:28:29 +0100
Message-ID: <00b001db3c10$dfa3f850$9eebe8f0$@gmx.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQLqTBi/74EAM5NvyrWzo4r5auGKNgHKA0/PsJU48gA=
Content-Language: de
UI-OutboundReport: notjunk:1;M01:P0:csFP3dh9Npk=;p0Rsbc46bgkvHTK4Zftx6dJOdPw
 CJ0kJOd8fSKCwFGSnAVrEQy/fbPUfLFYd/TgixQwmucjQDAMDKad5g9LCyAKmrMmbCAZNWi6E
 zeCGI95UP1UpLHyjsbpkwt3WtTOAyZ3CMDk3+y/7qJw8ABGpuSmQyYufDaw6uCZ7gajH2eEHN
 9Rrg1jHBgwspgF6XTil9IM27S5nwrT3o5ksh/uQNdt/FHBhNfWzf5KfGvDSJZh0wePC/R6dXW
 jEDwNpArlbuJ1iIRtEh6wo9+EwQPgEJR6kC6/C6KGuAvoIFykTahdAh3bPHlBHhBRN/xrk3Ub
 S0cdGb91k1DBwiFFyi8mI81QixRlBoU4SfbE0YDrOVGjr2fhC5a94iJH+w7FF2SC5eZs6j6ye
 KFa8NrS+J+BBsMd/Zbmb9ZkT4HBrHUqq6Fq9QzWXpDCqvv4OEYNTEDHuzNma6TtF54qkuC2P+
 VH/mQlgPVlQrMX+9XolXOPC4G/KRV+/d9vmESY/oGchNBpSW7c5/V7wkJTaQ1eXjnlFi3Y+yd
 TQqsMVnBaVo6aMuOzxppDk+Kq2R0mGr4J59bB4/fj+bwNHqxTO5XFgQdaxHFmjLHPMcLJDzWa
 ESwaLMuGsUtqEeFNI1/ide0njyZ78uq9gTGd5CGVa2OW0NFxahjcO0nnkb+BAHBx/22m1K2BH
 H2FvktTalIvn7L8VhrNEx+5dRtoR9t9VPhNOA6Ertjb4WvgXvPo8kfXbq/kuEFNonImKc89Gy
 EW1cyZsxUU9/YKmK7XhpruXdimteDm8O96GC2tdZzTMeXp6c2Ol6utB9WfqBOdlnO8wXIBdhX
 5JzZuU2WDOdWlK8sLuY12+V0FcZ9KWNNtvKrj/BriCMRgGdR8PsWZQ/ZpImDwgj2GEY1YrO1b
 IOSOd1OLZPTSICbPqclcrgyln1ZvQYisqrR4XmtyFkJdI0cdonNImyvYyKbafCQEORfvzO9Vz
 hONyDUZwWq5W83dY9s4RR/ulTxAE5MIpOFVZJCtC2KRPFNw40pLUxkUTGeJpUMILGQ0WijM7b
 +YmT8DFg3Kxzl5fPD+h1zYP/5wOESC8rNQcD7IOz7Aic8B1mFRVmCSMbx6YodidwSAKeBTVJS
 FrTlG8XskueVNeHxLH3/jR/IBHsOrN
Archived-At: 
 <https://www.postgresql.org/message-id/00b001db3c10%24dfa3f850%249eebe8f0%24%40gmx.net>
Precedence: bulk

When using psql from the command line I can't even connect to the =
database "tr=C3=A4shable=C3=9F":

	psql -d tr=C3=A4shable=C3=9F -U postgres
	Passwort f=C3=BCr Benutzer postgres:
	psql: Fehler: Verbindung zum Server auf =C2=BBlocalhost=C2=AB (::1), =
Port 5432 fehlgeschlagen: FATAL:  Datenbank =
=C2=BBtr=C3=A4shable=C3=9F=C2=AB existiert nicht

But in this case I see no garbled error message....
I have to encode the database name  with MS-CP-1252 to connect:

	psql -d tr=C3=83=C2=A4shable=C3=83=C5=B8 -U postgres
	Passwort f=C3=BCr Benutzer postgres:
	psql (16.4)
	Warnung: Konsolencodeseite (850) unterscheidet sich von der Windows-
         	Codeseite (1252). 8-Bit-Zeichen funktionieren =
m=C3=B6glicherweise nicht
         	richtig. Einzelheiten finden Sie auf der psql-Handbuchseite =
unter
         	=C2=BBNotes for Windows users=C2=AB.
	Geben Sie =C2=BBhelp=C2=AB f=C3=BCr Hilfe ein.

	tr=C3=83=C2=A4shable=C3=83Y=3D#

In the scenario given in my bug report I connected to PostgreSQL via =
socket interface or libpq.
PgAdmin correctly shows the database name as "tr=C3=A4shable=C3=9F".

Markus Rips

-----Urspr=C3=BCngliche Nachricht-----
Von: Daniel Gustafsson <daniel@yesql.se>=20
Gesendet: Mittwoch, 20. November 2024 10:00
An: radagast42@gmx.net
Cc: pgsql-bugs@lists.postgresql.org
Betreff: Re: Wrong german error message encoding

> On 20 Nov 2024, at 08:49, <radagast42@gmx.net> <radagast42@gmx.net> =
wrote:
>=20
> 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

Do you get the same error message issue when connecting with psql =
instead og PGAdmin?

--
Daniel Gustafsson