| Author |
Message
|
| gagan.maverick |
 Posted: Wed Oct 14, 2015 5:12 am Post subject: Handling ä character |
 |
|
Acolyte
Joined: 30 Sep 2014
Posts: 50
|
| Hi , we have a req in which we are sending xml file with ccsid 1208 to broker and then in esql i am transforming it to a csv file. When the message leaves the system the ccsid is 1208 and encoding is 273 . in debugger i can see ä in my text but once it reaches the customer server in excel file its getting converted to ä |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Oct 14, 2015 5:15 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Perhaps you should examine the method that the file is getting sent to the customer, rather than how you are building the message.
Perhaps you should test the output of the flow on a local system, rather than trying to debug it after it's left your organization.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Oct 14, 2015 5:16 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
What are the values of:
OutputRoot.Properties.CodedCharSetId
and what are the equivalent properties on the file node?
Are you writing different CCSIDs with the same DFDL message/flow? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| gagan.maverick |
| Posted: Wed Oct 14, 2015 5:26 am Post subject: |
|
|
Acolyte
Joined: 30 Sep 2014
Posts: 50
|
| Hi the OutputRoot.MQMD.CodedCharSetId = 1208; and i am sending my message to queue not file and the receiver system is picking up the files from there |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Oct 14, 2015 5:32 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
What does amqsbcg show for the message?
Is the other side doing a get-with-convert?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| gagan.maverick |
| Posted: Wed Oct 14, 2015 5:35 am Post subject: |
|
|
Acolyte
Joined: 30 Sep 2014
Posts: 50
|
| I just used one local queue and saved the message and opened the contents in excel file , i am getting the same error , in debugger its not showing but while creating the csv file its there |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Oct 14, 2015 5:47 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| gagan.maverick wrote: |
| I just used one local queue and saved the message |
How? With what utility/application? Did this do a get with convert or not, and if so, what code page would it have been converted to?
| gagan.maverick wrote: |
| and opened the contents in excel file |
Separate and distinct to the above questions, what does Excel do when you open a text file with an exotic (non-Latin ASCII) character in it? How does it convert it / display it / process it?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Oct 15, 2015 4:18 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you tried using CCSID 1252 as output CCSID?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
