Re: DB Encoding question

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