Postgres Pro
Downloads
Home   >   mailing lists

Re: Converting an ASCII database to an UTF-8 database - Mailing list pgsql-general

From Jan Cruz
Subject Re: Converting an ASCII database to an UTF-8 database
Date
Msg-id 493da2780602180006x47dac70fk5acffd1e59f699cc@mail.gmail.com
Whole thread Raw
In response to Re: Converting an ASCII database to an UTF-8 database  (Rick Gigger <rick@alpinenetworking.com>)
Responses Re: Converting an ASCII database to an UTF-8 database  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: "Jan Cruz"
Date:
Subject: Migration using pg_restore
Next
From: "Jan Cruz"
Date:
Subject: PostgreSQL Functions / PL-Language