XML Input stage - necessary codepage changes?
Posted: Tue Dec 21, 2010 1:37 am
Hi,
we have a working job which selects data from DB2 and sends it through a XML-Input stage.
This jobs works fine in DS 7.5.3 but after migrating to DS 8.1. we get problems with the german special characters which are no longer readable.
So we got some kind of codepage problem.
Is there anypone who has experienced the same behaviour or does anyone know what has changed in the XML Input stage between the DS versions?
Some tests we aready did:
Thanks in advance
kind regards
Michael
we have a working job which selects data from DB2 and sends it through a XML-Input stage.
This jobs works fine in DS 7.5.3 but after migrating to DS 8.1. we get problems with the german special characters which are no longer readable.
So we got some kind of codepage problem.
Is there anypone who has experienced the same behaviour or does anyone know what has changed in the XML Input stage between the DS versions?
Some tests we aready did:
- * We are able to extract the data from DB2 and write it to a file (wwithout XML stage) without problems.
- * If we do the same wit an additional XML Input stage the data in the file is goofed up
- * If the codepage for the job is changed to UTF8 and the data is read as NVARCHAR (which in my eyes is strange for a DB2 database) from DB2 the data in the file looks fine when doing a view from the stage but it is goofed up when you look into the file from the OS
Thanks in advance
kind regards
Michael