Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_globalization009.htm

Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_globalization009.htm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<script src="./callback.js" type="text/javascript"></script>
<noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript>
</head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />

<meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" />
<meta name="date" content="2009-04-21T9:46:25Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="About Unicode and SQL National Character Data Types" />
<meta name="relnum" content="11g Release 2 (11.2)" />
<meta name="partnum" content="E10766-01" />
<link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" />
<link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" />
<link rel="contents" href="toc.htm" title="Contents" type="text/html" />
<link rel="prev" href="tdddg_globalization008.htm" title="Previous" type="text/html" />
<link rel="next" href="tdddg_globalization010.htm" title="Next" type="text/html" />
<title>About Unicode and SQL National Character Data Types</title>
</head>
<body>
<div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div>
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<col width="86%" />
<col width="*" />
<tr valign="bottom">
<td align="left"></td>
<td align="center"><a href="tdddg_globalization008.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br />
<span class="icon">Previous</span></a>&nbsp;</td>
<td align="center"><a href="tdddg_globalization010.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br />
<span class="icon">Next</span></a></td>
</tr>
</table>
<p><a id="CACBHBBA" name="CACBHBBA"></a><a id="TDDDG63100" name="TDDDG63100"></a></p>
<div class="sect2">
<h1>About Unicode and SQL National Character Data Types</h1>
<a name="BEGIN" id="BEGIN"></a>
<p><a id="sthref641" name="sthref641"></a><span class="bold">Unicode</span> is a character encoding system that defines every character in most of the spoken languages in the world. In Unicode, every character has a unique code, regardless of the platform, program, or language.</p>
<p>You can store Unicode characters in an Oracle Database in two ways:</p>
<ul>
<li>
<p>You can create a Unicode database that enables you to store UTF-8 encoded characters as SQL character datatypes (<code>CHAR</code>, <code>VARCHAR2</code>, <code>CLOB</code>, and <code>LONG</code>).</p>
</li>
<li>
<p>You can declare columns and variables that have SQL national character datatypes.</p>
</li>
</ul>
<p>The <a id="sthref642" name="sthref642"></a><a id="sthref643" name="sthref643"></a><span class="bold">SQL national character data types</span> are <code>NCHAR</code>, <code>NVARCHAR2</code>, and <code>NCLOB</code>. They are also called <a id="sthref644" name="sthref644"></a><a id="sthref645" name="sthref645"></a><span class="bold">Unicode data types</span>, because they are used only for storing Unicode data.</p>
<p>The <a id="sthref646" name="sthref646"></a>national character set, which is used for all SQL national character data types, is specified when the database is created. The national character set can be either UTF8 or AL16UTF16 (default).</p>
<p>When you declare a column or variable of the type <code>NCHAR</code> or <code>NVARCHAR2</code>, the length that you specify is the number of characters, not the number of bytes.</p>
<div class="helpinfonotealso">
<h2>Related Topics</h2>
<p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=NLSPG006','newWindow').focus()"><span class="italic">Oracle Database Globalization Support Guide</span></a> for more information about Unicode</p>
<p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=NLSPG318','newWindow').focus()"><span class="italic">Oracle Database Globalization Support Guide</span></a> for more information about storing Unicode characters in an Oracle Database</p>
<p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=NLSPG0071','newWindow').focus()"><span class="italic">Oracle Database Globalization Support Guide</span></a></p>
<p><a href="tdddg_globalization001.htm#CACBGCDE">About Globalization Support Features</a></p>
</div>
</div>



<div class="footer">
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<col width="86%" />
<col width="*" />
<tr>
<td align="left"><span class="copyrightlogo">Copyright&nbsp;&copy;&nbsp;1996, 2009,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span><br />
<a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td>
<td align="center"><a href="tdddg_globalization008.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br />
<span class="icon">Previous</span></a>&nbsp;</td>
<td align="center"><a href="tdddg_globalization010.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br />
<span class="icon">Next</span></a></td>
</tr>
</table>
</div>

</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de