Oracle8i National Language Support Guide
Release 8.1.5

A67789-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Feature Coverage and Availability
Audience
Knowledge Assumed of the Reader
Installation and Migration Information
Application Design Information
How Oracle8i National Language Support Guide Is Organized
Conventions Used in This Manual

1 Understanding Oracle NLS

Oracle Server NLS Architecture
Locale-Independent Operation
Client/Server Architecture
Standard Features
Language Support
Territory Support
Date and Time Formats
Monetary and Numeric Formats
Calendars
Linguistic Sorting
Character Set Support
Customization Features
Character Set Customization
Calendar Customization
SQL Support

2 Setting Up an NLS Environment

Setting NLS Parameters
Choosing a Locale with NLS_LANG
Specifying NLS_LANG
NLS_LANG Examples
Overriding Language and Territory Specifications
Time Parameters
Date Parameters
Date Formats
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
Calendar Parameter
Calendar Formats
NLS_CALENDAR
Numeric Parameters
Numeric Formats
NLS_NUMERIC_CHARACTERS
Monetary Parameters
Currency Formats
NLS_CURRENCY
NLS_ISO_CURRENCY
NLS_DUAL_CURRENCY
NLS_MONETARY_CHARACTERS
NLS_CREDIT
NLS_DEBIT
Collation Parameters
Sorting Order
Sorting Character Data
NLS_SORT
NLS_COMP
NLS_LIST_SEPARATOR
Character Set Parameters
NLS_NCHAR

3 Choosing a Character Set

What is an Encoded Character Set?
Which Characters to Encode?
Writing Systems
How many Languages does a Character Set Support?
How are These Characters Encoded?
Single-Byte Encoding Schemes
Multibyte Encoding Schemes
Oracle's Naming Convention for Character Sets
Tips on Choosing an Oracle Database Character Set
Interoperability with System Resources and Applications
Character Set Conversion
Database Schema
Performance Implications
Restrictions
Tips on Choosing an Oracle NCHAR Character Set
Database Schema
Performance Implications
Restrictions
Considerations for Different Encoding Schemes
Be Careful when Mixing Fixed-Width and Varying-Width Character Sets
Storing Data in Multi-Byte Character Sets
Naming Database Objects
Summary of Data Types and Supported Encoding Schemes
Changing the Character Set After Database Creation
Customizing Character Sets
Character Sets with User-Defined Characters
Oracle's Character Set Conversion Architecture
Unicode 2.0 Private Use Area
UDC Cross References
Monolingual Database Example
Character Set Conversion
Multilingual Database Example
Restricted Multilingual Support
Unrestricted Multilingual Support

4 SQL Programming

Locale-Dependent SQL Functions
Default Specifications
Specifying Parameters
Unacceptable Parameters
CONVERT Function
Character Set SQL Functions
NLSSORT Function
Pattern Matching Characters for Fixed-Width Multi-Byte Character Sets
Time/Date/Calendar Formats
Date Formats
Numeric Formats
Miscellaneous Topics

5 OCI Programming

NLS Language Information Retrieval
OCINlsGetInfo()
OCINlsGetInfo
OCI_Nls_MaxBufSz
NLS Language Information Retrieval Sample Code
String Manipulation
OCIMultiByteToWideChar
OCIMultiByteInSizeToWideChar
OCIWideCharToMultiByte
OCIWideCharInSizeToMultiByte
OCIWideCharToLower
OCIWideCharToUpper
OCIWideCharStrcmp
OCIWideCharStrncmp
OCIWideCharStrcat
OCIWideCharStrchr
OCIWideCharStrcpy
OCIWideCharStrlen
OCIWideCharStrncat
OCIWideCharStrncpy
OCIWideCharStrrchr
OCIWideCharStrCaseConversion
OCIWideCharDisplayLength
OCIWideCharMultiByteLength
OCIMultiByteStrcmp
OCIMultiByteStrncmp
OCIMultiByteStrcat
OCIMultiByteStrcpy
OCIMultiByteStrlen
OCIMultiByteStrncat
OCIMultiByteStrncpy
OCIMultiByteStrnDisplayLength
OCIMultiByteStrCaseConversion
String Manipulation Sample Code
Character Classification
OCIWideCharIsAlnum
OCIWideCharIsAlpha
OCIWideCharIsCntrl
OCIWideCharIsDigit
OCIWideCharIsGraph
OCIWideCharIsLower
OCIWideCharIsPrint
OCIWideCharIsPunct
OCIWideCharIsSpace
OCIWideCharIsUpper
OCIWideCharIsXdigit
OCIWideCharIsSingleByte
Character Classification Sample Code
Character Set Conversion
OCICharSetToUnicode
OCIUnicodeToCharSet
OCICharSetConversionIsReplacementUsed
Character Set Conversion Sample Code
Messaging Mechanism
OCIMessageOpen
OCIMessageGet
OCIMessageClose
LMSGEN
Text Message File Format
Message Example

A Locale Data

Languages
Translated Messages
Territories
Character Sets
Asian Language Character Sets
European Language Character Sets
Middle Eastern Language Character Sets
Universal Character Sets
Linguistic Definitions
Calendar Systems
Character Sets that Support the Euro Symbol

B Customizing Locale Data

Customized Character Sets
Character Set Definition Files
Customized Calendars
Overview
NLS Calendar Utility
Utilities
NLS Data Installation Utility
Overview
Syntax
Return Codes
Usage
NLS Configuration Utility
Overview
Syntax
Menus

C Obsolete Locale Data

Obsolete NLS Data

D Glossary

Glossary
ASCII
Binary Sorting
Case Conversion
Character
Character Classification
Character Encoding Scheme
Character Set Conversion
Client Character Set
Collation
Combining Character
Composite Character
Composite Character Sequence
Database Character Set
Diacritical Mark
EBCDIC
Encoded Character Set
Encoding Scheme
EUC
Euro
Export
Font
Glyph
Ideograph
Import
Internationalization
ISO
ISO/IEC 10646
ISO Currency
ISO 8859
Latin-1
Linguistic Index
Linguistic Sorting
Local Currency
Locale
Localization
Monolingual Support
Multibyte Character
NCHAR Character Set
Net8
NLS
NLSDATA
NLSRTL
Replacement Character
Restricted Multilingual Support
SQL*Net
Script
Server Character Set
UCS-2
Unicode
Unicode Codepoint
Unicode Mapping Between UCS and UTF Formats
UCS2
UCS4
Unrestricted Multilingual Support
UTF-8
UTF-16
Wide Character


Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Index