Hi Soros,
During copy/paste operation the encoding can change.
It has nothing to do with pgAdmin but with the OS on which that operation is executed.
Hope it helps.
Regards
From: Zoltán Sörös [mailto:zsoros@gmail.com]
Sent: vendredi 8 février 2019 14:23
To: pgadmin-support@lists.postgresql.org
Subject: pgAdmin 4 V4.2 and non-unicode database
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
- create a database with latin2 encoding:
create database mytemp encoding='LATIN2' lc_collate='hu_HU' lc_ctype='hu_HU';
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
- 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.