| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Special Character Issue - ccsid 819 |
« View previous topic :: View next topic » |
| Author |
Message
|
| aaron_blade |
 Posted: Fri Jan 22, 2010 11:12 am Post subject: Special Character Issue - ccsid 819 |
 |
|
Apprentice
Joined: 21 Dec 2009
Posts: 29
|
Hi,
I an XML message I am getting a special character from DB. The returned value is '-WM –OE1' but while placing with in XML speacial character issue is occuring. Below is the special character.
– (0x96)
Can any one help me out??
-Thanks,
AAron.. |
|
| Back to top |
|
 |
| kimbert |
| Posted: Fri Jan 22, 2010 11:21 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
More info needed.
e.g. what 'issue' is occuring? |
|
| Back to top |
|
|
| aaron_blade |
| Posted: Fri Jan 22, 2010 11:43 am Post subject: |
|
|
Apprentice
Joined: 21 Dec 2009
Posts: 29
|
I am pulling some vlaues from Data base and embedding those values into XML, then sending XML to WTX map for transformation.
Issue is..
I am getting vlaue from DB and embedding the same into XML. XML is not forming completely because of this special character. Below is the XML message. Try copying in notepad and open in Brower, u will know what the error is. It will throw an error saying "An invalid character was found in text content. Error processing resource "
I used XML spy to check if it is of some special character and I was rt.. and I am not sure how to resolve this.
<WtxTransform><MapName>PO_WM_I_PU_006.mmc</MapName><MapParms>-WM –OE1</MapParms><DbSource>%3</DbSource></WtxTransform>
Please let me know if you need any more info. |
|
| Back to top |
|
|
| aaron_blade |
| Posted: Fri Jan 22, 2010 12:06 pm Post subject: |
|
|
Apprentice
Joined: 21 Dec 2009
Posts: 29
|
encoding="ISO-8859-1"
Using this encoding Iam able to open this XML. Could you help me out how can I implement using ESQL.
I am using this piece of code fo embedd DB value of '-WM –OE1' into XML.
SET wtxTransform = REPLACE(wtxTransform, '%2', CAST(Environment.variables.EndpointTransformation[epiIndex].TransformParms AS CHARACTER CCSID 819)); |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Fri Jan 22, 2010 2:54 pm Post subject: Re: Special Character Issue - ccsid 819 |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| aaron_blade wrote: |
Below is the special character.
– (0x96) |
That's the "EN DASH" (X'96') character. It looks similar to the ASCII "HYPHEN-MINUS" (X'2D') character, but it's not the same character. The dash character doesn't exist in the ISO-8859-1 character set.
Even if the conversion error gets resolved, what then? Does the message get passed to WTX, and does WTX know what to do if it encounters a dash character, or is it expecting a hyphen character instead?
If the character is really supposed to be a hyphen, then the source data is bad. Disable any Windows "smart quote" features that's replacing hyphens with dashes, before composing strings to put into the database.
Otherwise, if the character is really supposed to be a dash, then the correct CCSID is probably 1252, (Windows Latin-1). |
|
| 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
|
|
|
|
