XML-Input Stage: wrong UTF-8 encoding
Posted: Thu Apr 19, 2007 6:20 am
Hi All,
my Server job reads an XML file with correct uft-8 encoded character (i.e. the Trade Mark symbol is correctly encoded with the 3 bytes e284a2). After the XML-Input stage, that split not all data, but some xpaths, I found not correctly character encoded (the same TM symbol is transormed with '1a' character). For this test I used the useful editor fhred to see the encoded data.
I've also tryed to set in the job parameter a user variable called "NLS_LANG" with value 'American_America.WE8ISO8859P1' or 'AMERICAN_AMERICA.UTF8' or 'AMERICAN_AMERICA.WE8MSWIN1252' but seems that the xml stage does not care this variable.
Any help will be apreciated!
Thanks,
Andrea
my Server job reads an XML file with correct uft-8 encoded character (i.e. the Trade Mark symbol is correctly encoded with the 3 bytes e284a2). After the XML-Input stage, that split not all data, but some xpaths, I found not correctly character encoded (the same TM symbol is transormed with '1a' character). For this test I used the useful editor fhred to see the encoded data.
I've also tryed to set in the job parameter a user variable called "NLS_LANG" with value 'American_America.WE8ISO8859P1' or 'AMERICAN_AMERICA.UTF8' or 'AMERICAN_AMERICA.WE8MSWIN1252' but seems that the xml stage does not care this variable.
Any help will be apreciated!
Thanks,
Andrea