| Author |
Message
|
| mhashkhan |
 Posted: Mon Feb 10, 2014 10:24 pm Post subject: EBCDIC to ASCII Conversion |
 |
|
Apprentice
Joined: 01 Dec 2008
Posts: 28
|
Hi
I have a problem where my input XML message is EBCDIC (CodePage 37 & CCSID 1208) having Chinese characters in the payload and I am trying to convert it to ASCII/UTF-8 format.
I have tried to change CCSID in MQMD & MQRFH2 but still the output is coming as EBCDIC only.
MB Version is 7.0.0.4 & I am using ESQL.
Please guide |
|
| Back to top |
|
 |
| MQEnthu |
| Posted: Mon Feb 10, 2014 11:05 pm Post subject: |
|
|
Partisan
Joined: 06 Oct 2008
Posts: 329
Location: India
|
| Quote: |
I have a problem where my input XML message is EBCDIC (CodePage 37 & CCSID 1208) having Chinese characters in the payload and I am trying to convert it to ASCII/UTF-8 format.
I have tried to change CCSID in MQMD & MQRFH2 but still the output is coming as EBCDIC only. |
Are you trying to set the CCSID in the flow? What is the CCSID (MQRFH2) of the message when it reaches output queue?
Also what is the encoding mentioned in XML declaration -for both input and output?
_________________
-----------------------------------------------
It is good to remember the past,
but don't let past capture your future |
|
| Back to top |
|
|
| zpat |
| Posted: Mon Feb 10, 2014 11:08 pm Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
You can try setting convert on the MQ input node advanced properties.
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error. |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Feb 11, 2014 12:48 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| my input XML message is EBCDIC (CodePage 37 & CCSID 1208) |
That does not make sense. Code page 37 is an EBCDIC code page.
CCSID 1208 is UTF-8. So two questions:
- which code page does your input message *claim* to be in ( in its XML declaration )?
- which code page is it *actually* in?
_________________
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 |
|
|
| fjb_saper |
| Posted: Tue Feb 11, 2014 8:09 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
What is the CCSID value in the properties before output ? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
