Accented char problem in XML output stage

ray.wurlod · Post by **ray.wurlod** » Tue Jan 06, 2009 3:36 pm

Welcome aboard.

Start by disabling operator combination. Until you've done that you have no idea which stage (operator) is generating the problem.

mgarg24 · Post by **mgarg24** » Tue Jan 06, 2009 5:27 pm

Thanks Ray ...

I checked it out after disabling operator combination. This error is coming from XML Output Stage.

I am fetching files possessing "ISO-8859-1" characterset and writing it into a different unix box with "UTF-8" characterset.

Regards,
Manish

ArndW · Post by **ArndW** » Tue Jan 06, 2009 6:12 pm

0xE9 in UTF-8 is the French e-egu character and that is present in Unicode, so the error is odd. You stated that you are sourcing from 8859-1 but that isn't what the error message states. Are you explicitly reading 8859-1?

mgarg24 · Post by **mgarg24** » Fri Jan 09, 2009 11:16 am

Thanks Everyone,

I got a workaround for this issue. We are converting input file present in "ISO-8859-1" format to "UTF-8" format using unix command and then passing the file to datastage to create XML file.

srinivas123 · Post by **srinivas123** » Thu Mar 03, 2011 9:19 am

Hi,

Could you please let me know the commands /methods used to convert the file to UTF8 in unix?

Thanks

chulett · Post by **chulett** » Thu Mar 03, 2011 10:21 am

Oddly enough, it is "iconv".