DB Encoding question

[Sbob <sbob@xxxxxxxxxxxxxxxxxxxxx>]

All;


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


Will we be better off changing the PostgreSQL encoding to match the DB2 
database? Will this cause other issues down the road? Is there a 'best 
practice' for this use case?


Thanks in advance