BUG #4678: codepage UTF8 crashes psql

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4678: codepage UTF8 crashes psql
Date: 2009-02-27 09:36:43
Message-ID: 200902270936.n1R9ah4r036269@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4678
Logged by: Harald Armin Massa
Email address: haraldarminmassa(at)gmail(dot)com
PostgreSQL version: 8.3.5 / 8.3.6
Operating system: XPSP2, 2003, XP SP3, W7 Beta
Description: codepage UTF8 crashes psql
Details:

(same bug in 8.4dev)

C:\>chcp 65001
Aktive Codepage: 65001.

C:\>psql -U postgres --port=5433
Dies ist psql 8.3.5, das interaktive PostgreSQL-Terminal.

Geben Sie ein: \copyright für Urheberrechtsinformationen
\h für Hilfe über SQL-Anweisungen
\? für Hilfe über interne Anweisungen
\g oder Semikolon, um eine Anfrage auszuführen
\q um zu beenden

Warnung: Konsolencodeseite (65001) 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«.

postgres=# \l
postgres=# gend Arbeitsspeicher.

Summary: setting the console code-page to UTF8 (chcp 65001) and submitting a
command in psql results in "out of memory error" (nicht genügend
Arbeitsspeicher)

The wrangled output is by the "Umlauts"

Workaround: don't do that. (chcp 1252 and setting client-encoding to some
win1252 works, as discribed in notes for Windows users)

Why it is still sad: In applications I have to use UTF-8 to keep my sanity.
Now debugging SQL / putting to files / dumping with different encodings puts
me back to that encoding misery.

Harald

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2009-02-27 09:39:05 Re: BUG #4635: postgres.exe crash when RAISE NOTICE during debugging of PL/pgSQL function in PgAdminIII
Previous Message Jeff Davis 2009-02-27 06:53:44 Re: Weird quirk with pg_dump of complex types