Postgres Pro
Downloads
Home   >   mailing lists

Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3 - Mailing list pgadmin-support

From richard coleman
Subject Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3
Date
Msg-id CAGA3vBv9riS5mvBnwYwnPxJV4psAY3dVp8Dc1T=rx6YuKZ9FvA@mail.gmail.com
Whole thread Raw
In response to Re: Import/Export failure due to UTF-8 error in pgAdmin4 but not in pgAdmin3  (Nanina Tron <nanina.tron@icloud.com>)
List pgadmin-support
Tree view
Nanina, 

If you can do it through the psql prompt, then the problem is most likely pgAdmin4, otherwise you might want to get in touch with the postgreSQL devs/support lists.

For example, you can run the COPY command both with and without the HEADERS option and see if that works.

I hope that helps,

rik. 

On Wed, Jan 9, 2019 at 4:59 AM Nanina Tron <nanina.tron@icloud.com> wrote:
Hi,
thanks for trying. Yes the backup included the invalid data, but we've just found the problem.
The 'special' characters in the data are handled just fine, but not if they are present in the column names.
So does pgAdmin handle both data differently or is it Postgres? I thought if the db is encoded UTF8 the this wouldn't be a problem.
best
Nanina


Am 08. Januar 2019 um 18:16 schrieb Dave Page <dpage@pgadmin.org>:

On Tue, Jan 8, 2019 at 8:55 PM Nanina Tron <nanina.tron@icloud.com> wrote:


Hi,

yes thank you I will scan the table so at least I will see the 'bad' characters. We will see how many there are.
Sorry, i forgot to append the data.

Thanks. Did that include the "bad" data? I can load it just fine into
a SQL_ASCII database (which I'd expect, as there's no encoding
checks), or a UTF-8 database, and I can successfully export the table
in both cases.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-support by date:

Previous
From: Murtuza Zabuawala
Date:
Subject: Re: "Statistics" tab is very slow
Next
From: Murtuza Zabuawala
Date:
Subject: Re: "Statistics" tab is very slow