Issue with Special Character while loading data into Oracle

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Characterset issue.

What is the characterset of your target database?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Try checking NLS_DATABASE_PARAMETERS in oracle for characterset and match NLS_LANG environment variable to that.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Top
Post Reply

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