112 lines
7.5 KiB
HTML
112 lines
7.5 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
<!DOCTYPE html
|
||
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
<html lang="en-us" xml:lang="en-us">
|
||
|
<head>
|
||
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
<meta name="security" content="public" />
|
||
|
<meta name="Robots" content="index,follow" />
|
||
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
<meta name="DC.Type" content="reference" />
|
||
|
<meta name="DC.Title" content="Coded character set identifier" />
|
||
|
<meta name="abstract" content="Support for the national language of any country requires the proper handling of a minimum set of characters." />
|
||
|
<meta name="description" content="Support for the national language of any country requires the proper handling of a minimum set of characters." />
|
||
|
<meta name="DC.subject" content="Character Data Representation Architecture (CDRA), national language support, data translation, CCSID, Coded Character Set Identifier (CCSID), overvie1w, CDRA (Character Data Representation Architecture), CCSID (coded character set identifier), overview, allowed values, CCSID (coded character set identifier), tagging" />
|
||
|
<meta name="keywords" content="Character Data Representation Architecture (CDRA), national language support, data translation, CCSID, Coded Character Set Identifier (CCSID), overvie1w, CDRA (Character Data Representation Architecture), CCSID (coded character set identifier), overview, allowed values, CCSID (coded character set identifier), tagging" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbal1progdrd.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbal1serversupport.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="../nls/rbagsglobalmain.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="../db2/rbafzmst02.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="../sqlp/rbafykickoff.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbal1drdacdra.htm" />
|
||
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
<meta name="DC.Format" content="XHTML" />
|
||
|
<meta name="DC.Identifier" content="rbal1ccsid" />
|
||
|
<meta name="DC.Language" content="en-us" />
|
||
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
<!-- US Government Users Restricted Rights -->
|
||
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
<title>Coded character set identifier</title>
|
||
|
</head>
|
||
|
<body id="rbal1ccsid"><a name="rbal1ccsid"><!-- --></a>
|
||
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
<h1 class="topictitle1">Coded character set identifier</h1>
|
||
|
<div><p>Support for the national language of any country requires the proper
|
||
|
handling of a minimum set of characters.</p>
|
||
|
<div class="section"><p>A cross-system support for the management of character information
|
||
|
is provided with the IBM<sup>®</sup> Character Data Representation Architecture (CDRA).
|
||
|
CDRA defines the coded character set identifier (CCSID) values to identify
|
||
|
the code points used to represent characters, and to convert these codes (character
|
||
|
data), as needed to preserve their meanings.</p>
|
||
|
</div>
|
||
|
<div class="section"><div class="p">The use of an architecture such as CDRA and associated conversion
|
||
|
protocols is important in the following situations: <ul><li>More than one national language version is installed on the <span class="keyword">iSeries™ server</span>.</li>
|
||
|
<li>Multiple <span class="keyword">iSeries server</span>s are
|
||
|
sharing data between systems in different countries with different primary
|
||
|
national language versions.</li>
|
||
|
<li><span class="keyword">iSeries server</span>s and non-<span class="keyword">iSeries server</span>s are sharing data between systems
|
||
|
in different countries with different primary national language versions.</li>
|
||
|
</ul>
|
||
|
</div>
|
||
|
</div>
|
||
|
<div class="section"><p><dfn class="term">Tagging</dfn> is the primary means to assign meaning to
|
||
|
coded graphic characters. The tag might be in a data structure that is associated
|
||
|
with the data object (explicit tagging), or it might be inherited from objects
|
||
|
such as the job or the system itself (implicit tagging).</p>
|
||
|
</div>
|
||
|
<div class="section"><p><span class="keyword">DB2 Universal Database™ for iSeries</span> tags
|
||
|
character columns with CCSIDs. A <dfn class="term">CCSID</dfn> is a 16-bit number identifying
|
||
|
a specific set of encoding scheme identifiers, character set identifiers,
|
||
|
code page identifiers, and additional coding-related information that uniquely
|
||
|
identifies the coded graphic character representation used. When running applications,
|
||
|
data is not converted when it is sent to another system; it is sent as tagged
|
||
|
along with its CCSID. The receiving job automatically converts the data to
|
||
|
its own CCSID if it is different from the way the data is tagged.</p>
|
||
|
</div>
|
||
|
<div class="section"><p>The CDRA has defined the following range of values for CCSIDs.
|
||
|
</p>
|
||
|
<dl><dt class="dlterm">00000</dt>
|
||
|
<dd>Use next hierarchical CCSID</dd>
|
||
|
<dt class="dlterm">00001 through 28671</dt>
|
||
|
<dd>IBM-registered CCSIDs</dd>
|
||
|
<dt class="dlterm">28672 through 65533</dt>
|
||
|
<dd>Reserved</dd>
|
||
|
<dt class="dlterm">65534</dt>
|
||
|
<dd>Refer to lower hierarchical CCSID</dd>
|
||
|
<dt class="dlterm">65535</dt>
|
||
|
<dd>No conversion done</dd>
|
||
|
</dl>
|
||
|
</div>
|
||
|
<div class="section"><p>See <cite>Character Data Representation Architecture - Level 1,
|
||
|
Registry</cite> for a complete list of the CDRA CCSIDs.</p>
|
||
|
</div>
|
||
|
<div class="section"><p>The following illustration shows the parts of a CCSID.</p>
|
||
|
</div>
|
||
|
<div class="example"> <div class="fignone"><span class="figcap">Figure 1. Coded character set identifier (CCSID)</span><br /><img src="rbal1508.gif" alt="Coded character set identifier" /><br /></div>
|
||
|
</div>
|
||
|
</div>
|
||
|
<div>
|
||
|
<ul class="ullinks">
|
||
|
<li class="ulchildlink"><strong><a href="rbal1serversupport.htm">iSeries server support</a></strong><br />
|
||
|
The default CCSID for a job on the <span class="keyword">iSeries server</span> is
|
||
|
specified using the <span class="cmdname">Change Job (CHGJOB)</span> command.</li>
|
||
|
</ul>
|
||
|
|
||
|
<div class="familylinks">
|
||
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1progdrd.htm" title="Programming considerations for a distributed relational database application on an iSeries server fall into two main categories: those that deal with a function that is supported on the local server and those that are a result of having to connect to other servers.">Programming considerations for a distributed relational database application</a></div>
|
||
|
</div>
|
||
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
||
|
<div><a href="../sqlp/rbafykickoff.htm">SQL programming</a></div>
|
||
|
<div><a href="rbal1drdacdra.htm" title="One of the interesting possibilities in a distributed relational database is that the database might not only span different types of computers, but those computers might be in different countries or regions. The same servers, such as iSeries servers, can encode data differently depending on the language used on the server.">DRDA and CDRA support</a></div>
|
||
|
</div>
|
||
|
<div class="relinfo"><strong>Related information</strong><br />
|
||
|
<div><a href="../nls/rbagsglobalmain.htm">i5/OS globalization</a></div>
|
||
|
<div><a href="../db2/rbafzmst02.htm">SQL reference</a></div>
|
||
|
</div>
|
||
|
</div>
|
||
|
</body>
|
||
|
</html>
|