1 Overview of Globalization Support</t itle> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Language" content="EN"> <met a http-equiv="Content-Style-Type" content="text/css"> <meta http-equiv="Content-Script-Type" content="text/javascript"> <meta name="r obots" content="all" scheme="http://www.robotstxt.org/"> <meta name="doctitle" content="Oracle® Database Globalization Support Gu ide 10g Release 1 (10.1)"> <meta name="partno" content="B10749-01"> <meta name="docid" content="NLSPG"> <link rel="Start" href="../.. /index.htm" title="Home" type="text/html"> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html "> <link rel="Stylesheet" href="../../dcommon/css/doccd.css" title="Default" type="text/css"> <link rel="Contents" href="toc.htm" tit le="Contents" type="text/html"> <link rel="Index" href="index.htm" title="Index" type="text/html"> <link rel="Glossary" href="glossar y.htm" title="Glossary" type="text/html"> <link rel="Prev" href="whatsnew.htm" title="Previous" type="text/html"> <link rel="Next" hr ef="ch2chars.htm" title="Next" type="text/html"> <link rel="alternate" href="../b10749.pdf" title="PDF version" type="application/pdf "> </head> <body> <div class="header"> <p><a name="top" id="top" href="#BEGIN">Skip Headers</a></p> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><font color="#330099" face="Helvetica, Arial, sans-serif"><strong>O racle® Database Globalization Support Guide<br> 10<i>g</i> Release 1 (10.1)</strong><br> Part Number B10749-01</font></td> <td v align="bottom" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home </font></a></td> <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/gifs/bookicon.gif" alt="Go to Book List" border="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src=". ./../dcommon/gifs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="cen ter" valign="top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0"><br> <font size="-2">In dex</font></a></td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gifs/mix.gif" alt= "Go to Master Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../.. /dcommon/html/feedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feed back</font></a></td></tr></table></td></tr></table> <hr> <table summary="layout table" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="90"> <tr> <td a lign="center" valign="top"><a href="whatsnew.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size="-2">Previous</font></a></td> <td align="center" valign="top"><a href="ch2chars.htm"><img src="../../dcommon/gifs/rarrow.g if" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td></tr></table></td> <td align="right" valign="top"><a hr ef="../b10749.pdf"><font size="-2">View PDF</font></a></td></tr></table> <a name="BEGIN"></a></div> <div class="IND"> <a name="1005901"></a>  <h1 class="Title"><font face="Arial, Helvetica, sans-serif" color="#330099">1<b r> <a name="NLSPG001">Overview of Globalization Support</a></font></h1>  <a name="1006427"></a> <p class="BP">This chapter provides an overview of Oracle globalization support. It includes the following topics:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="1005908"></a><a href="ch1overv.htm#1005915">Globalization Support Architecture</a></li> <li class="LB1" type="d isc"><a name="1005912"></a><a href="ch1overv.htm#1006040">Globalization Support Features</a></li></ul> <a name="1005915"></a>  <h2 class="H1"><font face="Arial, Helvetica, sans-serif" color="#330099">Globalization Support Architecture</font></ h2>  <a name="1005916"></a> <p class="BP">Oracle's globalization support enables you to store, process, and retrieve d ata in native languages. It ensures that database utilities, error messages, sort order, and date, time, monetary, numeric, and calen dar conventions automatically adapt to any native language and locale.</p> <a name="1005917"></a> <p class="BP">In the past, Oracle' s globalization support capabilities were referred to as National Language Support (NLS) features. National Language Support is a sub set of globalization support. National Language Support is the ability to choose a national language and store data in a specific cha racter set. Globalization support enables you to develop multilingual applications and software products that can be accessed and run from anywhere in the world simultaneously. An application can render content of the user interface and process data in the native us ers' languages and locale preferences.</p> <a name="1005918"></a>  <h3 class="H2"><font face="Arial, Helvetica , sans-serif" color="#330099">Locale Data on Demand</font></h3>  <a name="1005919"></a> <p class="BP">Oracle's globali zation support is implemented with the Oracle NLS Runtime Library (NLSRTL). The NLS Runtime Library provides a comprehensive suite of language-independent functions that allow proper text and character processing and language convention manipulations. Behavior of th ese functions for a specific language and territory is governed by a set of locale-specific data that is identified and loaded at run time.</p> <a name="1005921"></a> <p class="BP">The locale-specific data is structured as independent sets of data for each locale th at Oracle supports. The data for a particular locale can be loaded independent of other locale data. The advantages of this design ar e as follows:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="1005922"></a>You can manage memory consumption by choosing th e set of locales that you need.</li> <li class="LB1" type="disc"><a name="1005923"></a>You can add and customize locale data for a sp ecific locale without affecting other locales.</li></ul> <a name="1005927"></a> <p class="BP"><a href="ch1overv.htm#1005929">Figure& nbsp;1-1</a> shows that locale-specific data is loaded at runtime. In this example, French data and Japanese data are loaded into the multilingual database, but German data is not.</p> <a name="1005929"></a> <h4 class="FT"><font face="Arial, Helvetica, sans-serif"> <em>Figure 1-1 Loading Locale-Specific Data to the Database</em></font></h4> <a name="1005966"><img src="nlspg002.gif" alt="Text desc ription of nlspg002.gif follows"></a> <p><a href="img_text/nlspg002.htm">Text description of the illustration nlspg002.gif</a></p> < a name="1006363"></a> <p class="BP">The locale-specific data is stored in the <code>$ORACLE_HOME/nls/data</code> directory. The <cod e>ORA_NLS10</code> environment variable should be defined only when you need to change the default directory location for the locale- specific datafiles, for example when the system has multiple Oracle homes that share a single copy of the locale-specific datafiles.< /p> <a name="1006364"></a> <p class="BP">A boot file is used to determine the availability of the NLS objects that can be loaded. Or acle supports both system and user boot files. The user boot file gives you the flexibility to tailor what NLS locale objects are ava ilable for the database. Also, new locale data can be added and some locale data components can be customized.</p> <a name="1005974"> </a> <div align="center"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name= "1005969"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH"><strong class="Bold">See Also</strong>:</strong></font> <a name="1005973"></a> <p class="NB"><a href="ch13cust.htm#1005903">Chapter 13, "Customizing Locale"</a></p></td></tr></table></d iv> <a name="1005975"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">Architect ure to Support Multilingual Applications</font></h3>  <a name="1005976"></a> <p class="BP">The database is implemented to enable multitier applications and client/server applications to support languages for which the database is configured.</p> <a na me="1005977"></a> <p class="BP">The locale-dependent operations are controlled by several parameters and environment variables on bo th the client and the database server. On the database server, each session started on behalf of a client may run in the same or a di fferent locale as other sessions, and have the same or different language requirements specified.</p> <a name="1005978"></a> <p clas s="BP">The database has a set of session-independent NLS parameters that are specified when the database is created. Two of the param eters specify the database character set and the national character set, an alternate Unicode character set that can be specified for <code>NCHAR</code>, <code>NVARCHAR2</code>, and <code>NCLOB</code> data. The parameters specify the character set that is used to st ore text data in the database. Other parameters, like language and territory, are used to evaluate check constraints.</p> <a name="10 05979"></a> <p class="BP">If the client session and the database server specify different character sets, then the database converts character set strings automatically.</p> <a name="1005980"></a> <p class="BP">From a globalization support perspective, all applica tions are considered to be clients, even if they run on the same physical machine as the Oracle instance. For example, when SQL*Plus is started by the UNIX user who owns the Oracle software from the Oracle home in which the RDBMS software is installed, and SQL*Plus connects to the database through an adapter by specifying the <code>ORACLE_SID</code> parameter, SQL*Plus is considered a client. Its behavior is ruled by client-side NLS parameters.</p> <a name="1005981"></a> <p class="BP">Another example of an application being c onsidered a client occurs when the middle tier is an application server. The different sessions spawned by the application server are considered to be separate client sessions.</p> <a name="1005982"></a> <p class="BP">When a client application is started, it initia lizes the client NLS environment from environment settings. All NLS operations performed locally are executed using these settings. E xamples of local NLS operations are:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="1005983"></a>Display formatting in Ora cle Developer applications</li> <li class="LB1" type="disc"><a name="1005984"></a>User OCI code that executes NLS OCI functions with OCI environment handles</li></ul> <a name="1005985"></a> <p class="BP">When the application connects to a database, a session is cre ated on the server. The new session initializes its NLS environment from NLS instance parameters specified in the initialization para meter file. These settings can be subsequently changed by an <code>ALTER</code> <code>SESSION</code> statement. The statement changes only the session NLS environment. It does not change the local client NLS environment. The session NLS settings are used to process SQL and PL/SQL statements that are executed on the server. For example, use an <code>ALTER SESSION</code> statement to set the <code> NLS_LANGUAGE</code> initialization parameter to Italian:</p> <pre class="CE"><a name="1005986"></a>ALTER SESSION SET NLS_LANGUAGE=Ita lian; <a name="1005987"></a> </pre> <a name="1005988"></a> <p class="BP">Enter a <code>SELECT</code> statement:</p> <pre class="CE"> <a name="1005989"></a>SQL> SELECT last_name, hire_date, ROUND(salary/8,2) salary FROM employees; <a name="1005990"></a> </pre> <a name="1005991"></a> <p class="BP">You should see results similar to the following:</p> <pre class="CE"><a name="1005992"></a>LAST_NA ME HIRE_DATE SALARY <a name="1005993"></a>------------------------- --------- ---------- <a name="1005994"></a>Sc iarra 30-SET-97 962.5 <a name="1005995"></a>Urman 07-MAR-98 975 <a name="1005996">< /a>Popp 07-DIC-99 862.5 <a name="1005997"></a> </pre> <a name="1005998"></a> <p class="BP">Note that the m onth name abbreviations are in Italian.</p> <a name="1005999"></a> <p class="BP">Immediately after the connection has been establish ed, if the <code>NLS_LANG</code> environment setting is defined on the client side, then an implicit <code>ALTER SESSION</code> state ment synchronizes the client and session NLS environments.</p> <a name="1006012"></a> <div align="center"> <table class="NoteAlso" b order="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a la yout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006002"></a><font face="Arial, Helvetica, sans-ser if"><strong class="NH">See Also:</strong></font> <a name="1006003"></a> <ul class="NL"> <li class="NL" type="disc"><a name="1006007" ></a><a href="ch10oci.htm#1005900">Chapter 10, "OCI Programming in a Global Environment"</a></li> <li class="NL" type="disc"><a name="1006011"></a><a href="ch3globe.htm#1005902">Chapter 3, "Setting Up a Globalization Support Environment"</a></li></ul></td> </tr></table></div> <a name="1006013"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#3 30099">Using Unicode in a Multilingual Database</font></h3>  <a name="1006014"></a> <p class="BP">Unicode is a univers al encoded character set that enables you to store information in any language, using a single character set. Unicode provides a uniq ue code value for every character, regardless of the platform, program, or language.</p> <a name="1006015"></a> <p class="BP">Unicod e has the following advantages:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="1006016"></a>It simplifies character set co nversion and linguistic sort functions</li> <li class="LB1" type="disc"><a name="1006017"></a>It improves performance compared with n ative multibyte character sets</li> <li class="LB1" type="disc"><a name="1006018"></a>It supports the Unicode datatype based on the U nicode standard <p><a name="1006038"></a></p> <div align="center"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" ce llspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class= "NoteAlso"> <td class="NoteAlso"><a name="1006021"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong ></font> <a name="1006022"></a> <ul class="NL"> <li class="NL" type="disc"><a name="1006026"></a><a href="ch6unico.htm#1006690">Chap ter 6, "Supporting Multilingual Databases with Unicode"</a></li> <li class="NL" type="disc"><a name="1006030"></a><a href="ch7pr ogr.htm#1005900">Chapter 7, "Programming with Unicode"</a></li> <li class="NL" type="disc"><a name="1006036"></a><a href="ch6uni co.htm#1007041">"Enabling Multilingual Support with Unicode Datatypes"</a><a href="ch6unico.htm#1007041"></a></li></ul></td></tr></ta ble></div></li></ul> <a name="1006040"></a>  <h2 class="H1"><font face="Arial, Helvetica, sans-serif" color="# 330099">Globalization Support Features</font></h2>  <a name="1006042"></a> <p class="BP">Oracle's standard features in clude:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="1006046"></a><a href="ch1overv.htm#1006085">Language Support</a></li > <li class="LB1" type="disc"><a name="1006050"></a><a href="ch1overv.htm#1006115">Territory Support</a></li> <li class="LB1" type="d isc"><a name="1006054"></a><a href="ch1overv.htm#1006134">Date and Time Formats</a></li> <li class="LB1" type="disc"><a name="1006058 "></a><a href="ch1overv.htm#1006154">Monetary and Numeric Formats</a></li> <li class="LB1" type="disc"><a name="1006062"></a><a href= "ch1overv.htm#1006165">Calendars Feature</a></li> <li class="LB1" type="disc"><a name="1006066"></a><a href="ch1overv.htm#1006184">Li nguistic Sorting</a></li> <li class="LB1" type="disc"><a name="1006070"></a><a href="ch1overv.htm#1006196">Character Set Support</a>< /li> <li class="LB1" type="disc"><a name="1006074"></a><a href="ch1overv.htm#1006215">Character Semantics</a></li> <li class="LB1" ty pe="disc"><a name="1006078"></a><a href="ch1overv.htm#1006229">Customization of Locale and Calendar Data</a></li> <li class="LB1" typ e="disc"><a name="1006082"></a><a href="ch1overv.htm#1006249">Unicode Support</a></li></ul> <a name="1006085"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">Language Support</font></h3>  <a name="1 006086"></a> <p class="BP">The database enables you to store, process, and retrieve data in native languages. The languages that can be stored in a database are all languages written in scripts that are encoded by Oracle-supported character sets. Through the use of Unicode databases and datatypes, the Oracle database supports most contemporary languages.</p> <a name="1006087"></a> <p class="BP" >Additional support is available for a subset of the languages. The database knows, for example, how to display dates using translate d month names or how to sort text data according to cultural conventions.</p> <a name="1006088"></a> <p class="BP">When this manual uses the term <strong class="Bold">language</strong> <strong class="Bold">support</strong>, it refers to the additional language-depe ndent functionality (for example, displaying dates or sorting text), not to the ability to store text of a specific language.</p> <a name="1006089"></a> <p class="BP">For some of the supported languages, Oracle provides translated error messages and a translated us er interface of the database utilities.</p> <a name="1006112"></a> <div align="center"> <table class="NoteAlso" border="0" width="80 %" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to forma t a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006092"></a><font face="Arial, Helvetica, sans-serif"><strong class=" NH">See Also:</strong></font> <a name="1006093"></a> <ul class="NL"> <li class="NL" type="disc"><a name="1006097"></a><a href="ch3gl obe.htm#1005902">Chapter 3, "Setting Up a Globalization Support Environment"</a></li> <li class="NL" type="disc"><a name="100610 4"></a><a href="applocal.htm#634430">"Languages"</a><a href="applocal.htm#634430"></a> for a complete list of Oracle language names a nd abbreviations</li> <li class="NL" type="disc"><a name="1006111"></a><a href="applocal.htm#634675">"Translated Messages"</a><a href ="applocal.htm#634675"></a> for a list of languages into which Oracle messages are translated</li></ul></td></tr></table></div> <a na me="1006115"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">Territory Support< /font></h3>  <a name="1006116"></a> <p class="BP">The database supports cultural conventions that are specific to geog raphical locations. The default local time format, date format, and numeric and monetary conventions depend on the local territory se tting. Setting different NLS parameters allows the database session to use different cultural settings. For example, you can set the euro (<code>EUR</code>) as the primary currency and the Japanese yen (<code>JPY</code>) as the secondary currency for a given databas e session even when the territory is defined as <code>AMERICA</code>.</p> <a name="1006132"></a> <div align="center"> <table class=" NoteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="T his is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006119"></a><font face="Arial, Helvetic a, sans-serif"><strong class="NH">See Also:</strong></font> <a name="1006120"></a> <ul class="NL"> <li class="NL" type="disc"><a nam e="1006124"></a><a href="ch3globe.htm#1005902">Chapter 3, "Setting Up a Globalization Support Environment"</a></li> <li class="N L" type="disc"><a name="1006131"></a><a href="applocal.htm#634812">"Territories"</a><a href="applocal.htm#634812"></a> for a list of territories that are supported by the Oracle server</li></ul></td></tr></table></div> <a name="1006134"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">Date and Time Formats</font></h3>  <a name="10 06135"></a> <p class="BP">Different conventions for displaying the hour, day, month, and year can be handled in local formats. For e xample, in the United Kingdom, the date is displayed using the <code>DD-MON-YYYY</code> format, while Japan commonly uses the <code>Y YYY-MM-DD</code> format.</p> <a name="1006136"></a> <p class="BP">Time zones and daylight saving support are also available.</p> <a name="1006152"></a> <div align="center"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" su mmary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="NoteAlso"> <td class="Not eAlso"><a name="1006139"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></font> <a name="1006140" ></a> <ul class="NL"> <li class="NL" type="disc"><a name="1006144"></a><a href="ch3globe.htm#1005902">Chapter 3, "Setting Up a Globalization Support Environment"</a></li> <li class="NL" type="disc"><a name="1006423"></a><a href="ch4datet.htm#1007415">Chapter&n bsp;4, "Datetime Datatypes and Time Zone Support"</a></li> <li class="NL" type="disc"><a name="1006151"></a><em class="Italic"><a cla ss="olinkSRC SQLRF" href="../../server$101/b10759/toc.htm">Oracle Database SQL Reference</a></em></li></ul></td></tr></table></div> < a name="1006154"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">Monetary and N umeric Formats</font></h3>  <a name="1006155"></a> <p class="BP">Currency, credit, and debit symbols can be represente d in local formats. Radix symbols and thousands separators can be defined by locales. For example, in the US, the decimal point is a dot (.), while it is a comma (,) in France. Therefore, the amount $1,234 has different meanings in different countries.</p> <a name=" 1006163"></a> <div align="center"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary= "This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso" ><a name="1006158"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></font> <a name="1006161"></a> <p class="NB"><a href="ch3globe.htm#1005902">Chapter 3, "Setting Up a Globalization Support Environment"</a></p></td></tr></tab le></div> <a name="1006165"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">Cal endars Feature</font></h3>  <a name="1006166"></a> <p class="BP">Many different calendar systems are in use around the world. Oracle supports seven different calendar systems: Gregorian, Japanese Imperial, ROC Official (Republic of China), Thai Buddha , Persian, English Hijrah, and Arabic Hijrah.</p> <a name="1006182"></a> <div align="center"> <table class="NoteAlso" border="0" wid th="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006169"></a><font face="Arial, Helvetica, sans-serif"><strong c lass="NH">See Also:</strong></font> <a name="1006170"></a> <ul class="NL"> <li class="NL" type="disc"><a name="1006174"></a><a href= "ch3globe.htm#1005902">Chapter 3, "Setting Up a Globalization Support Environment"</a></li> <li class="NL" type="disc"><a name=" 1006181"></a><a href="applocal.htm#637657">"Calendar Systems"</a><a href="applocal.htm#637657"></a> for a list of supported calendars </li></ul></td></tr></table></div> <a name="1006184"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-s erif" color="#330099">Linguistic Sorting</font></h3>  <a name="1006185"></a> <p class="BP">Oracle provides linguistic definitions for culturally accurate sorting and case conversion. The basic definition treats strings as sequences of independent char acters. The extended definition recognizes pairs of characters that should be treated as special cases.</p> <a name="1006186"></a> < p class="BP">Strings that are converted to upper case or lower case using the basic definition always retain their lengths. Strings c onverted using the extended definition may become longer or shorter.</p> <a name="1006194"></a> <div align="center"> <table class="N oteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="Th is is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006189"></a><font face="Arial, Helvetica , sans-serif"><strong class="NH">See Also:</strong></font> <a name="1006193"></a> <p class="NB"><a href="ch5lings.htm#1005900">Chapt er 5, "Linguistic Sorting and String Searching"</a></p></td></tr></table></div> <a name="1006196"></a>  < h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">Character Set Support</font></h3>  <a name="100 6197"></a> <p class="BP">Oracle supports a large number of single-byte, multibyte, and fixed-width encoding schemes that are based o n national, international, and vendor-specific standards.</p> <a name="1006213"></a> <div align="center"> <table class="NoteAlso" bo rder="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a lay out table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006200"></a><font face="Arial, Helvetica, sans-seri f"><strong class="NH">See Also:</strong></font> <a name="1006201"></a> <ul class="NL"> <li class="NL" type="disc"><a name="1006205"> </a><a href="ch2chars.htm#1007683">Chapter 2, "Choosing a Character Set"</a></li> <li class="NL" type="disc"><a name="1006212">< /a><a href="applocal.htm#635018">"Character Sets"</a><a href="applocal.htm#635018"></a> for a list of supported character sets</li></ ul></td></tr></table></div> <a name="1006215"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" c olor="#330099">Character Semantics</font></h3>  <a name="1006216"></a> <p class="BP">Oracle provides character semanti cs. It is useful for defining the storage requirements for multibyte strings of varying widths in terms of characters instead of byte s.</p> <a name="1006227"></a> <div align="center"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" di r="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006219"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></font> <a name ="1006226"></a> <p class="NB"><a href="ch2chars.htm#1006685">"Length Semantics"</a><a href="ch2chars.htm#1006685"></a></p></td></tr> </table></div> <a name="1006229"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099 ">Customization of Locale and Calendar Data</font></h3>  <a name="1006230"></a> <p class="BP">You can customize locale data such as language, character set, territory, or linguistic sort using the Oracle Locale Builder.</p> <a name="1006231"></a> <p class="BP">You can customize calendars with the NLS Calendar Utility.</p> <a name="1006247"></a> <div align="center"> <table class=" NoteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="T his is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006234"></a><font face="Arial, Helvetic a, sans-serif"><strong class="NH">See Also:</strong></font> <a name="1006235"></a> <ul class="NL"> <li class="NL" type="disc"><a nam e="1006239"></a><a href="ch13cust.htm#1005903">Chapter 13, "Customizing Locale"</a></li> <li class="NL" type="disc"><a name="100 6245"></a><a href="ch13cust.htm#1006299">"Customizing Calendars with the NLS Calendar Utility"</a><a href="ch13cust.htm#1006299"></a> </li></ul></td></tr></table></div> <a name="1006249"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-s erif" color="#330099">Unicode Support</font></h3>  <a name="1006250"></a> <p class="BP">You can store Unicode characte rs in an Oracle database in two ways:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="1006251"></a>You can create a Unicode database that enables you to store UTF-8 encoded characters as SQL <code>CHAR</code> datatypes.</li> <li class="LB1" type="disc"><a name="1006252"></a>You can support multilingual data in specific columns by using Unicode datatypes. You can store Unicode characters into columns of the SQL <code>NCHAR</code> datatypes regardless of how the database character set has been defined. The <code>NCHAR< /code> datatype is an exclusively Unicode datatype. <p><a name="1006260"></a></p> <div align="center"> <table class="NoteAlso" borde r="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="1006255"></a><font face="Arial, Helvetica, sans-serif"> <strong class="NH">See Also:</strong></font> <a name="1006258"></a> <p class="NB"><a href="ch6unico.htm#1006690">Chapter 6, "Su pporting Multilingual Databases with Unicode"</a></p></td></tr></table></div></li></ul></div> <div class="footer"> <hr> <table summar y="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td style="width: 33%;" align="left"> <table summary="layout table" cellspaci ng="0" cellpadding="0" align="left" width="90"> <tr> <td align="center" valign="top"><a href="whatsnew.htm"><img src="../../dcommon/g ifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size="-2">Previous</font></a></td> <td align="center" valign="top"><a href="ch2chars.htm"><img src="../../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></ td></tr></table></td> <td style="width: 34%;" align="center"><img src="../../dcommon/gifs/oracle.gif" alt="Oracle"><br> <a href="../. ./dcommon/html/cpyr.htm"><font size="-2">Copyright © 1996, 2003 Oracle Corporation</font></a><br> <font size="-2">All Rights Res erved.</font></td> <td style="width: 33%;" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td ali gn="center" valign="top"><a href="../../index.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border=" 0"><br> <font size="-2">Home</font></a></td> <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon /gifs/bookicon.gif" alt="Go to Book List" border="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top">< a href="toc.htm"><img src="../../dcommon/gifs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</f ont></a></td> <td align="center" valign="top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border ="0"><br> <font size="-2">Index</font></a></td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../. ./dcommon/gifs/mix.gif" alt="Go to Master Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border=" 0"><br> <font size="-2">Feedback</font></a></td></tr></table></td></tr></table></div> </body> </html>