Page 1 of 1

UTF8 Arabic coding problem

Posted: Sun Jan 08, 2012 7:54 am
by laxman.ds
Hi Guys,

I have problem when I extract Arabic data from the source SQL server db and loading to oracle db (arabic data is not loading perfectly).
Source SQL server table has NLS UTF8 and the Oracle DB is (AR8ISO8859P6)
Can you please tell me what are the settings i have to try to load the arabic data into to Oracle DB (AR8ISO8859P6)

Posted: Sun Jan 08, 2012 3:18 pm
by ray.wurlod
Try ISO8859-6 for DataStage, which is the setting used for Oracle.