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