Hi Zoltan Please create a new RM https://redmine.postgresql.org/projects/pgadmin4
On Sat, 9 Feb 2019, 11:14 Zoltán Sörös <zso...@gmail.com wrote: > Hey Mathias, I know pgAdmin is free and you make this for free and all > that, but *please* don't make me a fool. Sure, encoding can change during > copy and paste, but > 1) pgAdmin V3.6 works OK, as I mentioned > 2) All other software works OK > > So, would you please check the query tool source for a missing > set-database-encoding? > > Thanks. > > Mathias Zajaczkowski <mathias.zajaczkow...@ubik.ch> ezt írta (időpont: > 2019. febr. 8., P, 15:58): > >> 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:zso...@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 >> >> >> >> 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 >> >
