search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.43k stars 638 forks source link

Encoding Problem with PGAdmin 4.2 (RM #3982) #2348

Closed dpage closed 2 years ago

dpage commented 5 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3982 Originally created by Monika König at 2019-02-11 13:57:26 UTC.

Hey,

on a postgresql-11 database with client_encoding =latin9 I've got trouble with umlauts.

The SQL select 'äöüß'; returns "ÀöÌß".

in psql and in pgadmin3 I dont't have this problems, they answer correctly:

postgres=# select 'äöüß'; ?column?

äöüß (1 Zeile)

Even the command set client-encoding=latin9

doesn't help.

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3982#note-1 Originally created by Akshay Joshi at 2019-02-13 10:54:43 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 34
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3982#note-2 Originally created by Khushboo Vashi at 2019-02-14 06:57:46 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Khushboo Vashi
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3982#note-3 Originally created by Saeed Hubaishan at 2019-02-18 10:29:26 UTC.

I think this https://redmine.postgresql.org/issues/3911 is related bug

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3982#note-4 Originally created by Khushboo Vashi at 2019-02-26 09:03:41 UTC.

Patch sent. https://www.postgresql.org/message-id/CAFOhELf87TZHPLVe_n3SJiSmukZQwXFxTYAyM5vo9n3pdsE5LA@mail.gmail.com

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3982#note-5 Originally created by Akshay Joshi at 2019-02-27 10:32:06 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 34 EDB Sprint 35
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3982#note-6 Originally created by Khushboo Vashi at 2019-03-01 13:51:55 UTC.

Applied in changeset commit:849e34c2f763a9d084bd21840df6dde60c0a1b06.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3982#note-7 Originally created by Fahar Abbas at 2019-03-11 12:05:04 UTC.

This is resolved in latest build

https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-03-11/

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.