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