Sbob <sbob@xxxxxxxxxxxxxxxxxxxxx> 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
