| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Sbob <sbob(at)quadratum-braccas(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: DB Encoding question |
| Date: | 2022-08-22 16:41:59 |
| Message-ID: | 355682.1661186519@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Sbob <sbob(at)quadratum-braccas(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mladen Gogala | 2022-08-23 00:06:12 | Re: Postgresql 14 performance |
| Previous Message | Bruce Momjian | 2022-08-22 16:40:50 | Re: DB Encoding question |