Oracle Database Globalization Support Guide B28298Database
User Manual:
Open the PDF directly: View PDF
Page Count: 414 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- Preface
- What's New in Globalization Support?
- 1 Overview of Globalization Support
- 2 Choosing a Character Set
- Character Set Encoding
- Length Semantics
- Choosing an Oracle Database Character Set
- Current and Future Language Requirements
- Client Operating System and Application Compatibility
- Character Set Conversion Between Clients and the Server
- Performance Implications of Choosing a Database Character Set
- Restrictions on Database Character Sets
- Database Character Set Statement of Direction
- Choosing Unicode as a Database Character Set
- Choosing a National Character Set
- Summary of Supported Datatypes
- Changing the Character Set After Database Creation
- Monolingual Database Scenario
- Multilingual Database Scenarios
- 3 Setting Up a Globalization Support Environment
- Setting NLS Parameters
- Choosing a Locale with the NLS_LANG Environment Variable
- NLS Database Parameters
- Language and Territory Parameters
- Date and Time Parameters
- Calendar Definitions
- Numeric and List Parameters
- Monetary Parameters
- Linguistic Sort Parameters
- Character Set Conversion Parameter
- Length Semantics
- 4 Datetime Datatypes and Time Zone Support
- Overview of Datetime and Interval Datatypes and Time Zone Support
- Datetime and Interval Datatypes
- Datetime and Interval Arithmetic and Comparisons
- Datetime SQL Functions
- Datetime and Time Zone Parameters and Environment Variables
- Choosing a Time Zone File
- Upgrading the Time Zone File
- Setting the Database Time Zone
- Setting the Session Time Zone
- Converting Time Zones With the AT TIME ZONE Clause
- Support for Daylight Saving Time
- 5 Linguistic Sorting and String Searching
- Overview of Oracle Database Sorting Capabilities
- Using Binary Sorts
- Using Linguistic Sorts
- Linguistic Sort Features
- Case-Insensitive and Accent-Insensitive Linguistic Sorts
- Performing Linguistic Comparisons
- Using Linguistic Indexes
- Searching Linguistic Strings
- SQL Regular Expressions in a Multilingual Environment
- 6 Supporting Multilingual Databases with Unicode
- Overview of Unicode
- What is Unicode?
- Implementing a Unicode Solution in the Database
- Unicode Case Studies
- Designing Database Schemas to Support Multiple Languages
- 7 Programming with Unicode
- Overview of Programming with Unicode
- SQL and PL/SQL Programming with Unicode
- SQL NCHAR Datatypes
- Implicit Datatype Conversion Between NCHAR and Other Datatypes
- Exception Handling for Data Loss During Datatype Conversion
- Rules for Implicit Datatype Conversion
- SQL Functions for Unicode Datatypes
- Other SQL Functions
- Unicode String Literals
- NCHAR String Literal Replacement
- Using the UTL_FILE Package with NCHAR Data
- OCI Programming with Unicode
- OCIEnvNlsCreate() Function for Unicode Programming
- OCI Unicode Code Conversion
- Setting UTF-8 to the NLS_LANG Character Set in OCI
- Binding and Defining SQL CHAR Datatypes in OCI
- Binding and Defining SQL NCHAR Datatypes in OCI
- Handling SQL NCHAR String Literals in OCI
- Binding and Defining CLOB and NCLOB Unicode Data in OCI
- Pro*C/C++ Programming with Unicode
- JDBC Programming with Unicode
- Binding and Defining Java Strings to SQL CHAR Datatypes
- Binding and Defining Java Strings to SQL NCHAR Datatypes
- Using the SQL NCHAR Datatypes Without Changing the Code
- Using SQL NCHAR String Literals in JDBC
- Data Conversion in JDBC
- Using oracle.sql.CHAR in Oracle Object Types
- Restrictions on Accessing SQL CHAR Data with JDBC
- ODBC and OLE DB Programming with Unicode
- XML Programming with Unicode
- 8 Oracle Globalization Development Kit
- Overview of the Oracle Globalization Development Kit
- Designing a Global Internet Application
- Developing a Global Internet Application
- Getting Started with the Globalization Development Kit
- GDK Quick Start
- GDK Application Framework for J2EE
- Making the GDK Framework Available to J2EE Applications
- Integrating Locale Sources into the GDK Framework
- Getting the User Locale From the GDK Framework
- Implementing Locale Awareness Using the GDK Localizer
- Defining the Supported Application Locales in the GDK
- Handling Non-ASCII Input and Output in the GDK Framework
- Managing Localized Content in the GDK
- GDK Java API
- Oracle Locale Information in the GDK
- Oracle Locale Mapping in the GDK
- Oracle Character Set Conversion (JDK 1.4 and Later) in the GDK
- Oracle Date, Number, and Monetary Formats in the GDK
- Oracle Binary and Linguistic Sorts in the GDK
- Oracle Language and Character Set Detection in the GDK
- Oracle Translated Locale and Time Zone Names in the GDK
- Using the GDK with E-Mail Programs
- The GDK Application Configuration File
- GDK for Java Supplied Packages and Classes
- GDK for PL/SQL Supplied Packages
- GDK Error Messages
- 9 SQL and PL/SQL Programming in a Global Environment
- Locale-Dependent SQL Functions with Optional NLS Parameters
- Other Locale-Dependent SQL Functions
- Miscellaneous Topics for SQL and PL/SQL Programming in a Global Environment
- 10 OCI Programming in a Global Environment
- 11 Character Set Migration
- 12 Character Set Scanner Utilities
- The Language and Character Set File Scanner
- The Database Character Set Scanner
- Scan Modes in the Database Character Set Scanner
- Installing and Starting the Database Character Set Scanner
- Database Character Set Scanner Parameters
- Database Character Set Scanner Sessions: Examples
- Database Character Set Scanner Reports
- Database Scan Summary Report
- Database Size
- Database Scan Parameters
- Scan Summary
- Data Dictionary Conversion Summary
- Application Data Conversion Summary
- Application Data Conversion Summary Per Column Size Boundary
- Distribution of Convertible Data Per Table
- Distribution of Convertible Data Per Column
- Indexes To Be Rebuilt
- Truncation Due To Character Semantics
- Character Set Detection Result
- Language Detection Result
- Database Scan Individual Exception Report
- Database Scan Summary Report
- How to Handle Convertible or Lossy Data in the Data Dictionary
- Storage and Performance Considerations in the Database Character Set Scanner
- Database Character Set Scanner CSALTER Script
- Database Character Set Scanner Views
- Database Character Set Scanner Error Messages
- 13 Customizing Locale Data
- Overview of the Oracle Locale Builder Utility
- Creating a New Language Definition with Oracle Locale Builder
- Creating a New Territory Definition with the Oracle Locale Builder
- Displaying a Code Chart with the Oracle Locale Builder
- Creating a New Character Set Definition with the Oracle Locale Builder
- Character Sets with User-Defined Characters
- Oracle Database Character Set Conversion Architecture
- Unicode 5.0 Private Use Area
- User-Defined Character Cross-References Between Character Sets
- Guidelines for Creating a New Character Set from an Existing Character Set
- Example: Creating a New Character Set Definition with the Oracle Locale Builder
- Creating a New Linguistic Sort with the Oracle Locale Builder
- Generating and Installing NLB Files
- Deploying Custom NLB Files on Other Platforms
- Upgrading Custom NLB Files from Previous Releases of Oracle Database
- Transporting NLB Data from One Platform to Another
- Adding Custom Locale Definitions to Java Components with the GINSTALL Utility
- A Locale Data
- B Unicode Character Code Assignments
- Glossary
- Index