| Author |
Message
|
| vickas |
 Posted: Tue Oct 15, 2013 2:59 am Post subject: role of CCSID and ENCODING parameters while casting ? |
 |
|
Centurion
Joined: 18 Aug 2013
Posts: 126
|
I am new to MB..
I want to know the exact purpose of CCSID and ENCODING parameters while casting to or from one of the string data types... |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Oct 15, 2013 3:03 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
If you are new to WMB, the very first thing you need to learn is how to read the documentation.
Spend a lot of time trying to find things in the InfoCenter. It will save you a LOT of time later on, and save you a LOT of grief from other people who expect you to know how to do this. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Oct 15, 2013 4:47 am Post subject: Re: role of CCSID and ENCODING parameters while casting ? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| vickas wrote: |
| I want to know the exact purpose of CCSID and ENCODING parameters while casting to or from one of the string data types... |
They control the CCSID and encoding used by WMB during the casting process. What did you think they were doing? What happens when you try some experimental casts within WMB?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| dogorsy |
| Posted: Tue Oct 15, 2013 6:04 am Post subject: Re: role of CCSID and ENCODING parameters while casting ? |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| vickas wrote: |
I am new to MB..
I want to know the exact purpose of CCSID and ENCODING parameters while casting to or from one of the string data types... |
What does the documentation say ?, is it not clear ? |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Oct 15, 2013 6:11 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
In the spirit of the question:
http://www.joelonsoftware.com/articles/Unicode.html
Understand that document, and you will probably understand why CCSID and ENCODING are used in ESQL CASTs.
_________________
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 |
|
|
| vickas |
| Posted: Tue Oct 15, 2013 8:30 pm Post subject: |
|
|
Centurion
Joined: 18 Aug 2013
Posts: 126
|
InfoCenter couldn't help me to know their exact purposes while casting.
It says
CCSID parameter is used to specify the code page of the source or target string.
ENCODING parameter is used to specify the encoding for certain conversions.
can u explain me in brief what does the above statements mean ? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Oct 15, 2013 9:32 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| vickas wrote: |
InfoCenter couldn't help me to know their exact purposes while casting.
It says
CCSID parameter is used to specify the code page of the source or target string.
ENCODING parameter is used to specify the encoding for certain conversions.
can u explain me in brief what does the above statements mean ? |
I see your confusion:
CCSID is for the conversion of text
ENCODING has nothing to do with XML Encoding and is used for the conversion of numbers (little / big endian).
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Oct 16, 2013 1:58 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
fjb_saper said:
| Quote: |
| ENCODING has nothing to do with XML Encoding and is used for the conversion of numbers (little / big endian). |
That is correct, except for one scenario. UTF-16 has bigEndian and littleEndian variants. If you specify UTF-16 ( and *not* UTF-16LE or UTF-16BE ) then the ENCODING property is used to select the bigEndian or littleEndian variant.
_________________
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 |
|
|
| aggarwal.intouch |
| Posted: Wed Oct 16, 2013 2:03 am Post subject: |
|
|
Acolyte
Joined: 30 May 2011
Posts: 56
Location: India
|
|
| Back to top |
|
|
|
|
