IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

International Characters in XML file

  • 1.  International Characters in XML file

    Posted 10/28/09 10:21 AM

    Originally posted by: vickey


    Hi,

    I have a scenario in which, the XML contains a international character like "é".

    Below is what present in XML.

    <?xml version="1.0" encoding="utf-8"?>
    <Insert>
    <crctr>asas </crctr>
    <crgt00>asdas</crgt00>
    <crval>5 invités au congrès asderader </crval>
    <cruser>asdasda </cruser>
    <crpid>ewaq </crpid>
    <crjobn>hhsjsjs</crjobn>
    <crupmj>1123</crupmj>
    <crupmt>1231</crupmt>
    <creups> </creups>
    </Insert>

    The value for the field "crval" is coming as "5 invités au congrès asderader " and has international character.

    In the type tree I have changed the code page at ItemSubclass->NativeLanguage->data language to LATIN-1. But still the record fails as "one or more inputs invalid.".

    After that I changed the encoding in XML as "ISO-8859-1" and it worked.

    But my question here is is there any way that I can handle these international characters in WTX type tree when the encoding in XML is still utf-8.

    Thanks for the help.

    Regards,
    Ramakrishna.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender