| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Special Character Issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| shyamkumarsharma001 |
 Posted: Thu Jul 03, 2014 8:03 am Post subject: Special Character Issue |
 |
|
Novice
Joined: 24 May 2011
Posts: 18
|
Hi,
We have an issue with a character coming in EBCDIC data. source CCSID is 500.
We are sending the same CCSID in output which is a XML data after conversion.
The issue is with 'Ñ' character in one of the source field. When we see the output data in output queue after converting the data to ASCII, we are able to see 'Ñ' in the data. But when it reaches Datapower, it is getting converted to 'μ'.
Now, when we hardcode 'Ñ' in that field in ESQL, it works fine in DataPower.
Wanted to know if ESQL sets the value in field differently when we hardcode and when we map from Input field?
Appreciate your help.
Thanks. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Thu Jul 03, 2014 9:34 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Only way to verify:
After serialization check CCSID and hex value of offending character...
If in XML why still use CCSID 500 and not translate to UTF-8 ?
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kimbert |
| Posted: Thu Jul 03, 2014 12:20 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
You will need to understand how your 'special characters' are represented as bytes in CCSID 500 ( on the input and output queue ).
You should also put a Trace node after the input node and before the output node, to check the UTF-16 ( Unicode ) representation of the character within the message flow.
There are no shortcuts here - you need to understand the data all the way down to the bytes if you want to be sure that you have fixed it.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| shyamkumarsharma001 |
| Posted: Mon Jul 28, 2014 7:57 am Post subject: |
|
|
Novice
Joined: 24 May 2011
Posts: 18
|
| Thank you guys. You really helped me solving the issue. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
