Redmine -> Mantis migration from MySql to Postgres UTF8 failure
Added by Mark Stahler almost 15 years ago
I am trying to migrate from Mantis to Redmine. Everything works perfectly if I import from Mantis MySql to Redmine MySql. I am having several problems migrating from Mantis MySql to Redmine Postgres (which is the ideal solution).
During the import several bugs have failed to import, most commonly due to a weird backquote or quote character ( ’ ). MySql datatbase and table are set to utf8 encoding, so is Postgres.
PGError: ERROR: invalid byte sequence for encoding "UTF8": 0x92
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
client_encoding in postgres.conf is set to uft8, same error when it was sql_ascii.
If anyone has a recommendation I would appreciate it.