Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  R  S  T  U  V  W  X 

Symbols

$ORACLE_HOME/nls/data directory, 1.1.1
$ORACLE_HOME/oracore/zoneinfo/timezone.dat time zone file, 4.6

Numbers

7-bit encoding schemes, 2.1.4.1, 2.1.4.1
8-bit encoding schemes, 2.1.4.1, 2.1.4.1

A

abbreviations
languages, A.1
abstract data type
creating as NCHAR, 2.3.9
accent, 5.5
accent-insensitive linguistic sort, 5.5
ADD_MONTHS SQL function, 4.4
ADO interface and Unicode, 7.6.6
AL16UTF16 character set, 6.2.3, A.4.5
AL24UTFFSS character set, 6.2.3
AL32UTF8 character set, 6.2.3, 6.3.1, A.4.5
ALTER SESSION statement
SET NLS_CURRENCY clause, 3.9.2, 3.9.3
SET NLS_LANGUAGE clause, 3.5.2.1
SET NLS_NUMERIC_CHARACTERS clause, 3.8.2
SET NLS_TERRITORY clause, 3.5.2.1
application-locales, 8.8.3
Arial Unicode MS font, 12.1.1.1
ASCII encoding, 2.1.3.1
AT LOCAL clause, 4.11
AT TIME ZONE clause, 4.11

B

base letters, 5.3.2.1.1, 5.4.1
BFILE data
loading into LOBs, 9.3.4
binary sorts, 5.2
case-insensitive and accent-insensitive, 5.5.2
example, 5.5.3
binding and defining CLOB and NCLOB data in OCI, 7.3.7
binding and defining SQL CHAR datatypes in OCI, 7.3.4
binding and defining SQL NCHAR datatypes in OCI, 7.3.5
BLANK_TRIMMING parameter, 11.1.1.1
BLOBs
creating indexes, 6.5.4.3
byte semantics, 2.2, 3.12.1

C

C number format mask, 3.9.3
Calendar Utility, 12.12
calendars
customizing, 12.12
parameter, 3.7
supported, A.7
canonical equivalence, 5.3.2, 5.4.7
case, 5.1
case-insensitive linguistic collation, 5.5
case-sensitive linguistic collation, 5.5
CDBs, 2.4
CESU-8 compliance, A.4.5
character data
converting with CONVERT SQL function, 9.2.1
character data conversion
database character set, 11.2
character data scanning
before character set migration, 11.2
character rearrangement, 5.4.9
character repertoire, 2.1.1
character semantics, 2.2, 3.12.1
character set
conversion, 12.5.2
data loss
during conversion, 2.3.3
detecting with Globalization Development Kit, 8.7.6
national, 7.2.1.2
character set conversion
between OCI client and database server, 7.3.2
parameters, 3.11
character set definition
customizing, 12.5.6
guidelines for editing files, 12.5.5
naming files, 12.5.5
character set migration
identifying character data conversion problems, 11.2
scanning character data, 11.2
character sets
AL16UTF16, 6.2.3
AL24UTFFSS, 6.2.3
AL32UTF8, 6.2.3
Asian, A.4.1, A.4.1, A.4.1
changing after database creation, 2.5
choosing, 11.1
conversion, 2.3.3, 2.6.1, 9.2.1
conversion using OCI, 10.7
customizing, 12.5
data loss, 11.1.2.1
encoding, 2.1
European, A.4.2, A.4.2
ISO 8859 series, 2.1.3.1
Middle Eastern, A.4.4
migration, 11.1, 11.1.1
naming, 2.1.5
national, 6.3.2, 7.2.1.1
restrictions on character sets used to express names, 2.3.5.1
supersets and subsets, A.4.7
supported, A.4
supporting different character repertoires, 2.1.3
universal, A.4.5
UTFE, 6.2.3
character snational, 2.3.8
character type conversion
error reporting, 3.11.1
characters
available in all Oracle database character sets, 2.1.3
context-sensitive, 5.4.6
contracting, 5.4.4
user-defined, 12.5.1
choosing a character set, 11.1
client operating system
character set compatibility with applications, 2.3.2
CLOB and NCLOB data
binding and defining in OCI, 7.3.7
CLOBs
creating indexes, 6.5.4.2
code chart
displaying and printing, 12.4
code point, 2.1.1
collation
case-insensitive, 5.5
case-sensitive, 5.5
customizing, 12.6
Hiragana and Katakana, 5.3.3.1.4
linguistic, 5.3
monolingual, 5.3.1
multilingual, 5.3.2
Unicode Collation Algorithm, 5.3.3
comparisons
linguistic, 5.6
compatibility
client operating system and application character sets, 2.3.2
composed characters, 5.4.4
context-sensitive characters, 5.4.6
contracting characters, 5.4.4
contracting letters, 5.4.11
control characters, encoding, 2.1.2.3
conversion
between character set ID number and character set name, 9.2.4
CONVERT SQL function, 9.2.1
character sets, A.4.6
convert time zones, 4.11
converting character data
CONVERT SQL function, 9.2.1
converting character data between character sets, 9.2.1
Coordinated Universal Time, 4.2.1.3, 4.2.1.4
creating a database with Unicode datatypes, 6.3.2
creating a Unicode database, 6.3.1
CSREPAIR script, 11.3
currencies
formats, 3.9.1
CURRENT_DATE SQL function, 4.4
CURRENT_TIMESTAMP SQL function, 4.4

D

data conversion
in Pro*C/C++, 7.4.1
OCI driver, 7.5.5.1
ODBC and OLE DB drivers, 7.6.3
thin driver, 7.5.5.2
Unicode Java strings, 7.5.5
data dictionary views
NLS_DATABASE_PARAMETERS, 3.4.1
NLS_INSTANCE_PARAMETERS, 3.4.1
NLS_SESSION_PARAMETER, 3.4.1
data expansion
during character set migration, 11.1.1
during data conversion, 7.3.2.3
data inconsistencies causing data loss, 11.1.2.2
data loss
caused by data inconsistencies, 11.1.2.2
during character set conversion, 2.3.3
during character set migration, 11.1.2.1
during datatype conversion
exceptions, 7.2.3
during OCI Unicode character set conversion, 7.3.2.1
from mixed character sets, 11.1.2.2
Data Pump PL/SQL packages and character set migration, 11.1.2.3
data truncation, 11.1.1
restrictions, 11.1.1.1
data types
abstract, 2.3.9
DATE, 4.2.1.1
datetime, 4.2
inserting values into datetime data types, 4.2.1.5
inserting values into interval data types, 4.2.2.3
interval, 4.2, 4.2.2
INTERVAL DAY TO SECOND, 4.2.2.2
INTERVAL YEAR TO MONTH, 4.2.2.1
supported, 2.3.9
TIMESTAMP, 4.2.1.2
TIMESTAMP WITH LOCAL TIME ZONE, 4.2.1.4
TIMESTAMP WITH TIME ZONE, 4.2.1.3
database
multitenant container, 2.4
database character set
character data conversion, 11.2
choosing, 2.3
compatibility between client operating system and applications, 2.3.2
performance, 2.3.4
Database Migration Assistant for Unicode (DMU), 11.2.1
database schemas
designing for multiple languages, 6.5
database time zone, 4.9
datatype conversion
data loss and exceptions, 7.2.3
implicit, 7.2.4
SQL functions, 7.2.5
date and time parameters, 3.6
DATE data type, 4.2.1.1
date formats, 3.6.1, 3.6.1.1, 9.3.1
and partition bound expressions, 3.6.1.1
dates
ISO standard, 3.7.1.2, 9.3.2
NLS_DATE_LANGUAGE parameter, 3.6.1.2
datetime data types, 4.2
inserting values, 4.2.1.5
datetime format parameters, 4.5.1
Daylight Saving Time
Oracle support, 4.12
rules, 4.7.1
daylight saving time session parameter, 4.5.3
Daylight Saving Time Upgrade parameter, 4.5.4
days
format element, 3.6.1.2
language of names, 3.6.1.2
DB_TZ database time zone, 4.10
DBMS_LOB PL/SQL package, 9.3.4
DBMS_LOB.LOADBLOBFROMFILE procedure, 9.3.4
DBMS_LOB.LOADCLOBFROMFILE procedure, 9.3.4
DBTIMEZONE SQL function, 4.4
dest_char_set parameter, A.4.6
detecting language and character sets
Globalization Development Kit, 8.7.6
detection
supported languages and character sets, A.5
diacritic, 5.1
DMU
Database Migration Assistant for Unicode, 11.2.1
DST_UPGRADE_INSERT_CONV inititialization parameter, 4.5.4
DUCET(Default Unicode Collation Element Table), 5.3.3
dynamic performance views
V$NLS_PARAMETERS, 3.4.2
V$NLS_VALID_VALUES, 3.4.2

E

encoding
control characters, 2.1.2.3
ideographic writing systems, 2.1.2.2
numbers, 2.1.2.3
phonetic writing systems, 2.1.2.1
punctuation, 2.1.2.3
symbols, 2.1.2.3
encoding schemes
7-bit, 2.1.4.1, 2.1.4.1
8-bit, 2.1.4.1, 2.1.4.1
fixed-width, 2.1.4.2
multibyte, 2.1.4.2
shift-sensitive variable-width, 2.1.4.2
shift-sensitive variable-width multibyte, 2.1.4.2
single-byte, 2.1.4.1
variable-width, 2.1.4.2
environment variables
ORA_SDTZ, 4.5.2, 4.10
ORA_TZFILE, 4.5.2
error messages
languages, A.2
translation, A.2
ERROR_ON_OVERLAP_TIME session parameter, 4.5.3
euro
Oracle support, 3.9.5
expanding characters, 5.4.10
characters
expanding, 5.4.5
EXTRACT (datetime) SQL function, 4.4

F

fixed-width multibyte encoding schemes, 2.1.4.2
fonts
Unicode, 12.1.1
Unicode for UNIX, 12.1.1.2
Unicode for Windows, 12.1.1.1
format elements, 9.3.3
C, 9.3.3
D, 9.3.3
day, 3.6.1.2
G, 9.3.3
IW, 9.3.2
IY, 9.3.2
L, 9.3.3
month, 3.6.1.2
RM, 9.3.1
RN, 9.3.3
format masks, 3.8.2, 9.3.1
formats
currency, 3.9.1
date, 3.6.1.1, 4.5.1
numeric, 3.8.1
time, 3.6.2
FROM_TZ SQL function, 4.4

G

GDK
application configuration file, 8.6.1
GDK application configuration file, 8.8
example, 8.8.8
GDK application framework for J2EE, 8.6, 8.6
GDK components, 8.4
GDK error messages, 8.11
GDK Java API, 8.7
GDK Java supplied packages and classes, 8.9
GDK Localizer object, 8.6.4
gdkapp.xml application configuration file, 8.8
gdkapp.xml GDK application configuration file, 8.6.1
getString() method, 7.5.6.1
getStringWithReplacement() method, 7.5.6.1
Globalization Development Kit, 8.1
application configuration file, 8.8
character set conversion, 8.7.3
components, 8.4
defining supported application locales, 8.6.5
e-mail programs, 8.7.8
error messages, 8.11
framework, 8.6
integrating locale sources, 8.6.2
Java API, 8.7
Java supplied packages and classes, 8.9
locale detection, 8.6.3
Localizer object, 8.6.4
managing localized content in static files, 8.6.7.2
managing strings in JSPs and Java servlets, 8.6.7.1
non_ASCII input and output in an HTML page, 8.6.6
Oracle binary and linguistic sorts, 8.7.5
Oracle date, number, and monetary formats, 8.7.4
Oracle language and character set detection, 8.7.6
Oracle locale information, 8.7.1
Oracle locale mapping, 8.7.2
Oracle translated locale and time zone names, 8.7.7
supported locale resources, 8.6.2
globalization features, 1.2
globalization support
architecture, 1.1
Greenwich Mean Time, 4.2.1.3, 4.2.1.4
guessing the language or character set, 11.4

H

Hiragana, 5.3.3.1.4

I

IANA character sets
mapping with ISO locales, 8.6.6
ideographic writing systems, encoding, 2.1.2.2
ignorable characters, 5.4.2
implicit datatype conversion, 7.2.4
indexes
creating for documents stored as CLOBs, 6.5.4.2
creating for multilingual document search, 6.5.4
creating indexes for documents stored as BLOBs, 6.5.4.3
linguistic, 5.7
partitioned, 9.2.5.3
initialization parameter
DST_UPGRADE_INSERT_CONV, 4.5.4
initialization parameters
NLS_DATE_FORMAT, 4.5.1
NLS_TIMESTAMP_FORMAT, 4.5.1
NLS_TIMESTAMP_TZ_FORMAT, 4.5.1
INSTR SQL functions, 7.2.6, 9.2.2, 9.2.2
Internet application
locale
determination, 8.3.1
monolingual, 8.2, 8.2.1
multilingual, 8.2, 8.2.2
interval data types, 4.2, 4.2.2
inserting values, 4.2.2.3
INTERVAL DAY TO SECOND data type, 4.2.2.2
INTERVAL YEAR TO MONTH data type, 4.2.2.1
ISO 8859 character sets, 2.1.3.1
ISO locales
mapping with IANA character sets, 8.6.6
ISO standard
date format, 9.3.2
ISO standard date format, 3.7.1.2, 9.3.2
ISO week number, 9.3.2
IW format element, 9.3.2
IY format element, 9.3.2

J

Java
Unicode data conversion, 7.5.5
Java strings
binding and defining in Unicode, 7.5.1
JDBC drivers
form of use argument, 7.5.3
JDBC OCI driver
and Unicode, 7.1.1
JDBC programming
Unicode, 7.5
JDBC Server Side internal driver
and Unicode, 7.1.1
JDBC Server Side thin driver
and Unicode, 7.1.1
JDBC thin driver
and Unicode, 7.1.1

K

Katakana, 5.3.3.1.4

L

language
detecting with Globalization Development Kit, 8.7.6
language abbreviations, A.1
Language and Character Set File Scanner, 11.4
language definition
customizing, 12.2
overriding, 3.2.2
language support, 1.2.1
languages
error messages, A.2
languages and character sets
supported by LCSSCAN, A.5
LAST_DAY SQL function, 4.4
LCSCCAN
error messages, 11.4.5
LCSSCAN, 11.4
supported languages and character sets, 11.4.4, A.5
LCSSCAN command
BEGIN parameter, 11.4.1
END parameter, 11.4.1
examples, 11.4.2
FILE parameter, 11.4.1
HELP parameter, 11.4.3
online help, 11.4.3
RESULTS parameter, 11.4.1
syntax, 11.4.1
length semantics, 2.2, 3.12
LENGTH SQL functions, 9.2.2, 9.2.2
LIKE conditions in SQL statements, 9.2.3
LIKE2 SQL condition, 9.2.3
LIKE4 SQL condition, 9.2.3
LIKEC SQL condition, 9.2.3
linguistic comparisons, 5.6
linguistic indexes, 5.7
linguistic sort definitions
supported, A.6
linguistic sorts
accent-insensitive, 5.5
BINARY, 5.5.2
BINARY_AI, linguistic sorts
BINARY_CI, 5.5.2
case-insensitive, 5.5
controlling, 9.2.5.4
customizing, 12.6
characters with diacritics, 12.6.1, 12.6.2
levels, 5.3.2.1.1
list of defaults, A.1
parameters, 3.10
list parameter, 3.8
lmsgen utility, 10.9
loading external BFILE data into LOBs, 9.3.4
LOBs
loading external BFILE data, 9.3.4
storing documents in multiple languages, 6.5.3
locale, 3.2
dependencies, 3.2.3
detection
Globalization Development Kit, 8.6.3
of Internet application
determining, 8.3.1
variant, 3.2.3
locale information
mapping between Oracle and other standards, 10.4
locale-charset-map, 8.8.1
locale-determine-rule, 8.8.4
LocaleMapper class, 8.7.8
locale-parameter-name, 8.8.5
LOCALTIMESTAMP SQL function, 4.4
lxegen utility, 12.12

M

message-bundles, 8.8.6
migration
character sets, 11.1
mixed character sets
causing data loss, 11.1.2.2
monetary parameters, 3.9
monolingual Internet application, 8.2.1
monolingual linguistic sorts
example, 5.5.3
supported, A.6
months
format element, 3.6.1.2
language of names, 3.6.1.2
MONTHS_BETWEEN SQL function, 4.4
multibyte encoding schemes, 2.1.4.2
fixed-width, 2.1.4.2
shift-sensitive variable-width, 2.1.4.2
variable-width, 2.1.4.2
multilexers
creating, 6.5.4.1
multilingual data
specifying column lengths, 6.5.1
multilingual document search
creating indexes, 6.5.4
multilingual Internet application, 8.2.2
multilingual linguistic sorts
example, 5.5.3
supported, A.6
multiple languages
designing database schemas, 6.5
storing data, 6.5.2
storing documents in LOBs, 6.5.3
multitenant container databases, 2.4

N

N SQL function, 7.2.5
national character set, 2.3.8, 6.3.2, 7.2.1.1, 7.2.1.2
NCHAR data type
creating abstract data type, 2.3.9
NCHAR datatype, 7.2.1.1
NCHR SQL function, 7.2.7
NCLOB datatype, 7.2.1.3
NEW_TIME SQL function, 4.4
NEXT_DAY SQL function, 4.4
NLB data
transportable, 12.10
NLB file, 12.1.3.1
NLB files, 12.1
generating and installing, 12.7
NLS Calendar Utility, 12.12
NLS parameters
default values in SQL functions, 9.1.1
list, 3.1
setting, 3.1
specifying in SQL functions, 9.1.2
unacceptable in SQL functions, 9.1.3
NLS Runtime Library, 1.1.1
NLS_CALENDAR parameter, 3.7.2
NLS_CHARSET_DECL_LEN SQL function, 9.2.4.3
NLS_CHARSET_ID SQL function, 9.2.4.2
NLS_CHARSET_NAME SQL function, 9.2.4.1
NLS_COMP parameter, 3.10.2, 9.2.5.3
NLS_CREDIT parameter, 3.9.7
NLS_CURRENCY parameter, 3.9.2
NLS_DATABASE_PARAMETERS data dictionary view, 3.4.1
NLS_DATE_FORMAT initialization parameter, 4.5.1
NLS_DATE_FORMAT parameter, 3.6.1.1
NLS_DATE_LANGUAGE parameter, 3.6.1.2
NLS_DEBIT parameter, 3.9.8
NLS_DUAL_CURRENCY parameter, 3.9.4
NLS_INITCAP SQL function, 5.4.12, 9.1
NLS_INSTANCE_PARAMETERS data dictionary view, 3.4.1
NLS_ISO_CURRENCY parameter, 3.9.3
NLS_LANG parameter, 3.2
choosing a locale, 3.2
client setting, 3.2.4
examples, 3.2.1
OCI client applications, 7.3.3
specifying, 3.2.1
UNIX client, 3.2.4
Windows client, 3.2.4
NLS_LANGUAGE parameter, 3.5.1
NLS_LENGTH_SEMANTICS initialization parameter, 2.2
NLS_LENGTH_SEMANTICS session parameter, 2.2
NLS_LIST_SEPARATOR parameter, 3.11
NLS_LOWER SQL function, 5.4.12, 5.5, 9.1
NLS_MONETARY_CHARACTERS parameter, 3.9.6
NLS_NCHAR_CONV_EXCP parameter, 3.11.1
NLS_NUMERIC_CHARACTERS parameter, 3.8.2
NLS_SESSION_PARAMETERS data dictionary view, 3.4.1
NLS_SORT parameter, 3.10.1, 5.7.3.1
NLS_TERRITORY parameter, 3.5.2
NLS_TIMESTAMP_FORMAT initialization parameter, 4.5.1
NLS_TIMESTAMP_FORMAT parameter, 3.6.2.1
parameters
NLS_TIMESTAMP_FORMAT, 3.6.2.2
NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 4.5.1
NLS_UPPER SQL function, 5.4.12, 5.5, 9.1
NLSRTL, 1.1.1
NLSSORT SQL function, 9.1, 9.2.5
syntax, 9.2.5.1
NLT files, 12.1
numbers, encoding, 2.1.2.3
numeric formats, 3.8.1
SQL masks, 9.3.3
numeric parameters, 3.8
NUMTODSINTERVAL SQL function, 4.4
NUMTOYMINTERVAL SQL function, 4.4
NVARCHAR datatype
Pro*C/C++, 7.4.3
NVARCHAR2 datatype, 7.2.1.2

O

obsolete locale data, A.9.4
OCI
binding and defining CLOB and NCLOB data in OCI, 7.3.7
binding and defining SQL NCHAR datatypes, 7.3.5
setting the character set, 10.2
SQL CHAR datatypes, 7.3.4
OCI and Unicode, 7.1.1
OCI character set conversion, 7.3.2.2
data loss, 7.3.2.1
performance, 7.3.2.2
OCI client applications
using Unicode character sets, 7.3.3
OCI data conversion
data expansion, 7.3.2.3
OCI_ATTR_CHARSET_FORM attribute, 7.3.2.1
OCI_ATTR_MAXDATA_SIZE attribute, 7.3.2.3
OCI_UTF16ID character set ID, 7.3.1
OCIBind() function, 7.3.4
OCICharSetConversionIsReplacementUsed(), 10.7
OCICharSetConvert(), 10.7
OCICharsetToUnicode(), 10.7
OCIDefine() function, 7.3.4
OCIEnvNlsCreate(), 7.3.1, 10.2
OCILobRead() function, 7.3.7
OCILobWrite() function, 7.3.7
OCIMessageClose(), 10.8
OCIMessageGet(), 10.8
OCIMessageOpen(), 10.8
OCIMultiByteInSizeToWideChar(), 10.5
OCIMultiByteStrCaseConversion(), 10.5
OCIMultiByteStrcat(), 10.5
OCIMultiByteStrcmp(), 10.5
OCIMultiByteStrcpy(), 10.5
OCIMultiByteStrlen(), 10.5
OCIMultiByteStrncat(), 10.5
OCIMultiByteStrncmp(), 10.5
OCIMultiByteStrncpy(), 10.5
OCIMultiByteStrnDisplayLength(), 10.5
OCIMultiByteToWideChar(), 10.5
OCINlsCharSetIdToName(), 10.3
OCINlsCharSetNameTold(), 10.3
OCINlsEnvironmentVariableGet(), 10.3
OCINlsGetInfo(), 10.3, 10.3
OCINlsNameMap(), 10.4
OCINlsNumericInfoGet(), 10.3
OCIUnicodeToCharset(), 10.7
OCIWideCharDisplayLength(), 10.5
OCIWideCharInSizeToMultiByte(), 10.5
OCIWideCharIsAlnum(), 10.6
OCIWideCharIsAlpha(), 10.6
OCIWideCharIsCntrl(), 10.6
OCIWideCharIsDigit(), 10.6
OCIWideCharIsGraph(), 10.6
OCIWideCharIsLower(), 10.6
OCIWideCharIsPrint(), 10.6
OCIWideCharIsPunct(), 10.6
OCIWideCharIsSingleByte(), 10.6
OCIWideCharIsSpace(), 10.6
OCIWideCharIsUpper(), 10.6, 10.7
OCIWideCharIsXdigit(), 10.6
OCIWideCharMultibyteLength(), 10.5
OCIWideCharStrCaseConversion(), 10.5
OCIWideCharStrcat(), 10.5
OCIWideCharStrchr(), 10.5
OCIWideCharStrcmp(), 10.5
OCIWideCharStrcpy(), 10.5
OCIWideCharStrlen(), 10.5
OCIWideCharStrncat(), 10.5
OCIWideCharStrncmp(), 10.5
OCIWideCharStrncpy(), 10.5
OCIWideCharStrrchr(), 10.5
OCIWideCharToLower(), 10.5
OCIWideCharToMultiByte(), 10.5
OCIWideCharToUpper(), 10.5
ODBC Unicode applications, 7.6.4
OLE DB Unicode datatypes, 7.6.5
operating system
character set compatibility with applications, 2.3.2
ORA_DST_AFFECTED SQL function, 4.4
ORA_DST_CONVERT SQL function, 4.4
ORA_DST_ERROR SQL function, 4.4
ORA_NLS10 environment variable, 1.1.1
ORA_SDTZ environment variable, 4.5.2, 4.10
ORA_TZFILE environment variable, 4.5.2
Oracle Call Interface and Unicode, 7.1.1
Oracle Data Provide for .NET and Unicode, 7.1.1
Oracle Data Pump and character set conversion, 11.1.2.3
Oracle Language and Character Set Detection Java classes, 8.7.6
Oracle Locale Builder
choosing a calendar format, 12.3
choosing currency formats, 12.3
choosing date and time formats, 12.3
displaying code chart, 12.4
Existing Definitions dialog box, 12.1.3.1
fonts, 12.1.1.1, 12.1.1.2
Open File dialog box, 12.1.3.4
Preview NLT screen, 12.1.3.3
restrictions on names for locale objects, 12.2
Session Log dialog box, 12.1.3.2
starting, 12.1.2
Oracle ODBC driver and Unicode, 7.1.1
Oracle OLE DB driver and Unicode, 7.1.1
Oracle Pro*C/C++ and Unicode, 7.1.1
oracle.i18n.lcsd package, 8.9.1
oracle.i18n.net package, 8.9.2
oracle.i18n.servlet package, 8.9.3
oracle.i18n.text package, 8.9.4
oracle.i18n.util package, 8.9.5
oracle.sql.CHAR class
character set conversion, 7.5.6.1
getString() method, 7.5.6.1
getStringWithReplacement() method, 7.5.6.1
toString() method, 7.5.6.1
ORDER BY clause, 9.2.5.4
OS_TZ local operating system time zone, 4.10
overriding language and territory definitions, 3.2.2

P

page-charset, 8.8.2
parameters
BLANK_TRIMMING, 11.1.1.1
calendar, 3.7
character set conversion, 3.11
linguistic sorts, 3.10
methods of setting, 3.1
monetary, 3.9
NLS_CALENDAR, 3.7.2
NLS_COMP, 3.10.2
NLS_CREDIT, 3.9.7
NLS_CURRENCY, 3.9.2
NLS_DATE_FORMAT, 3.6.1.1
NLS_DATE_LANGUAGE, 3.6.1.2
NLS_DEBIT, 3.9.8
NLS_DUAL_CURRENCY, 3.9.4
NLS_ISO_CURRENCY, 3.9.3
NLS_LANG, 3.2
NLS_LANGUAGE, 3.5.1
NLS_LIST_SEPARATOR, 3.11
NLS_MONETARY_CHARACTERS, 3.9.6
NLS_NCHAR_CONV_EXCP, 3.11.1
NLS_NUMERIC_CHARACTERS, 3.8.2
NLS_SORT, 3.10.1
NLS_TERRITORY, 3.5.2
numeric, 3.8
setting, 3.1
time and date, 3.6
time zone, 3.6.2.2
partitioned
indexes, 9.2.5.3
tables, 9.2.5.3
PDBs, 2.4
performance
choosing a database character set, 2.3.4
during OCI Unicode character set conversion, 7.3.2.2
phonetic writing systems, encoding, 2.1.2.1
PL/SQL and SQL and Unicode, 7.1.1
primary level sort, 5.3.2.1.1
Private Use Area, 12.5.3
Pro*C/C++
data conversion, 7.4.1
NVARCHAR datatype, 7.4.3
UVARCHAR datatype, 7.4.4
VARCHAR datatype, 7.4.2
punctuation, encoding, 2.1.2.3

R

REGEXP SQL functions, 5.9
regular expressions
character class, 5.9.3
character range, 5.9.1
collation element delimiter, 5.9.2
equivalence class, 5.9.4
examples, 5.9.5
multilingual environment, 5.9
replacement characters
CONVERT SQL function, 9.2.1
restrictions
data truncation, 11.1.1.1
passwords, 11.1.1.1
space padding during export, 11.1.1.1
usernames, 11.1.1.1
reverse secondary sorting, 5.4.8
ROUND (date) SQL function, 4.4
RPAD SQL function, 7.2.6

S

searching multilingual documents, 6.5.4
searching string, 5.8
secondary level sort, 5.3.2.1.2
session parameters
ERROR_ON_OVERLAP, 4.5.3
session time zone, 4.10
SESSIONTIMEZONE SQL function, 4.4
setFormOfUse() method, 7.5.3
shift-sensitive variable-width multibyte encoding schemes, 2.1.4.2
single-byte encoding schemes, 2.1.4.1
sorting
reverse secondary, 5.4.8
specifying nondefault linguistic sorts, 3.10.1, 3.10.2
source_char_set parameter, A.4.6
space padding
during export, 11.1.1.1
special combination letters, 5.4.4, 5.4.11
special letters, 5.4.5, 5.4.10
special lowercase letters, 5.4.13
special uppercase letters, 5.4.12
SQL CHAR datatypes, 2.3
OCI, 7.3.4
SQL conditions
LIKE2, 9.2.3
LIKE4, 9.2.3
LIKEC, 9.2.3
SQL function
ORA_DST_AFFECTED, 4.4
ORA_DST_CONVERT, 4.4
ORA_DST_ERROR, 4.4
SQL functions
ADD_MONTHS, 4.4
CONVERT, 9.2.1
CURRENT_DATE, 4.4
CURRENT_TIMESTAMP, 4.4
datatype conversion, 7.2.5
DBTIMEZONE, 4.4
default values for NLS parameters, 9.1.1
EXTRACT (datetime), 4.4
FROM_TZ, 4.4
INSTR, 7.2.6, 9.2.2, 9.2.2
LAST_DAY, 4.4
LENGTH, 9.2.2, 9.2.2
LOCALTIMESTAMP, 4.4
MONTHS_BETWEEN, 4.4
N, 7.2.5
NCHR, 7.2.7
NEW_TIME, 4.4
NEXT_DAY, 4.4
NLS_CHARSET_DECL_LEN, 9.2.4.3
NLS_CHARSET_ID, 9.2.4.2
NLS_CHARSET_NAME, 9.2.4.1
NLS_INITCAP, 5.4.12, 9.1
NLS_LOWER, 5.4.12, 5.5, 9.1
NLS_UPPER, 5.4.12, 5.5, 9.1
NLSSORT, 9.1, 9.2.5
NUMTODSINTERVAL, 4.4
NUMTOYMINTERVAL, 4.4
ROUND (date), 4.4
RPAD, 7.2.6
SESSIONTIMEZONE, 4.4
specifying NLS parameters, 9.1.2
SUBSTR, 9.2.2, 9.2.2
SUBSTR2, 9.2.2
SUBSTR4, 9.2.2
SUBSTRB, 9.2.2
SUBSTRC, 9.2.2
SYS_EXTRACT_UTC, 4.4
SYSDATE, 4.4
SYSTIMESTAMP, 4.4
TO_CHAR, 9.1
TO_CHAR (datetime), 4.4
TO_DATE, 7.2.5, 9.1
TO_DSINTERVAL, 4.4
TO_NCHAR, 7.2.5
TO_NUMBER, 9.1
TO_TIMESTAMP, 4.4
TO_TIMESTAMP_TZ, 4.4
TO_YMINTERVAL, 4.4
TRUNC (date), 4.4
TZ_OFFSET, 4.4
unacceptable NLS parameters, 9.1.3
UNISTR, 7.2.7
SQL NCHAR datatypes
binding and defining in OCI, 7.3.5
SQL statements
LIKE conditions, 9.2.3
strict superset, 6.2.2.1
string comparisons
WHERE clause, 9.2.5.2
string literals
Unicode, 7.2.7
string manipulation using OCI, 10.5
strings
searching, 5.8
SUBSTR SQL function, 9.2.2
SUBSTR SQL functions, 9.2.2
SUBSTR, 9.2.2
SUBSTR2, 9.2.2
SUBSTR4, 9.2.2
SUBSTRB, 9.2.2
SUBSTRC, 9.2.2
SUBSTR4 SQL function, 9.2.2
SUBSTRB SQL function, 9.2.2
SUBSTRC SQL function, 9.2.2
superset, strict, 6.2.2.1
supersets and subsets, A.4.7
supplementary characters, 5.3.2
linguistic sort support, A.6
supported datatypes, 2.3.9
supported territories, A.3
syllabary, 2.1.2.2
symbols, encoding, 2.1.2.3
SYS_EXTRACT_UTC SQL function, 4.4
SYSDATE SQL function, 4.4
effect of session time zone, 4.10
SYSTIMESTAMP SQL function, 4.4

T

tables
partitioned, 9.2.5.3
territory
dependencies, 3.2.3
territory definition, 3.5.2
customizing, 12.3
overriding, 3.2.2
territory support, 1.2.2, A.3
territory variant, 3.2.3
tertiary level sort, 5.3.2.1.3
Thai and Laotian character rearrangement, 5.4.9
tilde, 7.5.7.1
time and date parameters, 3.6
time zone
abbreviations, 4.6
data source, 4.6
database, 4.9
effect on SYSDATE SQL function, 4.10
environment variables, 4.5.2
file, 4.6
names, 4.6
parameters, 3.6.2.2
session, 4.10
time zone file
choosing, 4.6
default, 4.6
upgrade steps, 4.7.3
upgrading, 4.7
time zones
converting, 4.11
upgrading time zone file, 4.7
TIMESTAMP data type, 4.2.1.2
when to use, 4.2.1.6
TIMESTAMP data types
choosing, 4.2.1.6
timestamp format, 3.6.2.1
TIMESTAMP WITH LOCAL TIME ZONE data type, 4.2.1.4
when to use, 4.2.1.6
TIMESTAMP WITH TIME ZONE data type, 4.2.1.3
when to use, 4.2.1.6
TO_CHAR (datetime) SQL function, 4.4
TO_CHAR SQL function, 9.1
default date format, 3.6.1.1, 4.5.1
format masks, 9.3.1
group separator, 3.8.2
language for dates, 3.6.1.2
spelling of days and months, 3.6.1.2
TO_DATE SQL function, 7.2.5, 9.1
default date format, 3.6.1.1, 4.5.1
format masks, 9.3.1
language for dates, 3.6.1.2
spelling of days and months, 3.6.1.2
TO_DSINTERVAL SQL function, 4.4
TO_NCHAR SQL function, 7.2.5
TO_NUMBER SQL function, 9.1
format masks, 9.3.1
TO_TIMESTAMP SQL function, 4.4
TO_TIMESTAMP_TZ SQL function, 4.4
TO_YMINTERVAL SQL function, 4.4
toString() method, 7.5.6.1
transportable NLB data, 12.10
TRUNC (date) SQL function, 4.4
TZ_OFFSET SQL function, 4.4
TZABBREV, 4.6
TZNAME, 4.6

U

UCS-2 encoding, 6.2.2.3
Unicode, 6.1
binding and defining Java strings, 7.5.1
character code assignments, B.1
character set conversion between OCI client and database server, 7.3.2
code ranges for UTF-16 characters, B.1
code ranges for UTF-8 characters, B.1
data conversion in Java, 7.5.5
encoding, 6.2.2
fonts, 12.1.1
JDBC OCI driver, 7.1.1
JDBC programming, 7.5
JDBC Server Side internal driver, 7.1.1
JDBC Server Side thin driver, 7.1.1
JDBC thin driver, 7.1.1
mode, 7.3.1
ODBC and OLE DB programming, 7.6
Oracle Call Interface, 7.1.1
Oracle Data Provide for .NET, 7.1.1
Oracle ODBC driver, 7.1.1
Oracle OLE DB driver, 7.1.1
Oracle Pro*C/C++, 7.1.1
Oracle support, 6.2.3
parsing an XML stream with Java, 7.7.3
PL/SQL and SQL, 7.1.1
Private Use Area, 12.5.3
programming, 7.1
reading an XML file with Java, 7.7.2
string literals, 7.2.7
UCS-2 encoding, 6.2.2.3
UTF-16 encoding, 6.2.2.2
UTF-8 encoding, 6.2.2.1
writing an XML file with Java, 7.7.1
XML programming, 7.7
Unicode database, 6.3.1
case study, 6.4
Unicode datatypes, 6.3.2
case study, 6.4
UNISTR SQL function, 7.2.7
upgrade
Daylight Saving Time, 4.5.4
url-rewrite-rule, 8.8.7
US7ASCII
supersets, A.4.7
user-defined characters, 12.5.1
adding to a character set definition, 12.5.6
cross-references between character sets, 12.5.4
UTC, 4.2.1.3, 4.2.1.4
UTF-16 encoding, 6.2.2.2, B.2
UTF8 character set, 6.3.1, A.4.5
UTF-8 encoding, 6.2.2.1, B.3
UTFE character set, 6.2.3, A.4.5
UTL_FILE package, using with NCHAR, 7.2.9
UTL_I18N PL/SQL package, 8.10
UTL_LMS PL/SQL package, 8.10
UVARCHAR datatype
Pro*C/C++, 7.4.4

V

V$NLS_PARAMETERS dynamic performance view, 3.4.2
V$NLS_VALID_VALUES dynamic performance view, 3.4.2
VARCHAR datatype
Pro*C/C++, 7.4.2
variable-width multibyte encoding schemes, 2.1.4.2

W

wave dash, 7.5.7.1
WHERE clause
string comparisons, 9.2.5.2

X

XML
parsing in Unicode with Java, 7.7.3
reading in Unicode with Java, 7.7.2
writing in Unicode with Java, 7.7.1
XML programming
Unicode, 7.7