UTF8 Arabic coding problem

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
laxman.ds
Premium Member
Premium Member
Posts: 66
Joined: Thu Mar 02, 2006 9:00 am

UTF8 Arabic coding problem

Post 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)
2 B 1 4 ALL
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Try ISO8859-6 for DataStage, which is the setting used for Oracle.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”