Changing Postgres encoding from UTF8 to SQL_ASCII

[Brenden Cruikshank]

Hi All,

Hopefully this isn't a duplicate post, i'm not sure where my other post went.

I have a Postgres database server that's existed since the 2000s, and the encoding on all databases is SQL_ASCII.

I've tried a conversion from SQL_ASCII to UTF8 locally and then tried to import into GCP Cloud SQL and i'm getting errors like ERROR:  invalid byte sequence for encoding "UTF8": 0x96

I'm wondering if anyone knows how to convert Cloud SQL (postgres) from UTF8 to SQL_ASCII?

[Katayoon (Cloud Platform Support)]

Hi Brenden,

I should note that, here, we provide support for Google Cloud Platform-end products and not for PostgreSQL, however you may find many discussion threads like this one on Stack Overflow on how to change the database encoding.