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 Database 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 Database 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 Database Character Sets with User-Defined Character Ranges
• A-1 Oracle Database Supported Languages
• A-2 Oracle Database Supported Messages
• A-3 Oracle Database Supported Territories
• A-4 Recommended ASCII Database Character Sets
• A-5 Recommended EBCDIC Database Character Sets
• A-6 Other ASCII-based Database Character Sets
• A-7 Other EBCDIC-based Database 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
• A-19 Obsolete Territories
• A-20 Obsolete Languages
• A-21 Obsolete Character Sets and Replacements
• B-1 Unicode Character Code Ranges for UTF-16 Character Codes
• B-2 Unicode Character Code Ranges for UTF-8 Character Codes