This preface contains:
Changes in Oracle Database Release 18c, Version 18.1
The following are changes in Oracle Database Globalization Support Guide for Oracle Database Release 18c, Version 18.1.
Support for Unicode 9.0, a major version of the Unicode Standard that supersedes all its previous versions.
See "Unicode Support"
You can now partition a table by range, list, or reference independently of the declared collation of the partitioning key column. Before Oracle Database 18c, only the collations
BINARY, USING_NLS_COMP, USING_NLS_SORT,and
USING_NLS_SORT_CSwere allowed in partitioning keys. Thus, you can now partition a table by character values in a case-insensitive way by declaring a case-insensitive collation for the table partitioning key column.
In Oracle Call Interface (OCI), you can now pass a collation for a bind variable in a query or a DML statement using the value of the
OCI_ATTR_COLLATION_IDattribute. By setting a collation of a bind variable, you can control the collation used to compare the value of the bind variable in comparison conditions and other SQL operations to which the bind variable is an argument. Controlling the collation with the OCI attribute is preferable over inserting the COLLATE operator into a SQL statement text. The latter increases the risk of introducing a SQL injection issue.
See the notes in the section "Collation Derivation"
The new overloaded functions
VALIDATE_CHARACTER_ENCODINGare added to the PL/SQL package
UTL_I18Nto validate the character encoding of VARCHAR2, NVARCHAR2, CLOB, and NCLOB data.
Support for additional languages and territories.
Additional languages supported in this release:
Additional territories supported in this release:
ANGOLA, ANTIGUA AND BARBUDA, ARUBA, BARBADOS, BOTSWANA, CAYMAN ISLANDS, CURACAO, DOMINICA, DOMINICAN REPUBLIC, GHANA, GRENADA, GUYANA, HAITI, JAMAICA, LIECHTENSTEIN, MACAO, MALAWI, MAURITIUS, MOLDOVA, MOZAMBIQUE, NAMIBIA, SAINT KITTS AND NEVIS, SAINT LUCIA, SIERRA LEONE, SOUTH SUDAN, SURINAME, SWAZILAND, TRINIDAD AND TOBAGO, TURKMENISTAN,and
Changes in Oracle Database 12c Release 2 (12.2)
The following are changes in Oracle Database Globalization Support Guide for Oracle Database 12c Release 2 (12.2).
Support for Unicode 7.0, a major version of the Unicode Standard that supersedes all previous versions of the standard.
See "Unicode Support"
Unicode character set
AL32UTF8is now used as the default database character set when a database is created using Oracle Universal Installer (OUI) or Oracle Database Configuration Assistant (DBCA). The
AL32UTF8character set is Oracle's implementation of the industry standard
UTF-8encoding, which supports most of the written languages of the world. Making the
AL32UTF8character set the default character set for new database deployments enables the database to support multilingual globalized applications out-of-the-box.
Support for pluggable databases (PDBs) with different database character sets in a multitenant container database (CDB). In the earlier Oracle Database release, it was mandatory to have the same database character set for all the PDBs in a CDB.
The column-level collation feature allows you to declare character comparison rules on the column level. The collation declared for a column is automatically applied to all the collation-sensitive SQL operations referencing that column. This enables applications to consistently apply language-specific comparison rules to exactly the data that needs these rules. Implementing this feature simplifies application migration to Oracle Database from non-Oracle database systems that support column-level collation declaration.
The column-level collation feature also allows you to declare a case-insensitive collation for a table or a schema, so that all the columns in a table or a schema can be always compared in a case-insensitive way. Thus, using this feature, you can now easily create the whole database as a case-insensitive database.
The Unicode Collation Algorithm (UCA) 6.1 collations (UCA0610_*) are deprecated in this release. They can be desupported and unavailable in a future release. Oracle recommends the use of UCA 7.0 collations (UCA0700_*) instead.
See Table A-17 for the list of UCA collations supported in this release.
Changes in Oracle Database 12c Release 1 (12.1)
The following are changes in Oracle Database Globalization Support Guide for Oracle Database 12c Release 1 (12.1).
Support for Unicode 6.2, a major version of the Unicode Standard that supersedes all previous versions of the standard.
Support for new locales.
See "Locale Data".
Support for the Unicode Collation Algorithm
The Database Migration Assistant for Unicode (DMU)
The Database Migration Assistant for Unicode (DMU) is an intuitive and user-friendly GUI product that helps you streamline the migration process through an interface that minimizes the manual workload and ensures that the migration tasks are carried out correctly and efficiently. It replaces the
CSALTERutilities as the supported method for migrating databases to Unicode.
Some features previously described in this document (the
CSALTER utilities) are desupported in Oracle Database 12c Release 1 (12.1). See Oracle Database Upgrade Guide for a list of desupported features.