On 8/14/19 2:39 AM, Daulat Ram wrote:
Hi Adrian ,
We have the below output. What we need to change.
I am not an ora2pg user so I don't know what to suggest for below. I
would say the best thing to do would be to file an issue here:
https://github.com/darold/ora2pg/issues
Along with the original error message include the below and the
settings, if any, for NLS_*, CLIENT_ENCODING from your ora2pg.conf file.
bash-4.2$ ora2pg -c ora2pg.bidder.conf -t SHOW_ENCODING
Current encoding settings that will be used by Ora2Pg:
Oracle NLS_LANG AMERICAN_AMERICA.AL32UTF8
Oracle NLS_NCHAR AL32UTF8
Oracle NLS_TIMESTAMP_FORMAT YYYY-MM-DD HH24:MI:SS.FF6
Oracle NLS_DATE_FORMAT YYYY-MM-DD HH24:MI:SS
PostgreSQL CLIENT_ENCODING UTF8
Perl output encoding ''
Showing current Oracle encoding and possible PostgreSQL client encoding:
Oracle NLS_LANG AMERICAN_AMERICA.WE8MSWIN1252
Oracle NLS_NCHAR WE8MSWIN1252
Oracle NLS_TIMESTAMP_FORMAT YYYY-MM-DD HH24:MI:SS.FF6
Oracle NLS_DATE_FORMAT YYYY-MM-DD HH24:MI:SS
PostgreSQL CLIENT_ENCODING WIN1252
bash-4.2$
thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
