From: <radagast42@gmx.net>
Sender: <markus.rips@gmx.de>
To: "'Erik Wienhold'" <ewie@ewie.name>
Cc: "'Daniel Gustafsson'" <daniel@yesql.se>,
	<pgsql-bugs@lists.postgresql.org>
References: <00a601db3b20$b00261e0$100725a0$@gmx.net>
 <D4471278-CED7-405A-92EA-8E5B0FCBB69A@yesql.se>
 <00b001db3c10$dfa3f850$9eebe8f0$@gmx.net>
 <af8c47e7-c0a3-4f96-9d77-9356e1075ee0@ewie.name>
In-Reply-To: <af8c47e7-c0a3-4f96-9d77-9356e1075ee0@ewie.name>
Subject: AW: AW: Wrong german error message encoding
Date: Thu, 21 Nov 2024 16:11:51 +0100
Message-ID: <00f101db3c27$b2198690$164c93b0$@gmx.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQLqTBi/74EAM5NvyrWzo4r5auGKNgHKA0/PAYklE9YBoQIzwLB8Eq3g
Content-Language: de
UI-OutboundReport: notjunk:1;M01:P0:oPVoO/dFRrU=;ICX5WkyeX7OojioeIq7OaTpa/rt
 5kBX8kKaB4dv1ZlH7xZuVyaNPeLusGW+hLGe1X/pzbvJYaxkkSxFFgGnD1UIWD3qbeiYRDm7S
 DpqEnegM+CYvMMtscPdGVmU704C9O/TPbEcTYPqRv1elCdVV46UyEyH/dt0RENQ1SJ++bwoZt
 OWvf5IDqOxiUUExcJTiK56MTcQPRAMjIP8uBnAqY0HuAlnqkTnsgFTK35nSeb/2axVjRaYf8M
 vP3o1J1Z2z62h8FM8bpOoiut7SB/Zg9VSyUgz6ofqZIZ2rnKTXwlObZNXq4Z70sQMNMBO0T30
 Coi0MauV4ipQ29fLOAJzbsbbGkjEe9JNsrEmzPsHfOtRMO7QXWqBD+/vWJGAtLychJq41IFK/
 4TxFai4fgg0wXLQB5efMNiqK5G8VYDUjW1HWDMyykDKV855SZNOd15l+ftl8iQeicRApvJTHe
 FiYEWR8ERZwhjQlbCXG3GN3Mu4eQM6DSBhs0dZba6c1cK3oyohtpqYYt/8swjV1IIMmHGDJgZ
 cmJxVSJkWtZEhdz1HK5yo08vHIAERlaURwnXIsX8GUtophS5D6N8zoqlWxSg9LiuLm/uvXaiQ
 UsyXOGIAWyrS7OwYHkGZBzYrsDHQ2odLIgwZGC0WGe5ir5JUOrpkS5yhQjUwMTlDN00e8MgF1
 ISpaNo12IWIEGD0IBFxy42YDxXp8rrFHlbLSkkpPKgFSbVbsNJslEfG6RX6NHhcy6GD/pgc0L
 N32c2j2p9OBXOPUtXHuE+Of8A05qhugVMdDlce2/Ca0bSxkthW5nDvtkRSU1tHGk5zd7i5m+F
 yV0HzBVX8aKqJUvmfoYiBmzLaj6jonmqWzaWalpH/NR+ayabjuaP4WAMoizVAErIENnrsAfko
 DJBw1TYxgBzODEyeJYmHAiHglIeAy3byZoqCKixmCslYlEix59cGZ0ydY
Archived-At: 
 <https://www.postgresql.org/message-id/00f101db3c27%24b2198690%24164c93b0%24%40gmx.net>
Precedence: bulk

That does not help.
After doing it typing =C3=A4 or =C3=9F results in wrong characters and =
the connection fails nonetheless:

	PS C:\tmp> chcp 1252
	Aktive Codepage: 1252.
	PS C:\tmp> psql -d tr=E2=80=9Eshable=C3=A1 -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 the behaviour of psql is another issue, my original error report is =
about German error message encoding when connecting directly via socket =
or libpq.

Markus

-----Urspr=C3=BCngliche Nachricht-----
Von: Erik Wienhold <ewie@ewie.name>=20
Gesendet: Donnerstag, 21. November 2024 15:53
An: radagast42@gmx.net
Cc: 'Daniel Gustafsson' <daniel@yesql.se>; =
pgsql-bugs@lists.postgresql.org
Betreff: Re: AW: Wrong german error message encoding

On 2024-11-21 13:28 +0100, radagast42@gmx.net wrote:
> When using psql from the command line I can't even connect to the
> database "tr=C3=A4shable=C3=9F":
>=20
> 	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
>=20
> But in this case I see no garbled error message....
> I have to encode the database name  with MS-CP-1252 to connect:
>=20
> 	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.

You should set code page 1252 with

    chcp 1252

You can automate that for new shells by running chcp from your
PowerShell profile.  Variable $profile gives you the filename.

--=20
Erik