MQSeries.net :: View topic

vp_wmb · Posted: Wed Jul 22, 2009 7:48 pm Post subject:

Hi,

I've looked through the fourm and searched on the net and am still a bit confused how code pages and encoding work with character sets. I've tried the recommendations mentioned on the forum but none of them worked. My initial thought is that what i'm trying to do probably won't work but wanted to see what people on this forum thought. So here is the problem:

I have a message flow which creates a XML message with special characters embedded in the message.

I write the created message with a CCSID of 1208 and write it file and a mq queue.

I view the message in XML spy witha utf-8 declaration and i can see all of the special characters properly.

I write another flow to pick up the message from the queue and then debug the flow and the special characters appear fine.

I now write another flow to pick on the message from the queue and try and convert the xml message to write it into a element in a new xml message. However this fails and I get an error.

I've attached the code below along with the error:

The following is an example of the message that is creates a new xml message with the special character:
SET OutputRoot.MQMD.CodedCharSetId = 1208;
SET OutputRoot.XMLNSC.a.b = 'Ã˜';
SET OutputRoot.XMLNSC.a.c = 'Â£';
SET OutputRoot.XMLNSC.a.d = 'Ã';

The following is an example of the message that I try to create using the xml message above:

CREATE LASTCHILD OF OutputRoot.XMLNSC NAME 'Msg';
CREATE LASTCHILD OF OutputRoot.XMLNSC.Msg NAME 'Out';
SET OutputRoot.XMLNSC.Msg.Out.(XML.CDataSection) = CAST ASBITSTREAM(InputBody) AS CHARACTER CCSID 1208);

Now the converting from the input XML message to BLOB works, but the converting of BLOB to CHAR fails with the following message:
Source character ''9d'' in field ''3c613e3c623e9d3c2f623e3c633e9c3c2f633e3c643ea13c2f643e3c2f613e'' cannot be converted to Unicode from codepage '1208'.

The source character is an invalid code point within the given codepage.

My question is what code page supports this as I have looked across the forum and internet and cant seem to find anything that helps. Am I using the wrong code page? or am i missing something out? or is this just plain wrong?

It would useful if an explanation was given rather than "go to this link and try and find out yourself" as I've tried that and i've got nowhere!

Thanks in advance.