| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Reading Arabic from ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqued |
 Posted: Thu Jan 30, 2014 11:57 pm Post subject: Reading Arabic from ESQL |
 |
|
Novice
Joined: 27 Feb 2013
Posts: 14
|
Hello All,
I am on broker version 8001 on windows 64 2008 and was trying to read arabic data from a sybase database from a message flow [using Datadirect sybase driver] starting with a timeout notification node. Had read through the posts with similar issue and had tried changing the queuemanager CCSID to 1208.
But still the data is being read as junk like ÚÒÃÒà ÇáÚãÃá¡ . A passthru statement is being used to read the data.
If i change the OS system locale to Arabic it works fine, which i am sure is not the correct way. Please help to understand what i have missed.  |
|
| Back to top |
|
 |
| kimbert |
| Posted: Fri Jan 31, 2014 2:56 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| still the data is being read as junk like ÚÒÃÒà ÇáÚãÃá¡ |
How do know? What program are you using to view the data?
It is quite common for people to think that their character data has been wrongly decoded, but often it is their text viewer that is decoding the characters incorrectly.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| mqued |
| Posted: Fri Jan 31, 2014 5:48 am Post subject: |
|
|
Novice
Joined: 27 Feb 2013
Posts: 14
|
Hello kimbert,
I have checked it as below
1. Debugging via Toolkit
2. Writing to file using trace node
3. HTTPRequest with arabic\english as querystring (with QueryStringCCSID as 1208). The receiving application also got junk.
The default QM CCSID was 437, which i changed to 1208 but with no effect.After switching to arabic locale the QM CCSID is 1256 (Arabic) and it works fine. |
|
| Back to top |
|
|
| hotrock026 |
| Posted: Sun Feb 23, 2014 10:51 am Post subject: The default QM CCSID was 437, which i changed to 1208 but wi |
|
|
Apprentice
Joined: 23 Feb 2014
Posts: 38
|
Dear mqued,
to read the arabic character try the ccsid 1089 and encoding 546 , this will help u to read the arabic characters....  |
|
| 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
|
|
|
|
