From: | David Schmitt <david(at)dasz(dot)at> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases |
Date: | 2011-03-03 16:51:13 |
Message-ID: | 4D6FC701.1070407@dasz.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 03.03.2011 16:08, Robert Haas wrote:
> 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?
There are some garbage bytes instead of the umlaut.
>> 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.
I presume there is a new 8.4.5 version at enterprisedb.com ? I'll have a
look at it later.
Best Regards, David
--
dasz.at OG Tel: +43 (0)664 2602670 Web: http://dasz.at
Klosterneuburg UID: ATU64260999
FB-Nr.: FN 309285 g FB-Gericht: LG Korneuburg
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-03-03 16:55:37 | Re: BUG #5906: assertion failure in AtCleanup_Portals |
Previous Message | Josh | 2011-03-03 16:41:22 | Re: BUG #5911: pg_notify() function only works when channel name is lower case |