| Author |
Message
|
| busy_chap |
 Posted: Tue Nov 06, 2007 8:38 am Post subject: Broker is not escaping special character like a Euro Sign |
 |
|
Acolyte
Joined: 18 May 2006
Posts: 69
|
Hello all,
The broker on AIX receives a Euro symbol in the input message and the message Domain on the input queue is MRM. I have gone through the previous posts and changed the CCSID to
SET OutputRoot.MQRFH2.CodedCharSetId = 923;
but I see a dot in the output message when viewed through char or Hex in RFHUTIL
<LINE_DESCR>Num del 15/05/2007.</LINE_DESCR>
but I want to see
<LINE_DESCR>Num del 15/05/2007</LINE_DESCR>
Any ideas? |
|
| Back to top |
|
 |
| busy_chap |
| Posted: Tue Nov 06, 2007 9:38 am Post subject: |
|
|
Acolyte
Joined: 18 May 2006
Posts: 69
|
Looks like the value was not printed correctly above.
I wanted to see & # 127; in the space of that little square |
|
| Back to top |
|
|
| bhaski |
| Posted: Tue Nov 06, 2007 10:30 am Post subject: |
|
|
Voyager
Joined: 13 Sep 2006
Posts: 78
Location: USA
|
| Can you Open the XML with the above special character using Browser? cos that is not supported by XML. If you want to make it to support? If it is not supported by Browser, you cannot deal such kind of this directly. Need to do some other way to do the conversion. |
|
| Back to top |
|
|
| busy_chap |
| Posted: Tue Nov 06, 2007 10:55 am Post subject: |
|
|
Acolyte
Joined: 18 May 2006
Posts: 69
|
| As suggested by you , I opened with explorer and saw that little box. Can you give me any suggestions or ideas of how to make it work? |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue Nov 06, 2007 11:22 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi busy_chap,
Look at the user trace in your flow...if the euro symbol is showing correctly there, then try to save the output file as UTF-8 and view it.
Else if the symbol in the flow itself is not showing right, then you need to make the NLS_LANG setting in your .profile as ISO8859, or something like that 
Regards. |
|
| Back to top |
|
|
| busy_chap |
| Posted: Tue Nov 06, 2007 11:32 am Post subject: |
|
|
Acolyte
Joined: 18 May 2006
Posts: 69
|
Hi elvis_gn,
In my trace , the euro symbol looks something like
(0x01000000):LINE_DESCR = (
(0x02000000): = 'Num. 00043592 del 15/05/2007Ç'
It doesn't look like a Euro for sure.
I am not clear about the changes you sugegsted. what is a .profile? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Nov 06, 2007 11:47 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
In order for the sign to pass out of the flow correctly, you need to ensure that
a) there is a valid Euro sign character in codepage 923
b) that there is a valid translation between Broker's native 1208 and the 923 codepage, that includes the Euro sign character
c) that you have properly populated the Euro sign in 1208
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Nov 06, 2007 3:10 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| jefflowrey wrote: |
In order for the sign to pass out of the flow correctly, you need to ensure that
a) there is a valid Euro sign character in codepage 923
b) that there is a valid translation between Broker's native 1208 and the 923 codepage, that includes the Euro sign character
c) that you have properly populated the Euro sign in 1208 |
Euh... Jeff isn't the broker native in 1200 unicode ?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
