|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
CCSID Issue |
« View previous topic :: View next topic » |
Author |
Message
|
sido |
Posted: Wed Feb 04, 2004 5:35 pm Post subject: CCSID Issue |
|
|
Novice
Joined: 02 Feb 2004 Posts: 23
|
Our project has the following scenario :
1) Sending Adapter on the Mainframe
2) Configuration Manager on the Windows NT
3) Broker on AIX
I have set the 'Convert' option on the Advanced Tab on the Input Queue and want to know if I have to specify the CCSID/Encoding whenever I use a 'Cast'.
Also, in my case what would the CCSID/Encoding be? |
|
Back to top |
|
 |
JLRowe |
Posted: Thu Feb 05, 2004 3:50 am Post subject: |
|
|
 Yatiri
Joined: 25 May 2002 Posts: 664 Location: South East London
|
I think the convert option on the input node tells MQSeries to perform the code page conversion. Otherwise, MQSI performs the conversion.
I don't think you need to worry about this. Just let MQSI deal with it. MQSI will convert all messages to/from unicode, which is what ESQL uses internally to represent CHAR's.
Your adaptors though, do need to perform the following when manipulating MQ messages:
1) Use a format of MQSTR, this informs MQSeries the message contents are a string anc can be converted between code pages.
2) Set the CCSID correctly, MQ supplies a default which is the queue manager default CCSID, but this may not always be correct. |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Feb 05, 2004 6:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
However, if you are explicitly casting from BLOBs to CHARs, or vice versa, you should specify a CCSID - otherwise you will get a string that contains the byte-to-hexchars representation of the field (X'AFCD0729...'). And if you're using Create Field...Parse, it's an even better idea.
Usually, using InputRoot.Properties.CodedCharSetId is fine. _________________ I am *not* the model of the modern major general. |
|
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
|
|
|
|