Re: ERROR: invalid byte sequence for encoding

Hi,

Postgres database server is throwing an error while executing the sql to
fetch table definition, please report a bug here Link
<https://redmine.postgresql.org/projects/pgadmin4/issues>
Please add the steps/details required to re-produce the issue on
developer's machine along with sample table definition.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Jan 15, 2018 at 5:57 PM, André Burkhardt <
andre(dot)burkhardt(at)uni-jena(dot)de> wrote:

> Hi,
>
> -------- Original-Nachricht --------
> Betreff: Re: ERROR: invalid byte sequence for encoding
> Von: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
> An: André Burkhardt <andre(dot)burkhardt(at)uni-jena(dot)de>
> Datum: 15.01.2018 12:46
>
> > Hi,
> >
> > Could you please provide pgAdmin4.log file with debug mode on.
>
> See logfile with debug mode attached.
>
> > For more information check: https://www.pgadmin.org/faq/#8
> > (Rename/delete your previous log file, once you set the debug mode, try
> to
> > re-produce the issue in pgAdmin4 again and send us the log file)
> >
> > Also provide below information,
> > 1) Are you running pgAdmin4 as Desktop mode or Web mode?
>
> In this case pgAdmin4 is running in Web mode. But the error also occurs
> when running pgAdmin4 in Desktop mode on a Windows 10 Workstation.
>
> > 2) Postgres server version
>
> PostgreSQL 9.5.10
>
> > 3) OS details
>
> - Ubuntu Server 16.04 LTS
> - Apache 2.4.18
> - LANG=en_US.UTF-8
> - LANGUAGE=en_US:en
> - LC_*="en_US.UTF-8"
>
> >
> >
> > --
> > Regards,
> > Murtuza Zabuawala
> > EnterpriseDB: http://www.enterprisedb.com
> > The Enterprise PostgreSQL Company
> >
> >
> > On Mon, Jan 15, 2018 at 4:24 PM, André Burkhardt <
> > andre(dot)burkhardt(at)uni-jena(dot)de> wrote:
> >
> >> We are using pgAdmin 4 2.0/2.1. Allmost all of our databases using
> >> Encoding LATIN1. We have the problem, that when we want to show a table
> >> definition in the SQL-Tab, an error message pops up:
> >>
> >> Error retrieving the information - INTERNAL SERVER ERROR
> >> ERROR: invalid byte sequence for encoding "LATIN1":0x00
> >>
> >> Here some output:
> >>
> >> show client_encoding;
> >> client_encoding
> >> -------------------
> >> UNICODE
> >>
> >> show server_encoding;
> >> server_encoding
> >> ------------------
> >> LATIN1
> >>
> >> show lc_collate;
> >> lc_collate
> >> -------------
> >> de_DE
> >>
> >> Is there an solution?
> >>
> >>
> >
>