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

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 <zsoros(at)gmail(dot)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(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
>>
>