List of Tables

2-1 Encoded Characters in the ASCII Character Set

2-2 7-Bit ASCII Character Set

2-3 lSO 8859 Character Sets

2-4 Examples of Oracle Character Set Names

2-5 Restrictions on Character Sets Used to Express Names

2-6 SQL Datatypes Supported for Encoding Schemes

2-7 Abstract Datatype Support for SQL Datatypes

3-1 Methods of Setting NLS Parameters and Their Priorities

3-2 NLS Parameters

3-3 Oracle Locale Variants

3-4 Date Formats

3-5 Time Formats

3-6 German Calendar Example: March 1998

3-7 First ISO Week of the Year: Example 1, January 1998

3-8 First ISO Week of the Year: Example 2, January 1999

3-9 Examples of Numeric Formats

3-10 Currency Format Examples

3-11 ISO Currency Examples

4-1 Datetime Functions Designed for the DATE Datatype

4-2 Additional Datetime Functions

4-3 Datetime Format Parameters

5-1 Sample Glyphs and Their Major and Minor Sort Values

5-2 Linguistic Comparison Behavior with NLS_COMP Settings

6-1 Unicode Character Sets Supported by Oracle Database

6-2 Using a Unicode Database

6-3 Using Unicode Datatypes

6-4 Character Set Advantages and Disadvantages for a Unicode Database Solution

6-5 Character Set Advantages and Disadvantages for a Unicode Datatype Solution

6-6 Maximum Datatype Size

6-7 Comparison of LOB Datatypes for Document Storage

7-1 Oracle Database Access Products

7-2 Rules for Conversion Between Datatypes

7-3 OCI Character Set Conversions

7-4 Pro*C/C++ Bind and Define Data Conversion

7-5 OCI Driver Conversion Path

7-6 Thin Driver Conversion Path

7-7 ODBC Implicit Binding Code Conversions

7-8 OLE DB Implicit Bindings

7-9 Server ODBC Unicode Datatype Mapping

7-10 OLE DB Datatype Mapping

8-1 Locale Resources Provided by the GDK

8-2 Mapping Between Common ISO Locales and IANA Character Sets

8-3 Locale Parameters Used in the GDK Framework

9-1 SQL Functions and Their Valid NLS Parameters

9-2 How the SUBSTR Functions Calculate the Length of a String

9-3 LIKE Conditions

10-1 OCI Functions That Return Locale Information

10-2 OCI String Manipulation Functions

10-3 OCI Character Classification Functions

10-4 OCI Character Set Conversion Functions

10-5 OCI Messaging Functions

11-1 Single-Byte and Multibyte Encoding

11-2 Issues During Recovery of a Migrated Database Schema

12-1 Possible Status of the Data Dictionary and Application Data

12-2 Possible Status of Data

13-1 Shift JIS User-Defined Character Ranges

13-2 Oracle Character Sets with User-Defined Character Ranges

A-1 Oracle Supported Languages

A-2 Oracle Supported Messages

A-3 Oracle Supported Territories

A-4 Recommended ASCII Database Character Sets

A-5 Recommended EBCDIC Database Character Sets

A-6 Other ASCII Character Sets

A-7 Other EBCDIC Character Sets

A-8 Character Sets that Support the Euro Symbol

A-9 Client-Only Character Sets

A-10 Universal Character Sets

A-11 Subset-Superset Pairs

A-12 US7ASCII Supersets

A-13 Languages and Character Sets Supported by CSSCAN, LCSSCAN, and GDK

A-14 Monolingual Linguistic Sorts

A-15 Multilingual LInguistic Sorts

A-16 Supported Calendar Systems

A-17 Time Zone Names

A-18 Obsolete Linguistic Sorts in Oracle Database 10g

A-19 Obsolete Territories

A-20 Obsolete Languages

A-21 New Names for Obsolete Character Sets

B-1 Unicode Character Code Ranges for UTF-16 Character Codes

B-2 Unicode Character Code Ranges for UTF-8 Character Codes