Topic
  • 2 replies
  • Latest Post - ‏2013-10-24T12:34:37Z by lionell
lionell
lionell
13 Posts

Pinned topic Issues with code page.

‏2013-10-23T05:39:14Z |

Hi,

Little background on the issue.

 Broker - 7.0.0.3

O/s - Sun Solaris.

Message flow gets a xml message from .net application through MQ client connection, xml message has special characters in one of the values

The messgae flow threw a parsing error for various ccsid values which we tried setting in the .net application code, the only ccsid which came close to working was ibm1208 but the characters look different when it reaches the broker.

<value>BLAHBLAHBLAH€22 "ÁÃÅÇÉËÍÏÑÓÕ×ÙÛÝßÁÃÅÇÉËÍÏÑÓÕ÷ÙÛÝŸ</value>

When this message receives the broker the characters look different

ÃÃÃÃÃÃÃe>BLAHBLAHBLAH. â¬22 âÃÃÃ

While testing it locally on my laptop(windows 7.0.0.3 broker) ccsid of 1208 works perfectly.

Is there a way to find out the correct ccsid to be set for solaris environment for the characters in the message?

Thanks.

 

 
 

 

 

  • T.Amar
    T.Amar
    64 Posts

    Re: Issues with code page.

    ‏2013-10-24T06:53:55Z  

    Hi lionell,

     

    Parser can ignore some text by using 'CDATA'

    <![CDATA[ BLAHBLAHBLAH€22 "ÁÃÅÇÉËÍÏÑÓÕ×ÙÛÝßÁÃÅÇÉËÍÏÑÓÕ÷ÙÛÝŸ ]]>

    I think this will help you out.

     

    Looking forward,

    T.Amar.

    amar.it1226@gmail.com

     

  • lionell
    lionell
    13 Posts

    Re: Issues with code page.

    ‏2013-10-24T12:34:37Z  
    • T.Amar
    • ‏2013-10-24T06:53:55Z

    Hi lionell,

     

    Parser can ignore some text by using 'CDATA'

    <![CDATA[ BLAHBLAHBLAH€22 "ÁÃÅÇÉËÍÏÑÓÕ×ÙÛÝßÁÃÅÇÉËÍÏÑÓÕ÷ÙÛÝŸ ]]>

    I think this will help you out.

     

    Looking forward,

    T.Amar.

    amar.it1226@gmail.com

     

    Thanks Amar for your reply.

    cdata would not work for my scenario beacuse of reasons listed below.

    1.The message is a xml message and the tag i pasted in my question is one of the tags,  also the xml message has a tag with checksum value of all the tags.

    So i would need to calculate checksum and match the checksum from the request message, for calculating a checksum i would have to remove the cdata tag and which would result in message getting corrupted.

     

    2. The XML has to be converted to a different format [TDS] after calculating the checksum, each xml tag value gets converted to a tag in the TDS format, this would also result in data getting corrupted.

    Thanks.