Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Globalization Support Guide
- 1 Overview of Globalization Support
-
2
Choosing a Character Set
- 2.1 Character Set Encoding
- 2.2 Length Semantics
-
2.3
Choosing an Oracle Database Character Set
- 2.3.1 Current and Future Language Requirements
- 2.3.2 Client Operating System and Application Compatibility
- 2.3.3 Character Set Conversion Between Clients and the Server
- 2.3.4 Performance Implications of Choosing a Database Character Set
- 2.3.5 Restrictions on Database Character Sets
- 2.3.6 Database Character Set Statement of Direction
- 2.3.7 Choosing Unicode as a Database Character Set
- 2.3.8 Choosing a National Character Set
- 2.3.9 Summary of Supported Data Types
- 2.4 Choosing a Database Character Set for a Multitenant Container Database
- 2.5 Changing the Character Set After Database Creation
- 2.6 Monolingual Database Scenario
- 2.7 Multilingual Database Scenario
-
3
Setting Up a Globalization Support Environment
- 3.1 Setting NLS Parameters
- 3.2 Choosing a Locale with the NLS_LANG Environment Variable
- 3.3 Character Set Parameter
- 3.4 NLS Database Parameters
- 3.5 Language and Territory Parameters
- 3.6 Date and Time Parameters
- 3.7 Calendar Definitions
- 3.8 Numeric and List Parameters
- 3.9 Monetary Parameters
- 3.10 Linguistic Sort Parameters
- 3.11 Character Set Conversion Parameter
- 3.12 Length Semantics
-
4
Datetime Data Types and Time Zone Support
- 4.1 Overview of Datetime and Interval Data Types and Time Zone Support
- 4.2 Datetime and Interval Data Types
- 4.3 Datetime and Interval Arithmetic and Comparisons
- 4.4 Datetime SQL Functions
- 4.5 Datetime and Time Zone Parameters and Environment Variables
- 4.6 Choosing a Time Zone File
- 4.7 Upgrading the Time Zone File and Timestamp with Time Zone Data
- 4.8 Clients and Servers Operating with Different Versions of Time Zone Files
- 4.9 Setting the Database Time Zone
- 4.10 Setting the Session Time Zone
- 4.11 Converting Time Zones With the AT TIME ZONE Clause
- 4.12 Support for Daylight Saving Time
-
5
Linguistic Sorting and Matching
- 5.1 Overview of Oracle Database Collation Capabilities
- 5.2 Using Binary Collation
- 5.3 Using Linguistic Collation
-
5.4
Linguistic Collation Features
- 5.4.1 Base Letters
- 5.4.2 Ignorable Characters
- 5.4.3 Variable Characters and Variable Weighting
- 5.4.4 Contracting Characters
- 5.4.5 Expanding Characters
- 5.4.6 Context-Sensitive Characters
- 5.4.7 Canonical Equivalence
- 5.4.8 Reverse Secondary Sorting
- 5.4.9 Character Rearrangement for Thai and Laotian Characters
- 5.4.10 Special Letters
- 5.4.11 Special Combination Letters
- 5.4.12 Special Uppercase Letters
- 5.4.13 Special Lowercase Letters
- 5.5 Case-Insensitive and Accent-Insensitive Linguistic Collation
- 5.6 Performing Linguistic Comparisons
- 5.7 Using Linguistic Indexes
- 5.8 Searching Linguistic Strings
- 5.9 SQL Regular Expressions in a Multilingual Environment
-
5.10
Column-Level Collation and Case Sensitivity
- 5.10.1 About Data-Bound Collation
- 5.10.2 Default Collations
- 5.10.3 Enabling Data-Bound Collation
-
5.10.4
Specifying a Data-Bound Collation
- 5.10.4.1 Effective Schema Default Collation
- 5.10.4.2 Specifying Data-Bound Collation for a Schema
- 5.10.4.3 Specifying Data-Bound Collation for a Table
- 5.10.4.4 Specifying Data-Bound Collation for a View and a Materialized View
- 5.10.4.5 Specifying Data-Bound Collation for a Column
- 5.10.4.6 Specifying Data-Bound Collation for PL/SQL Units
- 5.10.4.7 Specifying Data-Bound Collation for SQL Expressions
- 5.10.5 Viewing the Data-Bound Collation of a Database Object
- 5.10.6 Case-Insensitive Database
- 5.10.7 Effect of Data-Bound Collation on Other Database Objects
- 5.10.8 Effect of Data-Bound Collation on Distributed Queries and DML Operations
- 5.10.9 Effect of Data-Bound Collation on PL/SQL Types and User-Defined Types
- 5.10.10 Effect of Data-Bound Collation on Oracle XML DB
-
6
Supporting Multilingual Databases with Unicode
- 6.1 What is the Unicode Standard?
- 6.2 Features of the Unicode Standard
- 6.3 Implementing a Unicode Solution in the Database
- 6.4 Unicode Case Studies
- 6.5 Designing Database Schemas to Support Multiple Languages
-
7
Programming with Unicode
- 7.1 Overview of Programming with Unicode
-
7.2
SQL and PL/SQL Programming with Unicode
- 7.2.1 SQL NCHAR Data Types
- 7.2.2 Implicit Data Type Conversion Between NCHAR and Other Data Types
- 7.2.3 Exception Handling for Data Loss During Data Type Conversion
- 7.2.4 Rules for Implicit Data Type Conversion
- 7.2.5 SQL Functions for Unicode Data Types
- 7.2.6 Other SQL Functions
- 7.2.7 Unicode String Literals
- 7.2.8 NCHAR String Literal Replacement
- 7.2.9 Using the UTL_FILE Package with NCHAR Data
-
7.3
OCI Programming with Unicode
- 7.3.1 OCIEnvNlsCreate() Function for Unicode Programming
- 7.3.2 OCI Unicode Code Conversion
- 7.3.3 Setting UTF-8 to the NLS_LANG Character Set in OCI
- 7.3.4 Binding and Defining SQL CHAR Data Types in OCI
- 7.3.5 Binding and Defining SQL NCHAR Data Types in OCI
- 7.3.6 Handling SQL NCHAR String Literals in OCI
- 7.3.7 Binding and Defining CLOB and NCLOB Unicode Data in OCI
- 7.4 Pro*C/C++ Programming with Unicode
-
7.5
JDBC Programming with Unicode
- 7.5.1 Binding and Defining Java Strings to SQL CHAR Data Types
- 7.5.2 Binding and Defining Java Strings to SQL NCHAR Data Types
- 7.5.3 Using the SQL NCHAR Data Types Without Changing the Code
- 7.5.4 Using SQL NCHAR String Literals in JDBC
- 7.5.5 Data Conversion in JDBC
- 7.5.6 Using oracle.sql.CHAR in Oracle Object Types
- 7.5.7 Restrictions on Accessing SQL CHAR Data with JDBC
- 7.6 ODBC and OLE DB Programming with Unicode
- 7.7 XML Programming with Unicode
-
8
Oracle Globalization Development Kit
- 8.1 Overview of the Oracle Globalization Development Kit
- 8.2 Designing a Global Internet Application
- 8.3 Developing a Global Internet Application
- 8.4 Getting Started with the Globalization Development Kit
- 8.5 GDK Quick Start
-
8.6
GDK Application Framework for J2EE
- 8.6.1 Making the GDK Framework Available to J2EE Applications
- 8.6.2 Integrating Locale Sources into the GDK Framework
- 8.6.3 Getting the User Locale From the GDK Framework
- 8.6.4 Implementing Locale Awareness Using the GDK Localizer
- 8.6.5 Defining the Supported Application Locales in the GDK
- 8.6.6 Handling Non-ASCII Input and Output in the GDK Framework
- 8.6.7 Managing Localized Content in the GDK
-
8.7
GDK Java API
- 8.7.1 Oracle Locale Information in the GDK
- 8.7.2 Oracle Locale Mapping in the GDK
- 8.7.3 Oracle Character Set Conversion in the GDK
- 8.7.4 Oracle Date, Number, and Monetary Formats in the GDK
- 8.7.5 Oracle Binary and Linguistic Sorts in the GDK
- 8.7.6 Oracle Language and Character Set Detection in the GDK
- 8.7.7 Oracle Translated Locale and Time Zone Names in the GDK
- 8.7.8 Using the GDK with E-Mail Programs
- 8.8 The GDK Application Configuration File
- 8.9 GDK for Java Supplied Packages and Classes
- 8.10 GDK for PL/SQL Supplied Packages
- 8.11 GDK Error Messages
-
9
SQL and PL/SQL Programming in a Global Environment
- 9.1 Locale-Dependent SQL Functions with Optional NLS Parameters
- 9.2 Other Locale-Dependent SQL Functions
- 9.3 Miscellaneous Topics for SQL and PL/SQL Programming in a Global Environment
-
10
OCI Programming in a Global Environment
- 10.1 Using the OCI NLS Functions
- 10.2 Specifying Character Sets in OCI
- 10.3 Getting Locale Information in OCI
- 10.4 Mapping Locale Information Between Oracle and Other Standards
- 10.5 Manipulating Strings in OCI
- 10.6 Classifying Characters in OCI
- 10.7 Converting Character Sets in OCI
- 10.8 OCI Messaging Functions
- 10.9 lmsgen Utility
- 11 Character Set Migration
-
12
Customizing Locale Data
- 12.1 Overview of the Oracle Locale Builder Utility
- 12.2 Creating a New Language Definition with Oracle Locale Builder
- 12.3 Creating a New Territory Definition with the Oracle Locale Builder
- 12.4 Displaying a Code Chart with the Oracle Locale Builder
-
12.5
Creating a New Character Set Definition with the Oracle Locale Builder
- 12.5.1 Character Sets with User-Defined Characters
- 12.5.2 Oracle Database Character Set Conversion Architecture
- 12.5.3 Unicode Private Use Area
- 12.5.4 User-Defined Character Cross-References Between Character Sets
- 12.5.5 Guidelines for Creating a New Character Set from an Existing Character Set
- 12.5.6 Example: Creating a New Character Set Definition with the Oracle Locale Builder
- 12.6 Creating a New Linguistic Sort with the Oracle Locale Builder
- 12.7 Generating and Installing NLB Files
- 12.8 Upgrading Custom NLB Files from Previous Releases of Oracle Database
- 12.9 Deploying Custom NLB Files to Oracle Installations on the Same Platform
- 12.10 Deploying Custom NLB Files to Oracle Installations on Another Platform
- 12.11 Adding Custom Locale Definitions to Java Components with the GINSTALL Utility
- 12.12 Customizing Calendars with the NLS Calendar Utility
- A Locale Data
- B Unicode Character Code Assignments
- C Collation Derivation and Determination Rules for SQL Operations
- Glossary
- Index