Fix the character sequence to be valid UTF8 before you restore it. I'm assuming you're restoring from a pretty old version of Postgres which did not do strict UTF8 character validation. Are you sure the data is encoded as UTF8 and not some other?
- [GENERAL] utf8 issues Felix Ivan Romero RodrÃguez
- Re: [GENERAL] utf8 issues Vick Khera
- Re: [GENERAL] utf8 issues Adrian Klaver