|Oracle® Database Globalization Support Guide
11g Release 1 (11.1)
|PDF · Mobi · ePub|
This section describes new features of globalization support, provides pointers to related information in this book, and contains these topics:
Support for Unicode 5.0, a major version of the Unicode Standard that supercedes all previous versions of the standard.
1,369 new character assignments have been made to the Unicode Standard. These additions include new characters for Cyrillic, Greek, Hebrew, Kannada, Latin, math, phonetic extensions, symbols.
New scripts have been added in Unicode 5.0: N'Ko, Balinese, Phags-pa, Phoenician, Cuneiform.
Improvements have been made in how to use characters, for example, their properties or display algorithms.
In addition to classifications for all of the new characters, a number of Southeast Asian characters have been re-classified.
Recommended Database Character Sets and Statement of Direction
A list of character sets has been compiled that Oracle strongly recommends for usage as the database character set. For new system deployment, the database character set is limited to this list of recommended character sets.
Improved performance for character set conversion.
New report section for Database Character Set Scanner that provides information about compact binary XML (CSX) data in the Data Dictionary.
GINSTALL utility for adding customized locale files to Java components.
See Also:Chapter 13, "Customizing Locale Data"
Three new languages added: Albanian, Belarusian, and Irish, and two new territories added: Albania and Belarus.
See Also:Appendix A, "Locale Data"
Linguistic index support for collation-sensitive SQL
Support for Unicode 4.0.
Unicode support has been enhanced to support the latest version of the Unicode standard.
Character Set Scanner Utilities Enhancements
The Database Character Set Scanner (
CSSCAN) introduces two new parameters,
COLUMN, which offer finer control in performing selective scanning. Support for multilevel varrays and nested tables has also been added.
The Language and Character Set File Scanner (
LCSSCAN) now supports the detection of HTML files. The detection quality of shorter text strings has also been enhanced.
Globalization Development Kit
The Globalization Development Kit (GDK) for PL/SQL provides new locale mapping functions, and offers support for Japanese Kana conversion using the new transliteration function in the
NCHAR String Literal Support
NCHAR literals used in insert and update statements no longer rely on the database character set for conversion. This means that multilingual data can be added without restrictions such as having to provide hex Unicode values. The support for this feature is available in SQL, PL/SQL, OCI, and JDBC.
Consistent Linguistic Ordering Support
The support for all SQL functions and operators to honor the
NLS_SORT setting is now available using the new
LINGUISTIC. This feature ensures all SQL string comparisons are consistent, and that they follow the linguistic convention as specified in the