From: | "David Schmitt" <david(at)dasz(dot)at> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases |
Date: | 2011-02-08 07:19:37 |
Message-ID: | 201102080719.p187JbmO008217@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: 5869
Logged by: David Schmitt
Email address: david(at)dasz(dot)at
PostgreSQL version: 8.4.5
Operating system: Windows 7
Description: postgresql corrupts unquoted non-ascii chars in column
aliases
Details:
Example query:
SELECT column as zurück FROM table;
results in corruption of the "ü" (umlaut u). This causes Npgsql to fail to
match up the columns in the result set (see
http://pgfoundry.org/tracker/?func=detail&aid=1010988&group_id=1000140&atid=
590) and pgadminIII doesn't display the alias in the result pane.
The same query works with the same tools against a 8.4.5 running on Debian
squeeze.
If the alias is quoted like this:
SELECT column as "zurück" FROM table;
the query also works against the DB running on windows.
PS: I tried downloading the newest version of the one click installer for
windows from EnterpriseDB, and noticed that since recently that site
requires a registration :-(
From | Date | Subject | |
---|---|---|---|
Next Message | Cyril DE MURCIA | 2011-02-08 13:05:04 | Duplicate table name within the sme schema |
Previous Message | Christopher Head | 2011-02-07 08:44:03 | BUG #5868: Client ignores X.509 subject alternative name |