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 >
