pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: radagast42@gmx.net
To: 'Daniel Gustafsson' <daniel@yesql.se>
Cc: pgsql-bugs@lists.postgresql.org
Subject: AW: Wrong german error message encoding
Date: Thu, 21 Nov 2024 13:28:29 +0100
Message-ID: <00b001db3c10$dfa3f850$9eebe8f0$@gmx.net> (raw)
In-Reply-To: <D4471278-CED7-405A-92EA-8E5B0FCBB69A@yesql.se>
References: <00a601db3b20$b00261e0$100725a0$@gmx.net>
	<D4471278-CED7-405A-92EA-8E5B0FCBB69A@yesql.se>

When using psql from the command line I can't even connect to the database "träshableß":

	psql -d träshableß -U postgres
	Passwort für Benutzer postgres:
	psql: Fehler: Verbindung zum Server auf »localhost« (::1), Port 5432 fehlgeschlagen: FATAL:  Datenbank »träshableß« 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äshableß -U postgres
	Passwort für Benutzer postgres:
	psql (16.4)
	Warnung: Konsolencodeseite (850) unterscheidet sich von der Windows-
         	Codeseite (1252). 8-Bit-Zeichen funktionieren möglicherweise nicht
         	richtig. Einzelheiten finden Sie auf der psql-Handbuchseite unter
         	»Notes for Windows users«.
	Geben Sie »help« für Hilfe ein.

	träshableÃY=#

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äshableß".

Markus Rips

-----Ursprüngliche Nachricht-----
Von: Daniel Gustafsson <daniel@yesql.se> 
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:
> 
> 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 “Umlaut” in it with pgAdmin, e.g. “träshableß”

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

--
Daniel Gustafsson







view thread (2+ messages)  latest in thread

Message-ID: <00b001db3c10$dfa3f850$9eebe8f0$@gmx.net>
Permalink:  ../00b001db3c10$dfa3f850$9eebe8f0$@gmx.net/
Also on:    postgresql.org/message-id/00b001db3c10$dfa3f850$9eebe8f0$@gmx.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: radagast42@gmx.net, daniel@yesql.se, pgsql-bugs@lists.postgresql.org
  Subject: Re: AW: Wrong german error message encoding
  In-Reply-To: <00b001db3c10$dfa3f850$9eebe8f0$@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox