Invalid character found converting string

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
mayura
Participant
Posts: 40
Joined: Fri Aug 01, 2008 5:58 am
Location: Mumbai

Invalid character found converting string

Post by mayura »

Invalid character fond converting string from code page UTP-8 to unicode substituting.

Data type is char.
Input is sequential file

Reason might be: any invalid character in input file like japnese,etc..

Solution please.
Mayura
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

There is no magic solution possible. If the UTF-8 (I assume that was a typo in your original post) character is not mapped to the Unicode counterpart then it can't be represented.

Some of your choices are:
- use UTF-8 everywhere to avoid conversion to Unicode
- Ignore the warning
- Convert these characters to another value prior to converting to Unicode
- Change the UTF-8 mapping table in datastage (quite complicated)

The process starts off with the answer to "Do you need these characters"?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Ray, I think the humor in your Japanese text is going to be lost on almost everyone here - but I liked it :)
Post Reply