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
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 |