Monday, July 30, 2018

[google-cloud-sql-discuss] Re: Migrating Postgresql server to SQL Cloud and SQL_ASCII encoding

Hi Brenden,


There is a likelihood that you have some Windows-1252-encoded text in your old database (0x96 encodes "dash" in that encoding). This issue is already reported to the PostgreSQL Issue tracker and it is recommended that you edit dump file there.


So, I recommend that you change your database encoding first and then follow the steps on Importing Data into Cloud SQL. As noted in your duplicate post, you may find many discussion threads like this one on Stack Overflow [4] on how to change the database encoding.


If the issue persists, you may post your full detailed question to Stack Overflow, using the supported Cloud tags.

--
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/81a2ce0a-baea-44ea-b4c8-354ec94b0032%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment