ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » IBM MQ Installation/Configuration Support » How do I change the Coded character set ID?

Post new topic  Reply to topic
 How do I change the Coded character set ID? « View previous topic :: View next topic » 
Author Message
sara
PostPosted: Tue Nov 13, 2007 6:14 am    Post subject: How do I change the Coded character set ID? Reply with quote

Newbie

Joined: 31 Oct 2007
Posts: 9

Hi,
I'm sending/reading messages encoded with ISO-8859-1, but I think that the MQ doesn't care...
I've found something called 'coded character set id' which I think is the parameter to change. But it is readonly on the queuemanager.

Does anyone know if this is the right parameter, how to change this and into what value?

Regards,
Sara
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Tue Nov 13, 2007 6:22 am    Post subject: Re: How do I change the Coded character set ID? Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

sara wrote:
Hi,
I'm sending/reading messages encoded with ISO-8859-1, but I think that the MQ doesn't care...


I think you're right. I think your application won't care either if you're using conversion

sara wrote:

I've found something called 'coded character set id' which I think is the parameter to change. But it is readonly on the queuemanager.


Because it's the CCSID of the platform on which the queue manager is installed.

sara wrote:

Does anyone know if this is the right parameter, how to change this and into what value?


You shouldn't want or need to. Are you using conversion and what results are you getting to make you think you need to change the CCSID? Are your messages turning up in the wrong CCSID in the receiving app and if so are you sure they're being sent in the right CCSID?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sara
PostPosted: Tue Nov 13, 2007 6:42 am    Post subject: Reply with quote

Newbie

Joined: 31 Oct 2007
Posts: 9

Thanks for a quick reply!

My original message contains the word Zürich, but when it has been received by the MQ and put on the queue again (I'm reading and writing to the same queue to simulate that a lot of messages are sent) the ü is something else. So I thought that it did some kind of encoding but did not manage to do it right.

The queue manger CCID has the value 437. I've tried to find a list of what that means, but failed...
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Tue Nov 13, 2007 6:50 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

sara wrote:
The queue manger CCID has the value 437. I've tried to find a list of what that means, but failed...


It's the number of the code page - 437 is Latin 8 I think (too lazy to look it up!)

How are you sending/receiving/viewing the messages? Is that doing any kind of conversion? The queue manager will only convert message body if it's requested to and the code page of the message doesn't match the code page of the queue manager.

Look at the actual message on the queue in hex form & see if this value is changing.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Nov 13, 2007 6:54 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

437 is Windows default codepage...
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Vitor
PostPosted: Tue Nov 13, 2007 7:07 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

jefflowrey wrote:
437 is Windows default codepage...


I knew I'd seen it somewhere....
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sara
PostPosted: Tue Nov 13, 2007 7:49 am    Post subject: Reply with quote

Newbie

Joined: 31 Oct 2007
Posts: 9

When I'm looking at the message in the MQ Explorer the message is encoded with 546 but the queuemanager has 437 as CCID... why is this? might 546 be ISO-8859-1?
The XML message looks like this
<?xml version="1.0" encoding="ISO-8859-1"?>
Back to top
View user's profile Send private message Send e-mail
jefflowrey
PostPosted: Tue Nov 13, 2007 7:52 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

MQMD.Encoding is not the same as MQMD.CodedCharSetID, and not the same thing as the XML encoding, either.

MQMD.Encoding is used for numeric values in the same way that the CCSID is used for character values.

Does your MQMD.Format = MQFMT_STRING? Did you issue GET with MQGMO_CONVERT?
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Vitor
PostPosted: Tue Nov 13, 2007 7:53 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

That means the XML is encoded as "Latin-1" (according to Mr Google).

If the message is 546 and your queue manager is 437 then you need to make sure the conversion happens when it's presented to your applcation (and you still havn't told us how you're sending, receiving and viewing these). Make sure the MQMD format is a string, and the receiving application is doing a get with convert. Mr Google's friend Mr Wikipedia says that the u-umlaut (apologies for the spelling!) is xFC in Latin-1 and x81 in 437.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sara
PostPosted: Wed Nov 14, 2007 7:54 am    Post subject: Reply with quote

Newbie

Joined: 31 Oct 2007
Posts: 9

Thank you for all your help!
I've now found the right parameter to use and it should in my case be 819.
//Sara
Back to top
View user's profile Send private message Send e-mail
fjb_saper
PostPosted: Wed Nov 14, 2007 3:32 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

sara wrote:
Thank you for all your help!
I've now found the right parameter to use and it should in my case be 819.
//Sara

819 is a default Unix platform CCSID (819 = ISO-8859-1)

For a little bit more information:
By default the messages get posted with the CCSID of the qmgr of they are being posted on. You can however override this by setting the CCSID (and encoding) on the message (MQMD), however the message content has to match its CCSID and encoding...

On the receiving side the default conversion (MQFMT_STRING & get with convert) will convert the message to the receiving qmgr's CCSID.
You can override this by putting the desired CCSID (1208 = utf-8 ) on the qmgr/qcf object used to connect.

Enjoy
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
PeterPotkay
PostPosted: Wed Nov 14, 2007 4:58 pm    Post subject: Reply with quote

Poobah

Joined: 15 May 2001
Posts: 7722

fjb_saper wrote:

By default the messages get posted with the CCSID of the qmgr of they are being posted on....

Except for MQ Client apps, in which case the messages get posted with the CCSID of the client's platform, by default.
_________________
Peter Potkay
Keep Calm and MQ On
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Nov 15, 2007 9:36 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

PeterPotkay wrote:
fjb_saper wrote:

By default the messages get posted with the CCSID of the qmgr of they are being posted on....

Except for MQ Client apps, in which case the messages get posted with the CCSID of the client's platform, by default.

Thanks Peter for straightening out that oversight.

I didn't check it but the same might appy to client gets as (IIRC) by default the CCSID on the client will be the one of the client plattform...
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
PeterPotkay
PostPosted: Thu Nov 15, 2007 1:10 pm    Post subject: Reply with quote

Poobah

Joined: 15 May 2001
Posts: 7722

fjb_saper wrote:
I didn't check it but the same might appy to client gets as (IIRC) by default the CCSID on the client will be the one of the client plattform...

That is correct.
_________________
Peter Potkay
Keep Calm and MQ On
Back to top
View user's profile Send private message
Nigelg
PostPosted: Fri Nov 16, 2007 2:22 am    Post subject: Reply with quote

Grand Master

Joined: 02 Aug 2004
Posts: 1046

Izzat so? Never a day goes by that I don't learn something new...
_________________
MQSeries.net helps those who help themselves..
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » IBM MQ Installation/Configuration Support » How do I change the Coded character set ID?
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.