ora2pg icon indicating copy to clipboard operation
ora2pg copied to clipboard

Published 20 hours ago • verified publisher icon darold

Not able to import oracle dump with hindi font data properly

Open chetan2211 opened this issue 2 years ago • 1 comments

Hello everyone, I'm stuck on one problem and it is that while importing oracle dump, I'm not able to restore hindi font data properly for ora2pg migration even when character set is AL32UTF8. So is there any solution where i can restore Oracle dump with hindi font data in a proper way? I'm using oracle 11g enterprise edition. Thank you in advance.

chetan2211 avatar May 26 '22 05:05 chetan2211

Normally using default NLS_LANG AMERICAN_AMERICA.AL32UTF8 and CLIENT_ENCODING UTF8 should work. Use direct data import to PostgreSQL, no intermediate dump to files.

If it doesn't work you can try using the following in ora2pg.conf

NLS_LANG    US7ASCII
ENCODING    SQL_ASCII

darold avatar Jun 13 '22 15:06 darold