| Author |
Message
|
| Lavi |
 Posted: Tue Jun 02, 2009 9:03 pm Post subject: how the MQ Series Support Japanese Charecters |
 |
|
Newbie
Joined: 07 Jul 2008
Posts: 6
|
I am using Websphere Business Integration tool and MQ Series to transfer the messages from SAP system to mainframes (client).I have a
Q manager with CCSID 897 and the client Q manager CCSID is 500.. Client will send the Japanese Charecters via the mainframes MQ to WBI MQ.
We will be getting Japanense charecters (Khanchi and khatakana) which is double bytes charecters. Whether my MQ Series can handle/receive the Japanese charecters? Do we need to install anything inoder to receive/read the Japanese cahrecters in queues.
MQ Series verison is 5.3 |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Tue Jun 02, 2009 9:25 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
MQSeries can handle japnese characters...
i suppose the CCSID for japanese is 943 and for UTF-8 is 1208
does CCSID 500 support double byte japanese data ??
what CCSID/encoding the incoming messages(in MQMD) have ?
_________________
Cheers |
|
| Back to top |
|
|
| Lavi |
| Posted: Thu Jun 04, 2009 7:21 pm Post subject: |
|
|
Newbie
Joined: 07 Jul 2008
Posts: 6
|
Thanks for replying AkankshA...
Yes, MQ series can handle japanese charecters ...
The incoming messages CCSID is 500 (which is from Mainframes MQ Series).
The receiving queue (Websphere Business Intgeration MQ Series) CCSID is 897.
The Japanese charecters I will receive from the MQ (CCSID 500) will have double bytes and also single byte charecters.
Can you please help me, what are the changes do I need to do to accept the Japanese charecters? |
|
| Back to top |
|
|
| AkankshA |
| Posted: Thu Jun 04, 2009 8:56 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
what happens when you actually try to receive them over MQ ???
Do they get junked or are visible correctly ???
I m not a mainfranme person... I hv japanese chars coming in MQ on unix and i dint do anything since i already had QM in UTF-8 format.....
An expert might throw some more light..
_________________
Cheers |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Sun Jun 07, 2009 3:18 pm Post subject: Re: how the MQ Series Support Japanese Characters |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| Lavi wrote: |
| MQ Series verison is 5.3 |
Consider upgrading.
| Lavi wrote: |
| I have a Q manager with CCSID 897 and the client Q manager CCSID is 500. |
The QMgr ccsid identifies the encoding of the character fields within the MQMD header itself.
The MQMD ccsid identifies the encoding of the character data; it need not be related to the QMgr ccsid.
The sender must encode the character data as a sequence of bytes, before it puts the message on a queue. The sender must also set the MQMD ccsid (CodedCharSetId field), to indicate how it encoded the character data. If the sender does not do both of these correctly, the receiver may have problems decoding the character data. Otherwise, the receiver can accept the character data as is, or optionally convert it to a different ccsid.
| Lavi wrote: |
The incoming messages CCSID is 500 (which is from Mainframes MQ Series).
The receiving queue (Websphere Business Intgeration MQ Series) CCSID is 897.
The Japanese charecters I will receive from the MQ (CCSID 500) will have double bytes and also single byte charecters. |
No, they won't.
ccsid=500 refers to a single-byte character set, containing only Basic Latin and Latin-1 characters; it does not contain any Kanji or Katakana characters.
ccsid=897 refers to a single-byte character set, containing Basic Latin and Katakana characters; it does not contain any Kanji characters.
Neither of these ccsids accurately describe a mix of single- and double-byte character data.
How does the sender actually encode the character data? Some of the more likely character encodings include:- ccsid=1208 (UTF-8)
- ccsid=1200 (UTF-16BE)
- ccsid=1202 (UTF-16LE)
- ccsid=943 (JAPAN MIXED OPEN, S-JIS)
- ccsid=932 (JAPAN MIXED PC-DATA, S-JIS)
- ccsid=939 (JAPAN MIXED EBCDIC, SO/SI)
Unicode is preferable, as it's implemented more consistently. There are some minor variations in the implementations of the different JIS encodings, particularly between multiple vendors. |
|
| Back to top |
|
|
| aditya.aggarwal |
| Posted: Mon Jun 08, 2009 9:10 pm Post subject: |
|
|
Master
Joined: 13 Jan 2009
Posts: 252
|
Lavi Wrote
| Quote: |
| Do we need to install anything inoder to receive/read the Japanese cahrecters in queues. |
You need to install the Japanese character set in to Receiver queue manager O/S. Ask you O/S team to install the relevant chatacter set.
Your locale setting should also represent the Japanese language and character sets.
Cheers,
Aditya |
|
| Back to top |
|
|
|
|
