From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | David Schmitt <david(at)dasz(dot)at> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases |
Date: | 2011-03-03 15:08:32 |
Message-ID: | AANLkTi=1LjhQyNuswYJ4X3HvuznC3s8zxzgn2Fqt3aQQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Feb 8, 2011 at 2:19 AM, David Schmitt <david(at)dasz(dot)at> wrote:
> 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.
That link doesn't show anything interesting when I look at it. What
exactly do you mean by corrupted?
> 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 :-(
I think this has been fixed. Please let me know if not.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2011-03-03 15:12:20 | Re: BUG #5870: Cannot get the first popup window during install |
Previous Message | Robert Haas | 2011-03-03 15:04:52 | Re: BUG #5871: database connecting failed |