MySQL Forums
Forum List  »  PostgreSQL

Failed to migrate from postgresql to mysql
Posted by: Slose Lin
Date: December 05, 2014 05:41AM

I have a table 'blog' in postgresql, and there are 7 columns in this table.
When migrate this table to mysql, I encourage an error as follows:

ERROR: Could not successfully convert USC-2 string to UTF-8 in table "blog" (column content).
Original string: "<"

the type of column "content" in postgresql is TEXT, and this column has HTML code as data. It seems that mysql migration tool can not perfectly convert HTML code to UTF-8 encoded string?

have any idea? thank you

Options: ReplyQuote

Written By
Failed to migrate from postgresql to mysql
December 05, 2014 05:41AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.