Index

A B C D E F G H I J 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/timezlrg.dat time zone file, 4.6

$ORACLE_HOME/oracore/zoneinfo/timezone.dat time zone file, 4.6

Numerics

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 datatype

creating as NCHAR, 2.3.7

accent, 5.5

accent-insensitive linguistic sort, 5.5

ADCS script

migrating character sets in Real Application Clusters, 11.2.2.1

ADD_MONTHS SQL function, 4.4

ADO interface and Unicode, 7.6.6

AL16UTF16 character set, 6.2.3, A.4.4

AL24UTFFSS character set, 6.2.3

AL32UTF8 character set, 6.2.3, 6.3.1, A.4.4

ALTER DATABASE CHARACTER SET statement, 11.2.2

ALTER DATABASE NATIONAL CHARACTER SET statement, 11.2.2

ALTER SESSION statement

SET NLS_CURRENCY clause, 3.8.2, 3.8.3

SET NLS_LANGUAGE clause, 3.4.2.1

SET NLS_NUMERIC_CHARACTERS clause, 3.7.2

SET NLS_TERRITORY clause, 3.4.2.1

ALTER TABLE MODIFY statement

migrating from CHAR to NCHAR, 11.3.3, 11.3.3.1

analyse_histgrm.sql script, 12.8

analyse_rule.sql script, 12.8

analyse_source.sql script, 12.8

application-locales, 8.7.3

Arial Unicode MS font, 13.1.1.1

array parameter

Database Character Set Scanner, 12.5

ASCII encoding, 2.1.3.1

AT LOCAL clause, 4.10

AT TIME ZONE clause, 4.10

B

base letter, 5.4.1

base letters, 5.3.3.1

BFILE data

loading into LOBs, 9.3.4

binary sort, 5.2

example, 5.5.3

binary sorts

case-insensitive and accent-insensitive, 5.5.2

binding and defining CLOB and NCLOB data in OCI, 7.3.6

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

boundaries parameter

Database Character Set Scanner, 12.5

byte semantics, 2.2, 3.11.1

C

C number format mask, 3.8.3

Calendar Utility, 13.3.2

calendars

customizing, 13.3.2

parameter, 3.6

supported, A.7

canonical equivalence, 5.3.2, 5.4.6

capture parameter

Database Character Set Scanner, 12.5

case, 5.1

case-insensitive linguistic sort, 5.5

CESU-8 compliance, A.4.4

CHAR columns

migrating to NCHAR columns, 11.3.3

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.8

character repertoire, 2.1.1

character semantics, 2.2, 3.11.1

character set

changing after database creation, 2.4

conversion, 2.3.3, 13.5.2

customizing, 13.5

data loss during conversion, 2.3.3

detecting with Globalization Development Kit, 8.6.6

encoding, 2.1

national, 2.3.6, 6.3.2, 7.2.1.1, 7.2.1.2

character set conversion

between OCI client and database server, 7.3.2

parameters, 3.10

character set definition

customizing, 13.5.6

guidelines for editing files, 13.5.5

naming files, 13.5.5

character set migration

CSALTER script, 11.2.2

identifying character data conversion problems, 11.2

postmigration tasks, 11.4

scanning character data, 11.2

character sets

AL16UTF16, 6.2.3

AL24UTFFSS, 6.2.3

AL32UTF8, 6.2.3

Asian, A.4.1

choosing, 11.1

choosing a character set for a Unicode database, 6.3.4

choosing a national character set, 6.3.4

conversion, 2.5.1, 9.2.1

conversion using OCI, 10.7

data loss, 11.1.2.1

European, A.4.2

ISO 8859 series, 2.1.3.1

Middle Eastern, A.4.3

migrating and the data dictionary, 12.8

migration, 11.1, 11.1.1

naming, 2.1.5

restrictions on character sets used to express names, 2.3.5.1

supersets and subsets, A.4.6

supported, A.4

supporting different character repertoires, 2.1.3

universal, A.4.4

UTFE, 6.2.3

character type conversion

error reporting, 3.10.1

characters

available in all Oracle database character sets, 2.1.3

context-sensitive, 5.4.5

contracting, 5.4.3

user-defined, 13.5.1

choosing a character set, 11.1

choosing between a Unicode database and Unicode datatypes, 6.3.3

client operating system

character set compatibility with applications, 2.3.2

CLOB and NCLOB data

binding and defining in OCI, 7.3.6

CLOBs

creating indexes, 6.5.4.2

code chart

displaying and printing, 13.4

code point, 2.1.1

collation

customizing, 13.6

compatibility

client operating system and application character sets, 2.3.2

composed characters, 5.4.3

context-sensitive characters, 5.4.5

contracting characters, 5.4.3

contracting letters, 5.4.10

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.5

convert time zones, 4.10

convertible data

data dictionary, 12.8

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

CSALTER script, 11.2.2, 11.2.2.1

checking phase, 12.10.1

running, 12.10

updating phase, 12.10.2

CSM$COLUMNS table, 12.9.1.2

CSM$ERRORS table, 12.9.1.3

CSM$TABLES table, 12.9.1.1

CSMIG user, 12.4.2

csminst.sql script

running, 12.4.2

CSMV$COLUMNS view, 12.11.1

CSMV$CONSTRAINTS view, 12.11.2

CSMV$ERROR view, 12.11.3

CSMV$INDEXES view, 12.11.4

CSMV$TABLES view, 12.11.5

currencies

formats, 3.8.1

CURRENT_DATE SQL function, 4.4

CURRENT_TIMESTAMP SQL function, 4.4

customizing time zone data, 13.3.1

D

data conversion

in Pro*C/C++, 7.4.1

OCI driver, 7.5.4.1

ODBC and OLE DB drivers, 7.6.3

thin driver, 7.5.4.2

Unicode Java strings, 7.5.4

data dictionary

changing character sets, 12.8

convertible or lossy data, 12.8

data dictionary views

NLS_DATABASE_PARAMETERS, 3.3.1

NLS_INSTANCE_PARAMETERS, 3.3.1

NLS_SESSION_PARAMETER, 3.3.1

data expansion

during data conversion, 7.3.2.3

data expansion during character set migration, 11.1.1

data expansion during conversion

JDBC thin driver, 7.5.6.1

data inconsistencies causing data loss, 11.1.2.2

data loss

caused by data inconsistencies, 11.1.2.2

during character set migration, 11.1.2.1

during OCI Unicode character set conversion, 7.3.2.1

from mixed character sets, 11.1.2.2

data loss during character set conversion, 2.3.3

data loss during datatype conversion

exceptions, 7.2.3

data truncation, 11.1.1

restrictions, 11.1.1.1

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 Character Set Scanner, 12.5

analyse_histgrm.sql script, 12.8

analyse_rule.sql script, 12.8

analyse_source.sql script, 12.8

array parameter, 12.5

boundaries parameter, 12.5

capture parameter, 12.5

CSM$COLUMNS table, 12.9.1.2

CSM$ERRORS table, 12.9.1.3

CSM$TABLES table, 12.9.1.1

CSMV$COLUMNS view, 12.11.1

CSMV$CONSTRAINTS view, 12.11.2

CSMV$ERROR view, 12.11.3

CSMV$INDEXES view, 12.11.4

CSMV$TABLES view, 12.11.5

Database Scan Summary Report, 12.7.1

error messages, 12.12

exclude parameter, 12.5

feedback parameter, 12.5

fromnchar parameter, 12.5

full parameter, 12.5

help parameter, 12.5

Individual Exception Report, 12.7.2

invoking, 12.4.3

lastrpt parameter, 12.5, 12.5

maxblocks parameter, 12.5

online help, 12.4.5

performance, 12.9.2

preserve parameter, 12.5

restrictions, 12.9.3

scan modes, 12.3

suppress parameter, 12.5

table parameter, 12.5

tochar parameter, 12.5

user parameter, 12.5

userid parameter, 12.5

views, 12.11

Database Character Set Scanner utility, 12.2

Database Scan Summary Report, 12.7.1

database schemas

designing for multiple languages, 6.5

database time zone, 4.8

datatype conversion

data loss and exceptions, 7.2.3

implicit, 7.2.4

SQL functions, 7.2.5

datatypes

abstract, 2.3.7

DATE, 4.2.1.1

datetime, 4.2

inserting values into datetime datatypes, 4.2.1.5

inserting values into interval datatypes, 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.7

TIMESTAMP, 4.2.1.2

TIMESTAMP WITH LOCAL TIME ZONE, 4.2.1.4

TIMESTAMP WITH TIME ZONE, 4.2.1.3

date and time parameters, 3.5

DATE datatype, 4.2.1.1

date formats, 3.5.1, 3.5.1.1, 9.3.1

and partition bound expressions, 3.5.1.1

dates

ISO standard, 3.6.1.2, 9.3.2

NLS_DATE_LANGUAGE parameter, 3.5.1.2

datetime datatypes, 4.2

inserting values, 4.2.1.5

datetime format parameters, 4.5.1

Daylight Saving Time

Oracle support, 4.11

daylight saving time session parameter, 4.5.3

days

format element, 3.5.1.2

language of names, 3.5.1.2

DB_TZ database time zone, 4.9

DBMS_LOB PL/SQL package, 9.3.4

DBMS_LOB.LOADBLOBFROMFILE procedure, 9.3.4

DBMS_LOB.LOADCLOBFROMFILE procedure, 9.3.4

DBMS_REDEFINITION.CAN_REDEF_TABLE procedure, 11.3.3.2

DBTIMEZONE SQL function, 4.4

dest_char_set parameter, A.4.5

detecting language and character sets

Globalization Development Kit, 8.6.6

detection

supported languages and character sets, A.5

diacritic, 5.1

dynamic performance views

V$NLS_PARAMETERS, 3.3.2

V$NLS_VALID_VALUES, 3.3.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.9

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.8.5

exclude parameter

Database Character Set Scanner, 12.5

expanding characters, 5.4.9

characters

expanding, 5.4.4

EXTRACT (datetime) SQL function, 4.4

F

feedback parameter

Database Character Set Scanner, 12.5

fixed-width multibyte encoding schemes, 2.1.4.2

fonts

Unicode, 13.1.1

Unicode for UNIX, 13.1.1.2

Unicode for Windows, 13.1.1.1

format elements, 9.3.3

C, 9.3.3

D, 9.3.3

day, 3.5.1.2

G, 9.3.3

IW, 9.3.2

IY, 9.3.2

L, 9.3.3

month, 3.5.1.2

RM, 9.3.1

RN, 9.3.3

format masks, 3.7.2, 9.3.1

formats

currency, 3.8.1

date, 3.5.1.1, 4.5.1

numeric, 3.7.1

time, 3.5.2

FROM_TZ SQL function, 4.4

fromchar parameter, 12.5

Database Character Set Scanner, 12.5

fromnchar parameter

Database Character Set Scanner, 12.5

full parameter

Database Character Set Scanner, 12.5

G

GDK

application configuration file, 8.5.1

GDK application configuration file, 8.7

example, 8.7.8

GDK application framework for J2EE, 8.5, 8.5

GDK components, 8.4

GDK error messages, 8.10

GDK Java API, 8.6

GDK Java supplied packages and classes, 8.8

GDK Localizer object, 8.5.4

gdkapp.xml application configuration file, 8.7

gdkapp.xml GDK application configuration file, 8.5.1

GENERIC_BASELETTER linguistic sort, 5.5

getString() method, 7.5.5.1

getStringWithReplacement() method, 7.5.5.1

Globalization Development Kit, 8.1

application configuration file, 8.7

character set conversion, 8.6.3

components, 8.4

defining supported application locales, 8.5.5

e-mail programs, 8.6.8

error messages, 8.10

framework, 8.5

integrating locale sources, 8.5.2

Java API, 8.6

Java supplied packages and classes, 8.8

locale detection, 8.5.3

Localizer object, 8.5.4

managing localized content in static files, 8.5.7.2

managing strings in JSPs and Java servlets, 8.5.7.1

non_ASCII input and output in an HTML page, 8.5.6

Oracle binary and linguistic sorts, 8.6.5

Oracle date, number, and monetary formats, 8.6.4

Oracle language and character set detection, 8.6.6

Oracle locale information, 8.6.1

Oracle locale mapping, 8.6.2

Oracle translated locale and time zone names, 8.6.7

supported locale resources, 8.5.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, 12.1

H

help parameter

Database Character Set Scanner, 12.5

I

IANA character sets

mapping with ISO locales, 8.5.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

partitioned, 9.2.5.3

Individual Exception Report, 12.7.2

initialization parameters

NLS_DATE_FORMAT, 4.5.1

NLS_TIMESTAMP_FORMAT, 4.5.1

NLS_TIMESTAMP_TZ_FORMAT, 4.5.1

INSTR SQL function, 7.2.6

INSTR SQL functions, 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 datatypes, 4.2, 4.2.2

inserting values, 4.2.2.3

INTERVAL DAY TO SECOND datatype, 4.2.2.2

INTERVAL YEAR TO MONTH datatype, 4.2.2.1

ISO 8859 character sets, 2.1.3.1

ISO locales

mapping with IANA character sets, 8.5.6

ISO standard

date format, 9.3.2

ISO standard date format, 3.6.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.4

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

data expansion during conversion, 7.5.6.1

SQL CHAR data size restriction, 7.5.6.1

L

language

detecting with Globalization Development Kit, 8.6.6

language abbreviations, A.1

Language and Character Set File Scanner, 12.1

language definition

customizing, 13.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

lastrpt parameter

Database Character Set Scanner, 12.5, 12.5

LCSCCAN

error messages, 12.1.5

LCSSCAN, 12.1

supported languages and character sets, 12.1.4, A.5

LCSSCAN command

BEGIN parameter, 12.1.1

END parameter, 12.1.1

examples, 12.1.2

FILE parameter, 12.1.1

HELP parameter, 12.1.3

online help, 12.1.3

RESULTS parameter, 12.1.1

syntax, 12.1.1

length semantics, 2.2, 3.11

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 sort

accent-insensitive, 5.5

BINARY, 5.5.2

BINARY_AI, linguistic sort

BINARY_CI, 5.5.2

case-insensitive, 5.5

list of defaults, A.1

linguistic sort definitions

supported, A.6

linguistic sorts

controlling, 9.2.5.4

customizing, 13.6

characters with diacritics, 13.6.1, 13.6.2

GENERIC_BASELETTER, 5.5

levels, 5.3.3.1

parameters, 3.9

list parameter, 3.7

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

locale dependencies, 3.2.3

locale detection

Globalization Development Kit, 8.5.3

locale information

mapping between Oracle and other standards, 10.4

locale of Internet application

determining, 8.3.1

locale variant, 3.2.3

locale-charset-map, 8.7.1

locale-determine-rule, 8.7.4

LocaleMapper class, 8.6.8

locale-parameter-name, 8.7.5

LOCALTIMESTAMP SQL function, 4.4

lossy data

data dictionary, 12.8

lxegen utility, 13.3.2

M

maxblocks parameter

Database Character Set Scanner, 12.5

message-bundles, 8.7.6

migrating a character set

CSALTER script, 11.2.2

migrating character sets in Real Application Clusters, 11.2.2.1

migration

CHAR columns to NCHAR columns, 11.3.3

character sets, 11.1

to NCHAR datatypes, 11.3

version 8 NCHAR columns to Oracle9i and later, 11.3.1

mixed character sets

causing data loss, 11.1.2.2

monetary parameters, 3.8

monolingual Internet application, 8.2.1

monolingual linguistic sort

example, 5.5.3

monolingual linguistic sorts

supported, A.6

months

format element, 3.5.1.2

language of names, 3.5.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 sort

example, 5.5.3

multilingual linguistic sorts

supported, A.6

multilingual support

restricted, 2.6.1

unrestricted, 2.6.2

multiple languages

designing database schemas, 6.5

storing data, 6.5.2

storing documents in LOBs, 6.5.3

N

N SQL function, 7.2.5

national character set, 2.3.6, 6.3.2, 7.2.1.1, 7.2.1.2

before Oracle9i, 6.3.2

NCHAR

creating abstract datatype, 2.3.7

NCHAR columns

migrating from version 8 to Oracle9i and later, 11.3.1

NCHAR datatype, 7.2.1.1

migrating, 11.3

migration, 11.3.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, 13.8

NLB file, 13.1.3.1

NLB files, 13.1

generating and installing, 13.7

NLS Calendar Utility, 13.3.2

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.6.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.9.2, 9.2.5.3

NLS_CREDIT parameter, 3.8.7

NLS_CURRENCY parameter, 3.8.2

NLS_DATABASE_PARAMETERS data dictionary view, 3.3.1

NLS_DATE_FORMAT initialization parameter, 4.5.1

NLS_DATE_FORMAT parameter, 3.5.1.1

NLS_DATE_LANGUAGE parameter, 3.5.1.2

NLS_DEBIT parameter, 3.8.8

NLS_DUAL_CURRENCY parameter, 3.8.4

NLS_INITCAP SQL function, 5.4.11, 9.1

NLS_INSTANCE_PARAMETERS data dictionary view, 3.3.1

NLS_ISO_CURRENCY parameter, 3.8.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.4.1

NLS_LENGTH_SEMANTICS parameter, 2.2

NLS_LIST_SEPARATOR parameter, 3.10

NLS_LOWER SQL function, 5.4.11, 5.5, 9.1

NLS_MONETARY_CHARACTERS parameter, 3.8.6

NLS_NCHAR_CONV_EXCP parameter, 3.10.1

NLS_NUMERIC_CHARACTERS parameter, 3.7.2

NLS_SESSION_PARAMETERS data dictionary view, 3.3.1

NLS_SORT parameter, 3.9.1, 5.6.2.1

NLS_TERRITORY parameter, 3.4.2

NLS_TIMESTAMP_FORMAT initialization parameter, 4.5.1

NLS_TIMESTAMP_FORMAT parameter

parameters

NLS_TIMESTAMP_FORMAT, 3.5.2.1, 3.5.2.2

NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 4.5.1

NLS_UPPER SQL function, 5.4.11, 5.5, 9.1

NLSRTL, 1.1.1

NLSSORT SQL function, 9.1, 9.2.5

syntax, 9.2.5.1

NLT files, 13.1

numbers, encoding, 2.1.2.3

numeric formats, 3.7.1

SQL masks, 9.3.3

numeric parameters, 3.7

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.5

OCI

binding and defining CLOB and NCLOB data in OCI, 7.3.6

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.6

OCILobWrite() function, 7.3.6

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

online table redefinition

migrating from CHAR to NCHAR, 11.3.3, 11.3.3.2

operating system

character set compatibility with applications, 2.3.2

ORA_NLS10 environment variable, 1.1.1

ORA_SDTZ environment variable, 4.5.2, 4.9

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 Language and Character Set Detection Java classes, 8.6.6

Oracle Locale Builder

choosing a calendar format, 13.3

choosing currency formats, 13.3

choosing date and time formats, 13.3

displaying code chart, 13.4

Existing Definitions dialog box, 13.1.3.1

fonts, 13.1.1.1, 13.1.1.2

Open File dialog box, 13.1.3.4

Preview NLT screen, 13.1.3.3

restrictions on names for locale objects, 13.2

Session Log dialog box, 13.1.3.2

starting, 13.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.8.1

oracle.i18n.net package, 8.8.2

oracle.i18n.Servlet package, 8.8.3

oracle.i18n.text package, 8.8.4

oracle.i18n.util package, 8.8.5

oracle.sql.CHAR class

character set conversion, 7.5.5.1

getString() method, 7.5.5.1

getStringWithReplacement() method, 7.5.5.1

toString() method, 7.5.5.1

ORDER BY clause, 9.2.5.4

OS_TZ local operating system time zone, 4.9

overriding language and territory definitions, 3.2.2

P

page-charset, 8.7.2

parameters

BLANK_TRIMMING, 11.1.1.1

calendar, 3.6

character set conversion, 3.10

linguistic sorts, 3.9

methods of setting, 3.1

monetary, 3.8

NLS_CALENDAR, 3.6.2

NLS_COMP, 3.9.2

NLS_CREDIT, 3.8.7

NLS_CURRENCY, 3.8.2

NLS_DATE_FORMAT, 3.5.1.1

NLS_DATE_LANGUAGE, 3.5.1.2

NLS_DEBIT, 3.8.8

NLS_DUAL_CURRENCY, 3.8.4

NLS_ISO_CURRENCY, 3.8.3

NLS_LANG, 3.2

NLS_LANGUAGE, 3.4.1

NLS_LIST_SEPARATOR, 3.10

NLS_MONETARY_CHARACTERS, 3.8.6

NLS_NCHAR_CONV_EXCP, 3.10.1

NLS_NUMERIC_CHARACTERS, 3.7.2

NLS_SORT, 3.9.1

NLS_TERRITORY, 3.4.2

numeric, 3.7

setting, 3.1

time and date, 3.5

time zone, 3.5.2.1, 3.5.2.2

partitioned

indexes, 9.2.5.3

tables, 9.2.5.3

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

preserve parameter

Database Character Set Scanner, 12.5

primary level sort, 5.3.3.1

Private Use Area, 13.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

Real Application Clusters

database character set migration, 11.2.2.1

REGEXP SQL functions, 5.8

regular expressions

character class, 5.8.3

character range, 5.8.1

collation element delimiter, 5.8.2

equivalence class, 5.8.4

examples, 5.8.5

multilingual environment, 5.8

replacement characters

CONVERT SQL function, 9.2.1

restricted multilingual support, 2.6.1, 2.6.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.7

ROUND (date) SQL function, 4.4

RPAD SQL function, 7.2.6

S

scan modes

Database Character Set Scanner, 12.3

full database scan, 12.3.1

single table scan, 12.3.3

user tables scan, 12.3.2

scan.err file, 12.7

scan.out file, 12.6.1.3, 12.6.2.3, 12.6.3.3

scan.txt file, 12.7

searching multilingual documents, 6.5.4

searching string, 5.7

secondary level sort, 5.3.3.2

session parameters

ERROR_ON_OVERLAP, 4.5.3

session time zone, 4.9

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.7

specifying nondefault linguistic sorts, 3.9.1, 3.9.2

source_char_set parameter, A.4.5

space padding

during export, 11.1.1.1

special combination letters, 5.4.3, 5.4.10

special letters, 5.4.4, 5.4.9

special lowercase letters, 5.4.12

special uppercase letters, 5.4.11

SQL CHAR datatypes, 2.3

OCI, 7.3.4

SQL conditions

LIKE2, 9.2.3

LIKE4, 9.2.3

LIKEC, 9.2.3

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.11, 9.1

NLS_LOWER, 5.4.11, 5.5, 9.1

NLS_UPPER, 5.4.11, 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, 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.7

SUBSTR SQL function, 9.2.2

SUBSTR SQL functions, 9.2.2, 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.6

supplementary characters, 5.3.2, 6.2.1

linguistic sort support, A.6

supported datatypes, 2.3.7

supported territories, A.3

suppress parameter

Database Character Set Scanner, 12.5

surrogate pairs, 6.2.1

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.9

sys.sys_tzuv2_temptab table, 4.7

SYSTIMESTAMP SQL function, 4.4

T

table parameter

Database Character Set Scanner, 12.5

tables

partitioned, 9.2.5.3

territory

dependencies, 3.2.3

territory definition, 3.4.2

customizing, 13.3

overriding, 3.2.2

territory support, 1.2.2, A.3

territory variant, 3.2.3

tertiary level sort, 5.3.3.3

Thai and Laotian character rearrangement, 5.4.8

tilde, 7.5.6.2

time and date parameters, 3.5

time zone

database, 4.8

effect on SYSDATE SQL function, 4.9

session, 4.9

time zone abbreviations, 4.6

time zone data

source, 4.6

time zone environment variables, 4.5.2

time zone file

choosing, 4.6

default, 4.6

time zone names, 4.6

time zone parameters, 3.5.2.1, 3.5.2.2

time zones

converting, 4.10

customizing, 13.3.1

upgrading definitions, 4.7

TIMESTAMP datatype, 4.2.1.2

when to use, 4.2.1.6

TIMESTAMP datatypes

choosing, 4.2.1.6

timestamp format, 3.5.2.1

TIMESTAMP WITH LOCAL TIME ZONE datatype, 4.2.1.4

when to use, 4.2.1.6

TIMESTAMP WITH TIME ZONE datatype, 4.2.1.3

when to use, 4.2.1.6

timezlrg.dat file, 13.3.1

timezone.dat file, 13.3.1

TO_CHAR (datetime) SQL function, 4.4

TO_CHAR SQL function, 9.1

default date format, 3.5.1.1, 4.5.1

format masks, 9.3.1

group separator, 3.7.2

language for dates, 3.5.1.2

spelling of days and months, 3.5.1.2

TO_DATE SQL function, 7.2.5, 9.1

default date format, 3.5.1.1, 4.5.1

format masks, 9.3.1

language for dates, 3.5.1.2

spelling of days and months, 3.5.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

tochar parameter

Database Character Set Scanner, 12.5

toString() method, 7.5.5.1

transportable NLB data, 13.8

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.2

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.4

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

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, 13.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.2

UTF-16 encoding, 6.2.2.3

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

choosing a character set, 6.3.4

using with Unicode datatypes (case study), 6.4

when to use, 6.3.3.1

Unicode datatypes, 6.3.2

case study, 6.4

choosing a national character set, 6.3.4

using with a Unicode database (case study), 6.4

when to use, 6.3.3.2

Unicode encoding, 6.2.2

Unicode fonts, 13.1.1

Unicode mode, 7.3.1

UNISTR SQL function, 7.2.7

unrestricted multilingual support, 2.6.2

url-rewrite-rule, 8.7.7

US7ASCII

supersets, A.4.6

user parameter

Database Character Set Scanner, 12.5

user-defined characters, 13.5.1

adding to a character set definition, 13.5.6

cross-references between character sets, 13.5.4

userid parameter

Database Character Set Scanner, 12.5

UTC, 4.2.1.3, 4.2.1.4

UTF-16 encoding, 6.2.2.3, B.2

UTF8 character set, 6.3.1, A.4.4

UTF-8 encoding, 6.2.2.1, B.3

UTFE character set, 6.2.3, 6.3.1, A.4.4

UTL_FILE package, using with NCHAR, 7.2.8

UTL_I18N PL/SQL package, 8.9

UTL_LMS PL/SQL package, 8.9

utltzuv2.sql script, 4.7

UVARCHAR datatype

Pro*C/C++, 7.4.4

V

V$NLS_PARAMETERS dynamic performance view, 3.3.2

V$NLS_VALID_VALUES dynamic performance view, 3.3.2

VARCHAR datatype

Pro*C/C++, 7.4.2

variable-width multibyte encoding schemes, 2.1.4.2

version 8 NCHAR columns

migrating to Oracle9i and later, 11.3.1

W

wave dash, 7.5.6.2

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