MQSeries.net :: View topic - utf-8 xml conversion into blob

Nandi · Posted: Thu Sep 29, 2005 7:14 am Post subject: utf-8 xml conversion into blob

Hi...
I am new to WBI and also to ESQL, but I need to solve a problem.

Xml messages are arriving to a queue, encoded in utf-8 (although inside the xml it says encoding="utf-16". I am not sure how this impacts the whole thing, but even if I change it into utf-8 everything is the same)

there is an ESQL code that looks like this:
SET messageChar = CAST(ASBITSTREAM(InputRoot.XML) as CHARACTER ccsid 1208);

There are two problems, that I have.
First, if there is some string like 'M&C', (this of course is M&C, but because of xml specification, the sign & has to be &), then when I load it into the database it will remain '&', but what I need is '&'.
While debugging the message internally it looks like '&', so it is picked up by WBI correctly from the xml, but finally it is wrong again.
I hope this was clear.

The other problem I have (which is easier to solve I hope) is that I am trying to insert some more unique characters like 'Ã©Ã¡oÃºÃ¶Ã¼Ã³Ã_Ã†_ÃŸ_Ã_Ã¦_Å’_Å“_Å ' (I am not sure you will see everythin in this post).
As everything looks like to be utf-8, I dont get why it gives me a conversion error. It should get processed, I would say, but not.

If anyone has some ideas on these I'd be gratefull. I was thrown into this WBI project, and I am stuck a little bit.
please help!