Ora2pg encoding error (ığşçöü)

[fatihsazan]

Hi,

We cannot complete the data transfer (ora2pg) because the object and relation name contains Turkish characters (ıüşğçö). Below you can find the relation name and the error.

Error ;

DBD::Pg::db do failed: ERROR:  column "▒denmemi▒_fatura_sayisi" of relation "n_rapor" does not exist
LINE 1: ...upation,ds_identitycard_type,ds_yearmonth,cip,vip,"▒denmemi▒...
                                                             ^ at /usr/local/share/perl5/Ora2Pg.pm line 9376.
[2022-05-30 18:22:42] ERROR: ERROR:  column "ÖdenmemiÞ_fatura_sayisi" of relation "n_rapor" does not exist
LINE 1: ...upation,ds_identitycard_type,ds_yearmonth,cip,,"ÖdenmemiÞ...
Aborting export...

My ora2pg.conf

NLS_LANG AMERICAN_AMERICA.WE8ISO8859P9 NLS_NCHAR WE8ISO8859P9

CLIENT_ENCODING LATIN5 BINMODE use open ':encoding(iso-8859-9)';

[darold]

How about if you keep all in UTF8 by keeping the default for NLS_LANG , NLS_NCHAR and CLIENT_ENCODING in ora2pg.conf? You just have to comment out the lines.