| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problem with Hungarian characters in XML. |
« View previous topic :: View next topic » |
| Author |
Message
|
| sunny_30 |
 Posted: Mon Jan 07, 2008 5:03 pm Post subject: Problem with Hungarian characters in XML. |
 |
|
Master
Joined: 03 Oct 2005
Posts: 258
|
Hi,
A Java-client-app(SAP XI) connecting to the server QM on AIX, is writing XML with Hungarian characters inside it. This is a Europian client putting XML messages onto the MQ-Server based in US which I manage.
Server-Environment: MQ- 6.0.2.2
MQ-Server-OS: AIX 5.3
Problem is that few of the Hungarian characters are getting truncated in the MQ-message when the message is PUT.
Eg: String "Milánói m." is cut short to "Mil m".
MQMD format on the MQ-message is set to MQFMT_STRING.
MQMD CCSID on the MQ-message is set to 912.
CCSID on the Server QM is set to default 819.
MQMD Encoding on the MQ-message is set to 273.
The XML starts with:-- "<?xml version="1.0" encoding="iso-8859-2"?>"
From the help-documentation, I verified the code-set name ISO 8859-2 corresponds to CodePage CCSID 912.
I tried to convert the MQ-message back to original(if I can) using a Broker-flow, tried converting in the MQMD Input node reading the XML as BLOB. Tried converting in the Compute-node, setting the OutputRoot XML-Encoding, MQMD-Encoding & CCSID values. But all in vain.
No matter whatever I try, the string "Mil m" is not converting back to "Milánói m" on my end.
Im also not sure what might be the problem in the SAP-XI application that is writing the MQ-message.
Please help.
Thanks,
-Sunny |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Mon Jan 07, 2008 8:40 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
See if SAP XI can write the message in UTF-8 or in Unicode (CCSID 1200).
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| sunny_30 |
| Posted: Tue Jan 08, 2008 6:33 am Post subject: |
|
|
Master
Joined: 03 Oct 2005
Posts: 258
|
Saper, Thanks for your reply.
The change is made on the MQ-client (SAP-XI) for MQMD.CCSID->1208.
But the XML still looks to carry the "<?xml version="1.0" encoding="iso-8859-2"?>"
I tried to convert the message to CCSID-912 in Broker, but of no success.
The Hungarian characters are still not visible.
Should the XML come as "<?xml version="1.0" encoding="UTF-8"?>" & CCSID-> 1208?
Later, Do I convert the message to CCSID-912 & "<?xml version="1.0" encoding="iso-8859-2"?>" inside the Broker to make the Hungarian-characters visible?
Thanks,
Sunny. |
|
| Back to top |
|
|
| ling_71_99 |
| Posted: Tue Jan 08, 2008 7:10 am Post subject: Try the UTF8 in XML |
|
|
Novice
Joined: 19 Nov 2007
Posts: 11
Location: Canada
|
Leave the CCSID and encoding as you did before. Try to convert the XML header to UTF8 in broker. Here is the example code:
SET OutputRoot.XMLNSC.(XMLNSC.XmlDeclaration)*.Version = 1.0;
SET OutputRoot.XMLNSC.(XMLNSC.XmlDeclaration)*.Encoding = 'UTF-8';
SET OutputRoot.XMLNSC.(XMLNSC.XmlDeclaration)*.Standalone = 'yes';
Good luck.
_________________
Mike |
|
| Back to top |
|
|
| sunny_30 |
| Posted: Tue Jan 08, 2008 1:08 pm Post subject: |
|
|
Master
Joined: 03 Oct 2005
Posts: 258
|
Thank you Saper & Ling. It worked!!
Hungarian characters are now visible..
It worked both ways:--
1) SAP-XI(as MQ-client) has put XML messages with XML-encoding "UTF-8" & CCSID-1208. On my side, Broker did the conversion to XML-encoding "ISO-8859-2" & CCSID-819 / CCSID-912.
2) SAP-XI has put XML messages with default CCSID of the MQ-Server-819 & XML encoding set to "UTF-8". Eliminated the use of the intermediary Broker-flow.
But, Im still trying to understand how it worked. Is there a general rule I can follow..
Can you please explain on how the MQMD.CCSID, MQMD.Encoding & the XML.Encoding work in a combination for a MQ-message?
Is it different if the Sender-App is connecting as a MQ-client ?
When exactly wd the receiver-app do a MQGMO_CONVERT?
-Sunny. |
|
| 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
|
|
|
|
