|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
how to change CodeCharSetID and Encoding |
« View previous topic :: View next topic » |
Author |
Message
|
hoannh |
Posted: Mon Aug 21, 2006 5:54 pm Post subject: how to change CodeCharSetID and Encoding |
|
|
 Newbie
Joined: 12 Jul 2006 Posts: 7
|
Hi All!
When i designed a Message Flow Project. I used MQInput, when i debuged it: the encoding and CodeCharSetID of MQInput is 546,437. It's not Unicode. I want to change it to Unicode. Can anybody show me the solution?
Many thanks. |
|
Back to top |
|
 |
fjb_saper |
Posted: Mon Aug 21, 2006 7:49 pm Post subject: Re: how to change CodeCharSetID and Encoding |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
hoannh wrote: |
Hi All!
When i designed a Message Flow Project. I used MQInput, when i debuged it: the encoding and CodeCharSetID of MQInput is 546,437. It's not Unicode. I want to change it to Unicode. Can anybody show me the solution?
Many thanks. |
Create a message with unicode content and set the ccsid on the message...
Enjoy  _________________ MQ & Broker admin |
|
Back to top |
|
 |
hoannh |
Posted: Tue Aug 22, 2006 2:15 am Post subject: |
|
|
 Newbie
Joined: 12 Jul 2006 Posts: 7
|
Hi
My Message is a XML File. (encoding =UTF- . I want to set the CodeCharSetID of MQinput to 1208. In my XML file has some Vietnamese char, so it's wrong when i insert it into database (Oracle 9i). |
|
Back to top |
|
 |
jefflowrey |
Posted: Tue Aug 22, 2006 2:35 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
If your message actually has Vietnamese characters in it, then it's not Unicode... Unless they are Unicode representations of Vietnamese characters (which may or may not be the same thing).
Secondly, Broker uses the CCSID of the Input message to determine how to translate the message data into Unicode. It does this automatically. So the CCSID has to match the input data - otherwise broker can't do the translation! So by the time you get to any ESQL or Java code running in broker, the data is already Unicode.
Thirdly, you can't adjust the CCSID of the input message once you've gotten to the MQInput node. It's too late! If the CCSID on the input message is wrong, then you need to fix it at the sending application, not at broker.
Fourthly - there's no reason that Broker can't insert a message into Oracle "properly". If you are having issues inserting data with national language characters (like Vietnamese), then you probably have not configured the Broker environment to know what national language the broker runs in, so it can know how to handle other national language characters. This is done by ensuring that the Broker runtime environment has the appropriate variable (which is NLS_LANG on some unixes, LANG on others, and I don't know what on Windows) set to a value. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
fjb_saper |
Posted: Tue Aug 22, 2006 2:49 am Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
hoannh wrote: |
Hi
My Message is a XML File. (encoding =UTF- . I want to set the CodeCharSetID of MQinput to 1208. In my XML file has some Vietnamese char, so it's wrong when i insert it into database (Oracle 9i). |
As I seem to remember Vietnamese comes with double byte so your message would not likely be UTF-8 but more likely UTF-16 or CCSID 1200?
As for the insert into the DB see Jeff's comment.
Enjoy  _________________ MQ & Broker admin |
|
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
|
|
|
|