I have a postgresql (version 8.1) database that has the encoding set to SQL_ASCII, combined with several apps that some are running using UTF8 and some with LATIN1. With this scope I have a database with the data divided in LATIN1 and UTF8.
I have the difficult task to deploy a brand new server, running PostgreSQL 9.3 with the database with the UTF8 encoding. But I'm stuck!
Here is what I have tried so far with no success:
- pg_dump forcing UTF8: error converting non-utf8 to utf8
- pg_dump forcing LATIN1: no error during dump or restore, but the characters with accentuation are totally wrong
- pg_dump forcing LATIN1 and conversion with iconv to UTF8: same error as above