68 lines
5.3 KiB
HTML
68 lines
5.3 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="concept" />
|
||
|
<meta name="DC.Title" content="Double-byte character set considerations" />
|
||
|
<meta name="abstract" content="These topics describe double-byte character set (DBCS) considerations as they apply to the database on the iSeries system." />
|
||
|
<meta name="description" content="These topics describe double-byte character set (DBCS) considerations as they apply to the database on the iSeries system." />
|
||
|
<meta name="DC.subject" content="double-byte character set (DBCS), considerations, DBCS (double-byte character set), national language support" />
|
||
|
<meta name="keywords" content="double-byte character set (DBCS), considerations, DBCS (double-byte character set), national language support" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbafokickoff.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbafodbcsdt.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbafodbcsmap.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbafodbcscon.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbafodbcssub.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbafodbcscomp.htm" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbafodbcsqry.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="rbafoappdbcs" />
|
||
|
<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>Double-byte character set considerations</title>
|
||
|
</head>
|
||
|
<body id="rbafoappdbcs"><a name="rbafoappdbcs"><!-- --></a>
|
||
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
<h1 class="topictitle1">Double-byte character set considerations</h1>
|
||
|
<div><p>These topics describe double-byte character set (DBCS) considerations
|
||
|
as they apply to the database on the <span class="keyword">iSeries™</span> system. </p>
|
||
|
<p>A DBCS is a character set that represents each character with
|
||
|
2 bytes. The DBCS supports national languages that contain a large number
|
||
|
of unique characters or symbols (the maximum number of characters that can
|
||
|
be represented with 1 byte is 256 characters). Examples of such languages
|
||
|
include Japanese, Korean, and Chinese. </p>
|
||
|
</div>
|
||
|
<div>
|
||
|
<ul class="ullinks">
|
||
|
<li class="ulchildlink"><strong><a href="rbafodbcsdt.htm">DBCS field data types</a></strong><br />
|
||
|
There are two general kinds of double-byte character set (DBCS) data: bracketed-DBCS data and graphic (nonbracketed) DBCS data.</li>
|
||
|
<li class="ulchildlink"><strong><a href="rbafodbcsmap.htm">DBCS field mapping considerations</a></strong><br />
|
||
|
This topic shows what types of data mapping are valid between physical and logical files for double-byte character set (DBCS) fields</li>
|
||
|
<li class="ulchildlink"><strong><a href="rbafodbcscon.htm">DBCS field concatenation</a></strong><br />
|
||
|
When fields are concatenated, the data types can change (the resulting data type is automatically determined by the system). You can follow these guidelines when double-byte character set (DBCS) fields are concatenated.</li>
|
||
|
<li class="ulchildlink"><strong><a href="rbafodbcssub.htm">DBCS field substring operations</a></strong><br />
|
||
|
A substring operation allows you to use part of a field or constant in a logical file.</li>
|
||
|
<li class="ulchildlink"><strong><a href="rbafodbcscomp.htm">Compare DBCS fields in a logical file</a></strong><br />
|
||
|
When comparing two fields or a field and constants, fixed-length fields can be compared to variable-length fields as long as the types are compatible.</li>
|
||
|
<li class="ulchildlink"><strong><a href="rbafodbcsqry.htm">Use DBCS fields in the Open Query File (OPNQRYF) command</a></strong><br />
|
||
|
These topics discuss the use of double-byte character set (DBCS) fields for these Open Query File (OPNQRYF) command functions: wildcard, concatenation, and sort sequence functions. A table shows valid comparisons for DBCS fields through the OPNQRYF command.</li>
|
||
|
</ul>
|
||
|
|
||
|
<div class="familylinks">
|
||
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafokickoff.htm" title="This database programming topic contains information about the DB2 Universal Database for iSeries (DB2 UDB for iSeries) database management system, and describes how to set up and use the database on iSeries servers using traditional system interfaces.">Database programming</a></div>
|
||
|
</div>
|
||
|
</div>
|
||
|
</body>
|
||
|
</html>
|