[google-cloud-sql-discuss] Changing Postgres encoding from UTF8 to SQL_ASCII

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?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fc1827d1-8a9d-42fa-863b-2a3711321dc4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.