Ora2pg data conversion issue while exporting the Data.

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

1.01k stars 343 forks source link

Ora2pg data conversion issue while exporting the Data. #1815

Open Purushotham2728 opened 2 weeks ago

Purushotham2728 commented 2 weeks ago

DBD::pg:: db pg_putcopyend failed :ERROR: invalid byte sequence for encoding "UTF8": 0x00vg : 11 recs/sec Context: copy content, line 1 at /usr/local/share/perl5/Ora2pg.pm line 16849 FATAL : ERROR : invalid byte sequence for encoding "UTF8": 0x00

darold commented 2 weeks ago

You should use the same encoding as defined in Oracle. Use action -t SHOW_ENCODING to show Oracle encoding and adjust NLS_* configuration directives in ora2pg.conf