Greetings, issue created: https://redmine.postgresql.org/issues/3979
I've given it high priority because this bug corrupts inserted data as well. (FYI: no copy-paste this time, I've typed all commands into pgAdmin 4 V4.2.) Sincerelly, Zoltán Sörös Akshay Joshi <akshay.jo...@enterprisedb.com> ezt írta (időpont: 2019. febr. 10., V, 5:36): > 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 >>> >>
