MQSeries.net :: View topic - ESQL CAST function using CCSID

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL CAST function using CCSID

ESQL CAST function using CCSID

« View previous topic :: View next topic »

Author

Message

PEPERO

Posted: Mon Nov 24, 2014 9:30 am Post subject: ESQL CAST function using CCSID

Disciple

Joined: 30 May 2011
Posts: 177

Hi all;
According to the help written for the CAST function in ESQL in the following URL
http://www-01.ibm.com/support/knowledgecenter/SSKM8N_8.0.0/com.ibm.etools.mft.doc/ak05610_.htm
The CCSID could be used for the source or target string. Could you please explain when would it be used for the source string and when for the target?

fjb_saper

Posted: Mon Nov 24, 2014 10:54 am Post subject:

Grand High Poobah

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

It would be used for the source if you want to transform a BLOB to character and for the target if you want to transform a character to BLOB...

_________________
MQ & Broker admin

kimbert

Posted: Mon Nov 24, 2014 12:14 pm Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

All character data in the message tree is represented in UTF-16. So if you want read or write character data then you need to specify its CCSID.

I can supply a link to good article about Unicode / character sets / encodings if you like.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too.

PEPERO

Posted: Mon Nov 24, 2014 9:48 pm Post subject:

Disciple

Joined: 30 May 2011
Posts: 177

Thanks fjb_saper for your guideline. It's now clear.

Quote:

kimbert wrote :
I can supply a link to good article about Unicode / character sets / encodings if you like

Yes i would like. please let me have the link.
thanks so much men.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL CAST function using CCSID

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