Postgres Pro
Downloads
Home   >   mailing lists

SQL_ASCII support (or lack thereof) - Mailing list pgadmin-support

From richard coleman
Subject SQL_ASCII support (or lack thereof)
Date
Msg-id CAGA3vBty=aCUm_PCAZTqGSBjtQ556L0rHQK0_PzOua2BZRhuoA@mail.gmail.com
Whole thread Raw
Responses Re: SQL_ASCII support (or lack thereof)  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support
Tree view
Why is pgAdmin 4 so hostile to SQL_ASCII databases?

We have several production databases dating back to 9.1 that are SQL_ASCII encoding but in pgAdmin4 I am constantly having to clean up non UTF8 data.  The same data works just fine in the pgAdmin3 series.

Running the same query in psql yields the expected results, but in this case I get:

"ERROR:  invalid byte sequence for encoding "UTF8": 0xc9 0x4f
SQL state: 22021" 

in pgAdmin4.

If I remove the offending characters then pgAdmin4 returns a result set.  The database is SQL_ASCII encoded, pgAdmin4 shouldn't care that there are non UTF8 characters present.


Thanks, 

rik.




pgadmin-support by date:

Previous
From: McDonaldR
Date:
Subject: Error on accessing SQL tab for triggers
Next
From: Dave Page
Date:
Subject: Re: SQL_ASCII support (or lack thereof)