What's New in Globalization Support ?< /title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Language" content="EN"> <m eta http-equiv="Content-Style-Type" content="text/css"> <meta http-equiv="Content-Script-Type" content="text/javascript"> <meta name= "robots" content="all" scheme="http://www.robotstxt.org/"> <meta name="doctitle" content="Oracle® Database Globalization Support Guide 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/ht ml"> <link rel="Stylesheet" href="../../dcommon/css/doccd.css" title="Default" type="text/css"> <link rel="Contents" href="toc.htm" t itle="Contents" type="text/html"> <link rel="Index" href="index.htm" title="Index" type="text/html"> <link rel="Glossary" href="gloss ary.htm" title="Glossary" type="text/html"> <link rel="Prev" href="preface.htm" title="Previous" type="text/html"> <link rel="Next" h ref="ch1overv.htm" title="Next" type="text/html"> <link rel="alternate" href="../b10749.pdf" title="PDF version" type="application/pd f"> </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> Oracle® Database Globalization Support Guide<br> 10<i>g</i> Release 1 (10.1)</strong><br> Part Number B10749-01</font></td> <td valign="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">Hom e</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="ce nter" valign="top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0"><br> <font size="-2">I ndex</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">Fee dback</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 align="center" valign="top"><a href="preface.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="ch1overv.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="970659"></a>  <h1 class="Title"><font face="Arial, Helvetica, sans-serif" color="#330099"><br> <a name="NLSPG000">What's New in Globalization Support</a> ?</font></h1>  <a name="970660"></a> <p class="BP">This section describes new features of globalization support and provides pointers to additional information.</p> <a name="971080"></a> < h2 class="PH"><font face="Arial, Helvetica, sans-serif">Unicode 3.2 Support</font></h2> <div style="margin-left: 2em"><a name="971085 "></a> <p class="BP1">This release supports Unicode 3.2.</p> <a name="971086"></a> <div align="center"> <table class="NoteAlso" bor der="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layo ut table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="971089"></a><font face="Arial, Helvetica, sans-serif" ><strong class="NH">See Also:</strong></font> <a name="971090"></a> <p class="NB"><a href="ch6unico.htm#1006690">Chapter 6, "Su pporting Multilingual Databases with Unicode"</a></p></td></tr></table></div></div> <a name="971102"></a> <h2 class="PH"><font face= "Arial, Helvetica, sans-serif">Accent-Insensitive and Case-Insensitive Linguistic Sorts and Queries</font></h2> <div style="margin-le ft: 2em"><a name="971107"></a> <p class="BP1">Oracle provides linguistic sorts and queries that use information about base letter, a ccents, and case to sort character strings.This release enables you to specify a sort or query on the base letters only (accent-insen sitive) or on the base letters and the accents (case-insensitive).</p> <a name="971108"></a> <div align="center"> <table class="Note Also" 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="971111"></a><font face="Arial, Helvetica, sa ns-serif"><strong class="NH">See Also:</strong></font> <a name="971112"></a> <p class="NB"><a href="ch5lings.htm#1006212">"Linguisti c Sort Features"</a><a href="ch5lings.htm#1006212"></a></p></td></tr></table></div></div> <a name="971131"></a> <h2 class="PH"><font face="Arial, Helvetica, sans-serif">Character Set Scanner Utilities Enhancements</font></h2> <div style="margin-left: 2em"><a name=" 971393"></a> <p class="BP1">The Database Character Set Scanner and Converter now supports object types.</p> <a name="971411"></a> < p class="BP1">The new <code>LCSD</code> parameter enables the Database Character Set Scanner (<code>CSSCAN</code>) to perform languag e and character set detection on the data cells categorized by the <code>LCSDATA</code> parameter. The Database Character Set Scanner reports have also been enhanced.</p></div> <a name="971410"></a> <h4 class="SH1"><font face="Arial, Helvetica, sans-serif">Database Character Set Scanner CSALTER Script</font></h4> <a name="971413"></a> <p class="BP">The <code>CSALTER</code> script is a DBA tool for special character set migration.</p> <a name="971414"></a> <h4 class="SH1"><font face="Arial, Helvetica, sans-serif">The Languag e and Character Set File Scanner Utility</font></h4> <a name="971421"></a> <p class="BP">The Language and Character Set File Scanner (<code>LCSSCAN</code>) is a high-performance, statistically based utility for determining the character set and language for unspeci fied plain file text.</p> <a name="971132"></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 clas s="NoteAlso"> <td class="NoteAlso"><a name="971135"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</stron g></font> <a name="971136"></a> <p class="NB"><a href="ch12scan.htm#1005900">Chapter 12, "Character Set Scanner Utilities"</a>< /p></td></tr></table></div> <a name="971138"></a> <h2 class="PH"><font face="Arial, Helvetica, sans-serif">Globalization Development Kit</font></h2> <div style="margin-left: 2em"><a name="971141"></a> <p class="BP1">The Globalization Development Kit (GDK) simplifi es the development process and reduces the cost of developing Internet applications that will support a global multilingual market. G DK includes APIs, tools, and documentation that address many of the design, development, and deployment issues encountered in the cre ation of global applications. GDK lets a single program work with text in any language from anywhere in the world. It enables you to build a complete multilingual server application with little more effort than it takes to build a monolingual server application.</p> <a name="971166"></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="971169"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></font> <a name="971170 "></a> <p class="NB"><a href="ch8gdk.htm#1004903">Chapter 8, "Oracle Globalization Development Kit"</a></p></td></tr></table></ div></div> <a name="971171"></a> <h2 class="PH"><font face="Arial, Helvetica, sans-serif">Regular Expressions</font></h2> <div style ="margin-left: 2em"><a name="971174"></a> <p class="BP1">This release supports POSIX-compliant regular expressions to enhance search and replace capability in programming environments such as UNIX and Java. In SQL, this new functionality is implemented through new functions that are regular expression extensions to existing SQL functions such as <code>LIKE</code>, <code>REPLACE</code>, and <code >INSTR</code>. This implementation supports multilingual queries and is locale-sensitive.</p> <a name="971192"></a> <div align="cent er"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to form at a note" title="This is a layout table to format a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="971195"></a><font fac e="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></font> <a name="971196"></a> <p class="NB"><a href="ch5lings. htm#1008620">"SQL Regular Expressions in a Multilingual Environment"</a><a href="ch5lings.htm#1008620"></a></p></td></tr></table></di v></div> <a name="971258"></a> <h2 class="PH"><font face="Arial, Helvetica, sans-serif">Displaying Code Charts for Unicode Character Sets</font></h2> <a name="971259"></a> <p class="BP">Oracle Locale Builder can display code charts for Unicode character sets.</p> <a name="971267"></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="N oteAlso"><a name="971270"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH"><strong class="Bold">See Also</strong>:</s trong></font> <a name="971271"></a> <p class="NB"><a href="ch13cust.htm#1006323">"Displaying a Code Chart with the Oracle Locale Bui lder"</a><a href="ch13cust.htm#1006323"></a></p></td></tr></table></div> <a name="971321"></a> <h2 class="PH"><font face="Arial, Hel vetica, sans-serif">Locale Variants</font></h2> <a name="971322"></a> <p class="BP">In previous releases, Oracle defined language an d territory definitions separately. This resulted in the definition of a territory being independent of the language setting of the u ser. In this release, some territories can have different date, time, number, and monetary formats based on the language setting of a user. This type of language-dependent territory definition is called a locale variant.</p> <a name="971329"></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="971332"></a><font face= "Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></font> <a name="971333"></a> <p class="NB"><a href="ch3globe.ht m#1010442">"Locale Variants"</a><a href="ch3globe.htm#1010442"></a></p></td></tr></table></div> <a name="971341"></a> <h2 class="PH" ><font face="Arial, Helvetica, sans-serif">Transportable NLB Data</font></h2> <a name="971346"></a> <p class="BP">NLB files that are generated on one platform can be transported to another platform by, for example, FTP. The transported NLB files can be used the sam e way as the NLB files that were generated on the original platform. This is convenient because locale data can be modified on one pl atform and copied to other platforms.</p> <a name="971347"></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="971350"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH"> See Also:</strong></font> <a name="971351"></a> <p class="NB"><a href="ch13cust.htm#1007827">"Transportable NLB Data"</a><a href="ch 13cust.htm#1007827"></a></p></td></tr></table></div> <a name="971366"></a> <h2 class="PH"><font face="Arial, Helvetica, sans-serif"> NLS_LENGTH_SEMANTICS</font></h2> <a name="971367"></a> <p class="BP"><code>NLS_LENGTH_SEMANTICS</code> is now supported as an enviro nment variable.</p> <a name="971368"></a> <div align="center"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" cellsp acing="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="Not eAlso"> <td class="NoteAlso"><a name="971371"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></fo nt> <a name="971372"></a> <p class="NB"><a href="ch3globe.htm#1008571">"NLS_LENGTH_SEMANTICS"</a><a href="ch3globe.htm#1008571"></a> </p></td></tr></table></div> <a name="971379"></a> <h2 class="PH"><font face="Arial, Helvetica, sans-serif">Implicit Conversion Betw een CLOB and NCLOB Datatypes</font></h2> <a name="971380"></a> <p class="BP">Implicit conversion between <code>CLOB</code> and <code >NCLOB</code> datatypes is now supported.</p> <a name="971381"></a> <div align="center"> <table class="NoteAlso" border="0" width="8 0%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to form at a note"> <tr class="NoteAlso"> <td class="NoteAlso"><a name="971384"></a><font face="Arial, Helvetica, sans-serif"><strong class=" NH">See Also:</strong></font> <a name="971385"></a> <p class="NB"><a href="ch2chars.htm#1007018">"Choosing a National Character Set" </a><a href="ch2chars.htm#1007018"></a></p></td></tr></table></div> <a name="971433"></a> <h2 class="PH"><font face="Arial, Helvetic a, sans-serif">Updates to the Oracle Language and Territory Definition Files</font></h2> <a name="971434"></a> <p class="BP">Changes have been made to the content in some of the language and territory definition files in Oracle Database 10<em class="Italic">g</em>. </p> <a name="971435"></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 cla ss="NoteAlso"><a name="971438"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></font> <a name="97 1439"></a> <p class="NB"><a href="applocal.htm#644323">"Obsolete Locale Data"</a><a href="applocal.htm#644323"></a></p></td></tr></t able></div></div> <div class="footer"> <hr> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td style="width: 33 %;" align="left"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="90"> <tr> <td align="center" vali gn="top"><a href="preface.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size="-2">Pre vious</font></a></td> <td align="center" valign="top"><a href="ch1overv.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 C orporation</font></a><br> <font size="-2">All Rights Reserved.</font></td> <td style="width: 33%;" align="right"> <table summary="" c ellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img src="../../dcommon/gi fs/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">Boo k 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="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="to p"><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="../../dcomm on/gifs/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback</font></a></td></tr></table></td></tr></tabl e></div> </body> </html>