Re: BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases
Дата
Msg-id AANLkTi=1LjhQyNuswYJ4X3HvuznC3s8zxzgn2Fqt3aQQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases  ("David Schmitt" <david@dasz.at>)
Ответы Re: BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases  (David Schmitt <david@dasz.at>)
Список pgsql-bugs
On Tue, Feb 8, 2011 at 2:19 AM, David Schmitt <david@dasz.at> wrote:
> Example query:
>
> =A0SELECT column as zur=FCck FROM table;
>
> results in corruption of the "=FC" (umlaut u). This causes Npgsql to fail=
 to
> match up the columns in the result set (see
> http://pgfoundry.org/tracker/?func=3Ddetail&aid=3D1010988&group_id=3D1000=
140&atid=3D
> 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:
>
> =A0SELECT column as "zur=FCck" 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.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5871: database connecting failed
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5870: Cannot get the first popup window during install