Reading a character using the correct charset

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
BSridhar
Participant
Posts: 4
Joined: Fri May 25, 2018 9:53 am

Re: Reading a character using the correct charset

Post by BSridhar »

Hi,

Did you got the solution for this? I have same requirement. Kindly share the thought/approach you used.

Thanks
DSUser2000
Participant
Posts: 42
Joined: Tue Oct 20, 2009 8:36 am

Post by DSUser2000 »

You need to use "ustring" in your schema file, so a unicode string. Then it should work fine. You can even define the charset per column like this:

Code: Select all

(
Field1:ustring[10]{charset="windows-1252"};
)
If all does not work: Use iconv to convert to Unicode and read this with an "External Source" stage.
Post Reply