pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedWrong german error message encoding
2+ messages / 2 participants
[nested] [flat]
* Wrong german error message encoding
@ 2024-11-20 07:49 radagast42@gmx.net
2024-11-20 09:00 ` Re: Wrong german error message encoding Daniel Gustafsson <daniel@yesql.se>
0 siblings, 1 reply; 2+ messages in thread
From: radagast42@gmx.net @ 2024-11-20 07:49 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
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ß”
To reproduce the error:
- Connect to the new database “träshableß” via socket (or libPq)
- Connection is successful
- Disconnect and connect again with a wrong dbname instead, e.g. “träshable”
- 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 träshable existiert nicht
- Note the garbled double quotes
- MS-CP-1252 decoded this results in:
Datenbank »träshable« existiert nicht
- Note the garbled „ä“ 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 “Umlaut” in it, e.g. “ünknöwn”.
Best regards,
Markus Rips
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Wrong german error message encoding
2024-11-20 07:49 Wrong german error message encoding radagast42@gmx.net
@ 2024-11-20 09:00 ` Daniel Gustafsson <daniel@yesql.se>
0 siblings, 0 replies; 2+ messages in thread
From: Daniel Gustafsson @ 2024-11-20 09:00 UTC (permalink / raw)
To: radagast42@gmx.net; +Cc: pgsql-bugs@lists.postgresql.org
> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-11-20 09:00 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-20 07:49 Wrong german error message encoding radagast42@gmx.net
2024-11-20 09:00 ` Daniel Gustafsson <daniel@yesql.se>
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