Changes in Oracle Database Globalization Support Guide for Oracle Database 23ai

The following are changes in Oracle Database Globalization Support Guide for Oracle Database 23ai.

New Features

• Support for Unicode 15.0, a major version of the Unicode Standard that supersedes all its previous versions.

  See "Unicode Support".

• Enhanced Ideographic Variation Sequence (IVS) support:

  • A new UCA collation UCA1210_JAPANESE_IVS provides IVS support when processing Japanese text.

    See "The UCA Japanese IVS Collation".

  • String operations that use Unicode composed characters now count an IVS as one complete character. These operations include the SQL functions INSTRC, LENGTHC, and SUBSTRC, and the SQL condition LIKEC.

    See "SQL Functions for Different Length Semantics" and LIKE Conditions for Different Length Semantics.

• A new territory TURKIYE, which supports the official name of the country of Türkiye.

  See "Territories".

• A new linguistic sort ICELANDIC_IST, which implements the Icelandic Standard IST 130:2004.

  See "Linguistic Collations".

• The implementation of the Oracle client character set ZHS32GB18030 is updated to support the latest GB18030-2022 standard.

  See "Client-Only Character Sets".

• The UTL_I18N package provides three new procedures that detect the most likely Oracle character sets and Oracle languages for a given data sample.

  See DETECT_CHARSET, DETECT_LANGUAGE, and DETECT_LANGUAGE_CHARSET in Oracle Database PL/SQL Packages and Types Reference.

• The process of upgrading time zone data using the DBMS_DST package has been enhanced as follows:

  • The upgrade is optimized to take the actual data contents of a table into account. Only tables impacted by a daylight saving time rule change will undergo a data change. See "Upgrade Window".

  • You can monitor the actions performed on tables during the upgrade process by viewing the upgrade history table. See "About the Upgrade History Table".

• The new TIME_AT_DBTIMEZONE initialization parameter allows you to specify whether time-dependent database operations use the time zone of the database host system or the time zone of the PDB.

  See Oracle Database Reference for more information.