Re: Converting an ASCII database to an UTF-8 database

I believe PostgreSQL treat UTF-8 and LATIN9 Differently.
When I tried to dump a db to a UTF-8 encoding and restore it
with UTF-8 encoding (also) it encountered problems with fields
that have unicoded values thus it stop from restoring the whole dump.

So I tried using LATIN9 encoding for both dump and restore.

I believe that LATIN9=UTF-8 encoding base on the DOCS.

I wonder why it is like that.