BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases
От | David Schmitt |
---|---|
Тема | BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases |
Дата | |
Msg-id | 201102080719.p187JbmO008217@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5869: postgresql corrupts unquoted non-ascii chars in
column aliases
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5869 Logged by: David Schmitt Email address: david@dasz.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 :-(
В списке pgsql-bugs по дате отправления: