Re: pgAdmin 4 V4.2 and non-unicode database

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(dot)zajaczkowski(at)ubik(dot)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:zsoros(at)gmail(dot)com]
> *Sent:* vendredi 8 février 2019 14:23
> *To:* pgadmin-support(at)lists(dot)postgresql(dot)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
>