Spanish characters loading incorrectly in to DB2

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 »

So these kind of issues are always about the character sets involved, source versus target. Any tool that does this kind of work needs to know both so that, when they are different, it can translate the characters properly between the two - unless they haven't been properly specified. When it thinks both character sets are the same the data is simply pushed over and you can see corrupted characters.

What are the character sets of both your source and your target?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply