From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sbob <sbob@quadratum-braccas.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: DB Encoding question
Date: Mon, 22 Aug 2022 12:41:59 -0400
Message-ID: <355682.1661186519@sss.pgh.pa.us> (raw)
In-Reply-To: <3529b018-3fd6-0d60-02b1-06ee5db9ba82@quadratum-braccas.com>
References: <3529b018-3fd6-0d60-02b1-06ee5db9ba82@quadratum-braccas.com>
Sbob <sbob@quadratum-braccas.com> writes:
> We are converting from DB2 on the mainframe to PostgreSQL 14 in the
> cloud. We have been using IIDR to dump DB2 tables to CSV files and then
> using pg_loader / COPY to import the files. However the DB2 Encoding is
> EBCDIC and the PostgreSQL db encoding is UTF8, this is causing some rows
> / columns to fail when we try to load the data into PostgreSQL
You're going to need to run the data through an encoding conversion,
then.
> Will we be better off changing the PostgreSQL encoding to match the DB2
> database?
No, because Postgres doesn't support EBCDIC encoding.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, sbob@quadratum-braccas.com, pgsql-admin@lists.postgresql.org
Subject: Re: DB Encoding question
In-Reply-To: <355682.1661186519@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox