pgAdmin 4 V4.2 and non-unicode database

From: Zoltán Sörös <zsoros(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: pgAdmin 4 V4.2 and non-unicode database
Date: 2019-02-08 13:23:00
Message-ID: CAFiqkXiLjnZaGTzA2514djh2yJsqzbn8yDHBYsOpc9FLc4CdSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi!

Our database uses latin2 encoding. pgAdmin V4 displays all text correctly,
but when I copy something from the SQL tab to the query tool, and run the
query, it scrambles all accented letters in the stored texts, notably on
comments on columns and texts in stored functions. This problem exists
since V4.0 - 3.6 was OK.

Version: pgAdmin 4 V4.2, Windows 10, firefox browser

Steps to reproduce:
- create a database with latin2 encoding:
create database mytemp encoding='LATIN2' lc_collate='hu_HU'
lc_ctype='hu_HU';
- create a table
create table mytemptable (id integer not null, tempdata text);
- create a comment on the database using latin2 encoding
comment on table mytemptable is 'Árvíztűrő tükörfúrógép';
- copy the comment command from the SQL tab of pgAdmin4 v4.2
- paste the copied command into pgAdmin 4 v4.2 query tool
- run the copied command
- refresh the SQL tab of pgAdmin 4, and check comment on the table:
COMMENT ON TABLE public.mytemptable IS 'à rvíztŹrő
tĂźkĂśrfĂşrĂłgĂŠp';

I'm not sure this plain text e-mail can display the problem, I can make
screenshots if requested.

Thanks in advance:
Zoltán Sörös

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Mathias Zajaczkowski 2019-02-08 14:58:39 RE: pgAdmin 4 V4.2 and non-unicode database
Previous Message Ashesh Vashi 2019-02-08 04:52:53 Re: Cannot connect to Replication Slave with the new Version 4.2 of PGAdmin4