Skip Headers

Oracle® Database Globalization Support Guide
10g Release 1 (10.1)

Part Number B10749-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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-3
$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat time zone file, 4-20
$ORACLE_HOME/oracore/zoneinfo/timezone.dat time zone file, 4-20

Numerics

7-bit encoding schemes, 2-9
8-bit encoding schemes, 2-9

A

abbreviations
languages, A-2
abstract datatype
creating as NCHAR, 2-20
accent, 5-14
accent-insensitive linguistic sort, 5-11
ADCS script
migrating character sets in Real Application Clusters, 11-10
ADD_MONTHS SQL function, 4-16
ADO interface and Unicode, 7-41
AL16UTF16 character set, 6-6, A-19
AL24UTFFSS character set, 6-6
AL32UTF8 character set, 6-6, 6-7, A-19
ALTER DATABASE CHARACTER SET statement, 11-10
ALTER DATABASE NATIONAL CHARACTER SET statement, 11-10, 11-12
ALTER SESSION statement
SET NLS_CURRENCY clause, 3-35, 3-37
SET NLS_LANGUAGE clause, 3-18
SET NLS_NUMERIC_CHARACTERS clause, 3-33
SET NLS_TERRITORY clause, 3-18
ALTER TABLE MODIFY statement
migrating from CHAR to NCHAR, 11-12, 11-13
analyse_histgrm.sql script, 12-37
analyse_rule.sql script, 12-37
analyse_source.sql script, 12-37
application-locales, 8-38
Arial Unicode MS font, 13-2
array parameter
Database Character Set Scanner, 12-12
ASCII encoding, 2-6
AT LOCAL clause, 4-25
AT TIME ZONE clause, 4-25

B

base letter, 5-7
base letters, 5-5
BFILE data
loading into LOBs, 9-14
binary sort, 5-2
example, 5-17
binary sorts
case-insensitive and accent-insensitive, 5-16
binding and defining CLOB and NCLOB data in OCI, 7-21
binding and defining SQL CHAR datatypes in OCI, 7-19
binding and defining SQL NCHAR datatypes in OCI, 7-20
BLANK_TRIMMING parameter, 11-4
BLOBs
creating indexes, 6-23
boundaries parameter
Database Character Set Scanner, 12-13
byte semantics, 2-12, 3-44

C

C number format mask, 3-36
Calendar Utility, 13-17
calendars
customizing, 13-17
parameter, 3-27
supported, A-28
canonical equivalence, 5-4, 5-9
capture parameter
Database Character Set Scanner, 12-13
case, 5-2
case-insensitive linguistic sort, 5-11
CESU-8 compliance, A-19
changing the national character set, 11-12
CHAR columns
migrating to NCHAR columns, 11-12
character data
converting with CONVERT SQL function, 9-6
character data conversion
database character set, 11-8
character data scanning
before character set migration, 11-7
character rearrangement, 5-10
character repertoire, 2-3
character semantics, 2-12, 3-44
character set
changing after database creation, 2-20
conversion, 2-17, 13-24
customizing, 13-22
data loss during conversion, 2-17
detecting with Globalization Development Kit, 8-32
encoding, 2-2
national, 2-19, 6-9, 7-6
character set conversion
between OCI client and database server, 7-15
parameters, 3-43
character set definition
customizing, 13-26
guidelines for editing files, 13-25
naming files, 13-25
character set migration
CSALTER script, 11-8
identifying character data conversion problems, 11-7
postmigration tasks, 11-16
scanning character data, 11-7
character sets
AL16UTF16, 6-6
AL24UTFFSS, 6-6
AL32UTF8, 6-6
Asian, A-8
choosing, 11-2
choosing a character set for a Unicode database, 6-12
choosing a national character set, 6-14
conversion, 2-21, 9-6
conversion using OCI, 10-7
data loss, 11-4
European, A-10
ISO 8859 series, 2-7
Middle Eastern, A-16
migrating and the data dictionary, 12-36
migration, 11-2
naming, 2-11
restrictions on character sets used to express names, 2-18
supersets and subsets, A-20
supported, A-7
supporting different character repertoires, 2-5
universal, A-19
UTFE, 6-6
character type conversion
error reporting, 3-44
characters
available in all Oracle database character sets, 2-5
context-sensitive, 5-8
contracting, 5-8
user-defined, 13-23
choosing a character set, 11-2
choosing between a Unicode database and Unicode datatypes, 6-10
client operating system
character set compatibility with applications, 2-16
CLOB and NCLOB data
binding and defining in OCI, 7-21
CLOBs
creating indexes, 6-22
code chart
displaying and printing, 13-18
code point, 2-2
collation
customizing, 13-32
compatibility
client operating system and application character sets, 2-16
composed characters, 5-8
context-sensitive characters, 5-8
contracting characters, 5-8
contracting letters, 5-10
control characters, encoding, 2-4
conversion
between character set ID number and character set name, 9-8
CONVERT SQL function, 9-6
character sets, A-19
convert time zones, 4-25
convertible data
data dictionary, 12-36
converting character data
CONVERT SQL function, 9-6
converting character data between character sets, 9-6
Coordinated Universal Time, 4-5, 4-7
creating a database with Unicode datatypes, 6-8
creating a Unicode database, 6-8
CSALTER script, 11-8, 11-10
checking phase, 12-42
running, 12-41
updating phase, 12-43
CSM$COLUMNS table, 12-39
CSM$ERRORS table, 12-39
CSM$TABLES table, 12-39
CSMIG user, 12-9
csminst.sql script
running, 12-9
CSMV$COLUMNS view, 12-44
CSMV$CONSTRAINTS view, 12-45
CSMV$ERROR view, 12-46
CSMV$INDEXES view, 12-46
CSMV$TABLES view, 12-47
currencies
formats, 3-34
CURRENT_DATE SQL function, 4-17
CURRENT_TIMESTAMP SQL function, 4-17
customizing time zone data, 13-17

D

data conversion
in Pro*C/C++, 7-22
OCI driver, 7-29
ODBC and OLE DB drivers, 7-38
thin driver, 7-30
Unicode Java strings, 7-29
data dictionary
changing character sets, 12-36
convertible or lossy data, 12-36
data dictionary views
NLS_DATABASE_PARAMETERS, 3-11
NLS_INSTANCE_PARAMETERS, 3-11
NLS_SESSION_PARAMETER, 3-11
data expansion
during data conversion, 7-17
data expansion during character set migration, 11-2
data expansion during conversion
JDBC thin driver, 7-35
data inconsistencies causing data loss, 11-6
data loss
caused by data inconsistencies, 11-6
during character set migration, 11-4
during OCI Unicode character set conversion, 7-15
from mixed character sets, 11-7
data loss during character set conversion, 2-17
data loss during datatype conversion
exceptions, 7-7
data truncation, 11-2
restrictions, 11-3
database character set
character data conversion, 11-8
choosing, 2-14
compatibility between client operating system and applications, 2-16
performance, 2-17
Database Character Set Scanner, 12-14
analyse_histgrm.sql script, 12-37
analyse_rule.sql script, 12-37
analyse_source.sql script, 12-37
array parameter, 12-12
boundaries parameter, 12-13
capture parameter, 12-13
CSM$COLUMNS table, 12-39
CSM$ERRORS table, 12-39
CSM$TABLES table, 12-39
CSMV$COLUMNS view, 12-44
CSMV$CONSTRAINTS view, 12-45
CSMV$ERROR view, 12-46
CSMV$INDEXES view, 12-46
CSMV$TABLES view, 12-47
Database Scan Summary Report, 12-25
error messages, 12-47
exclude parameter, 12-13
feedback parameter, 12-14
fromnchar parameter, 12-15
full parameter, 12-15
help parameter, 12-15
Individual Exception Report, 12-33
invoking, 12-9
lastrpt parameter, 12-16, 12-18
maxblocks parameter, 12-18
online help, 12-10
performance, 12-39
preserve parameter, 12-19
restrictions, 12-40
scan modes, 12-7
suppress parameter, 12-20
table parameter, 12-20
tochar parameter, 12-20
user parameter, 12-21
userid parameter, 12-21
views, 12-44
Database Character Set Scanner utility, 12-6
Database Scan Summary Report, 12-25
database schemas
designing for multiple languages, 6-17
database time zone, 4-23
datatype conversion
data loss and exceptions, 7-7
implicit, 7-8
SQL functions, 7-9
datatypes
abstract, 2-19
DATE, 4-3
datetime, 4-2
inserting values into datetime datatypes, 4-8
inserting values into interval datatypes, 4-14
interval, 4-2, 4-12
INTERVAL DAY TO SECOND, 4-13
INTERVAL YEAR TO MONTH, 4-13
supported, 2-19
TIMESTAMP, 4-5
TIMESTAMP WITH LOCAL TIME ZONE, 4-7
TIMESTAMP WITH TIME ZONE, 4-5
date and time parameters, 3-20
DATE datatype, 4-3
date formats, 3-20, 3-21, 9-13
and partition bound expressions, 3-22
dates
ISO standard, 3-28, 9-13
NLS_DATE_LANGUAGE parameter, 3-23
datetime datatypes, 4-2
inserting values, 4-8
datetime format parameters, 4-18
Daylight Saving Time
Oracle support, 4-26
daylight saving time session parameter, 4-20
days
format element, 3-24
language of names, 3-23
DB_TZ database time zone, 4-24
DBMS_LOB PL/SQL package, 9-14
DBMS_LOB.LOADBLOBFROMFILE procedure, 9-15
DBMS_LOB.LOADCLOBFROMFILE procedure, 9-15
DBMS_REDEFINITION.CAN_REDEF_TABLE procedure, 11-14
DBTIMEZONE SQL function, 4-17
dest_char_set parameter, A-19
detecting language and character sets
Globalization Development Kit, 8-32
detection
supported languages and character sets, A-23
diacritic, 5-2
dynamic performance views
V$NLS_PARAMETERS, 3-12
V$NLS_VALID_VALUES, 3-12

E

encoding
control characters, 2-4
ideographic writing systems, 2-4
numbers, 2-4
phonetic writing systems, 2-4
punctuation, 2-4
symbols, 2-4
encoding schemes
7-bit, 2-9
8-bit, 2-9
fixed-width, 2-10
multibyte, 2-10
shift-sensitive variable-width, 2-10
shift-sensitive variable-width multibyte, 2-10
single-byte, 2-9
variable-width, 2-10
environment variables
ORA_SDTZ, 4-19, 4-24
ORA_TZFILE, 4-19
error messages
languages, A-4
translation, A-4
ERROR_ON_OVERLAP_TIME session parameter, 4-20
euro
Oracle support, 3-39
exclude parameter
Database Character Set Scanner, 12-13
expanding characters, 5-10
characters
expanding, 5-8
EXTRACT (datetime) SQL function, 4-17

F

feedback parameter
Database Character Set Scanner, 12-14
fixed-width multibyte encoding schemes, 2-10
fonts
Unicode, 13-2
Unicode for UNIX, 13-3
Unicode for Windows, 13-2
format elements, 9-14
C, 9-14
D, 9-14
day, 3-24
G, 9-14
IW, 9-14
IY, 9-14
L, 9-14
month, 3-24
RM, 9-13
RN, 9-14
format masks, 3-32, 9-13
formats
currency, 3-34
date, 3-21, 4-19
numeric, 3-31
time, 3-24
FROM_TZ SQL function, 4-17
fromchar parameter, 12-14
Database Character Set Scanner, 12-14
fromnchar parameter
Database Character Set Scanner, 12-15
full parameter
Database Character Set Scanner, 12-15

G

GDK
application configuration file, 8-15
GDK application configuration file, 8-36
example, 8-43
GDK application framework for J2EE, 8-12
GDK components, 8-10
GDK error messages, 8-47
GDK Java API, 8-26
GDK Java supplied packages and classes, 8-44
GDK Localizer object, 8-19
gdkapp.xml application configuration file, 8-36
gdkapp.xml GDK application configuration file, 8-15
GENERIC_BASELETTER linguistic sort, 5-12
getString() method, 7-31
getStringWithReplacement() method, 7-32
Globalization Develoopment Kit
Java API, 8-26
Globalization Development Kit, 8-2
application configuration file, 8-36
character set conversion, 8-29
components, 8-10
defining supported application locales, 8-20
e-mail programs, 8-35
error messages, 8-47
framework, 8-12
integrating locale sources, 8-16
Java supplied packages and classes, 8-44
locale detection, 8-17
Localizer object, 8-19
managing localized content in static files, 8-25
managing strings in JSPs and Java servlets, 8-24
non_ASCII input and output in an HTML page, 8-21
Oracle binary and linguistic sorts, 8-31
Oracle date, number, and monetary formats, 8-30
Oracle language and character set detection, 8-32
Oracle locale information, 8-27
Oracle locale mapping, 8-28
Oracle translated locale and time zone names, 8-34
supported locale resources, 8-16
globalization features, 1-5
globalization support
architecture, 1-2
Greenwich Mean Time, 4-5, 4-7
guessing the language or character set, 12-2

H

help parameter
Database Character Set Scanner, 12-15

I

IANA character sets
mapping with ISO locales, 8-23
ideographic writing systems, encoding, 2-4
ignorable characters, 5-7
implicit datatype conversion, 7-8
indexes
creating for documents stored as CLOBs, 6-22
creating for multilingual document search, 6-21
creating indexes for documents stored as BLOBs, 6-23
partitioned, 9-12
Individual Exception Report, 12-33
initialization parameters
NLS_DATE_FORMAT, 4-19
NLS_TIMESTAMP_FORMAT, 4-19
NLS_TIMESTAMP_TZ_FORMAT, 4-19
INSTR SQL function, 7-11
INSTR SQL functions, 9-6, 9-7
Internet application
locale determination, 8-8
monolingual, 8-2, 8-3
multilingual, 8-3, 8-5
interval datatypes, 4-2, 4-12
inserting values, 4-14
INTERVAL DAY TO SECOND datatype, 4-13
INTERVAL YEAR TO MONTH datatype, 4-13
ISO 8859 character sets, 2-7
ISO locales
mapping with IANA character sets, 8-23
ISO standard
date format, 9-13
ISO standard date format, 3-28, 9-13
ISO week number, 9-13
IW format element, 9-14
IY format element, 9-14

J

Java
Unicode data conversion, 7-29
Java strings
binding and defining in Unicode, 7-26
JDBC drivers
form of use argument, 7-28
JDBC OCI driver
and Unicode, 7-4
JDBC programming
Unicode, 7-25
JDBC Server Side internal driver
and Unicode, 7-4
JDBC Server Side thin driver
and Unicode, 7-4
JDBC thin driver
and Unicode, 7-4
data expansion during conversion, 7-35
SQL CHAR data size restriction, 7-34

L

language
detecting with Globalization Development Kit, 8-32
language abbreviations, A-2
Language and Character Set File Scanner, 12-2
language definition
customizing, 13-8
overriding, 3-8
language support, 1-6
languages
error messages, A-4
languages and character sets
supported by LCSSCAN, A-23
LAST_DAY SQL function, 4-16
lastrpt parameter
Database Character Set Scanner, 12-16, 12-18
LCSCCAN
error messages, 12-5
LCSSCAN, 12-2
supported languages and character sets, 12-5, A-23
LCSSCAN command
BEGIN parameter, 12-3
END parameter, 12-3
examples, 12-4
FILE parameter, 12-3
HELP parameter, 12-4
online help, 12-4
RESULTS parameter, 12-3
syntax, 12-2
length semantics, 2-12, 3-44
LENGTH SQL functions, 9-6, 9-7
LIKE conditions in SQL statements, 9-8
LIKE2 SQL condition, 9-8
LIKE4 SQL condition, 9-8
LIKEC SQL condition, 9-8
linguistic sort
accent-insensitive, 5-11
BINARY, 5-16
BINARY_AI, linguistic sort
BINARY_CI, 5-16
case-insensitive, 5-11
list of defaults, A-2
linguistic sort definitions
supported, A-25
linguistic sorts
controlling, 9-12
customizing, 13-32
characters with diacritics, 13-35, 13-38
GENERIC_BASELETTER, 5-12
levels, 5-5
parameters, 3-41
list parameter, 3-31
lmsgen utility, 10-8
loading external BFILE data into LOBs, 9-14
LOBs
loading external BFILE data, 9-14
storing documents in multiple languages, 6-20
locale, 3-5
locale dependencies, 3-9
locale detection
Globalization Development Kit, 8-17
locale information
mapping between Oracle and other standards, 10-4
locale of Internet application
determining, 8-8
locale variant, 3-9
locale-charset-map, 8-37
locale-determine-rule, 8-39
LocaleMapper class, 8-35
locale-parameter-name, 8-40
LOCALTIMESTAMP SQL function, 4-17
lossy data
data dictionary, 12-36
lxegen utility, 13-18

M

maxblocks parameter
Database Character Set Scanner, 12-18
message-bundles, 8-41
migrating a character set
CSALTER script, 11-8
migrating character sets in Real Application Clusters, 11-10
migration
CHAR columns to NCHAR columns, 11-12
character sets, 11-2
to NCHAR datatypes, 11-10
version 8 NCHAR columns to Oracle9i and later, 11-11
mixed character sets
causing data loss, 11-7
monetary parameters, 3-33
monolingual Internet application, 8-3
monolingual linguistic sort
example, 5-18
monolingual linguistic sorts
supported, A-25
months
format element, 3-24
language of names, 3-23
MONTHS_BETWEEN SQL function, 4-16
multibyte encoding schemes, 2-10
fixed-width, 2-10
shift-sensitive variable-width, 2-10
variable-width, 2-10
multilexers
creating, 6-21
multilingual data
specifying column lengths, 6-18
multilingual document search
creating indexes, 6-21
multilingual Internet application, 8-5
multilingual linguistic sort
example, 5-18
multilingual linguistic sorts
supported, A-27
multilingual support
restricted, 2-24
unrestricted, 2-25
multiple languages
designing database schemas, 6-17
storing data, 6-18
storing documents in LOBs, 6-20

N

N SQL function, 7-10
national character set, 2-19, 6-9, 7-6
before Oracle9i, 6-9
NCHAR
creating abstract datatype, 2-20
NCHAR columns
migrating from version 8 to Oracle9i and later, 11-11
NCHAR datatype, 7-5
migrating, 11-10
migration, 11-11
NCHR SQL function, 7-12
NCLOB datatype, 7-7
NEW_TIME SQL function, 4-16
NEXT_DAY SQL function, 4-16
NLB data
transportable, 13-42
NLB file, 13-5
NLB files, 13-2
generating and installing, 13-40
NLS Calendar Utility, 13-17
NLS parameters
default values in SQL functions, 9-3
list, 3-3
setting, 3-2
specifying in SQL functions, 9-3
unacceptable in SQL functions, 9-5
NLS Runtime Library, 1-2
NLS_CALENDAR parameter, 3-30
NLS_CHARSET_DECL_LEN SQL function, 9-9
NLS_CHARSET_ID SQL function, 9-9
NLS_CHARSET_NAME SQL function, 9-9
NLS_COMP parameter, 3-42, 9-12
NLS_CREDIT parameter, 3-40
NLS_CURRENCY parameter, 3-34
NLS_DATABASE_PARAMETERS data dictionary view, 3-11
NLS_DATE_FORMAT initialization parameter, 4-19
NLS_DATE_FORMAT parameter, 3-21
NLS_DATE_LANGUAGE parameter, 3-22
NLS_DEBIT parameter, 3-40
NLS_DUAL_CURRENCY parameter, 3-37
NLS_INITCAP SQL function, 5-11, 9-2
NLS_INSTANCE_PARAMETERS data dictionary view, 3-11
NLS_ISO_CURRENCY parameter, 3-35
NLS_LANG parameter, 3-5
choosing a locale, 3-5
client setting, 3-10
examples, 3-7
OCI client applications, 7-18
specifying, 3-7
UNIX client, 3-10
Windows client, 3-10
NLS_LANGUAGE parameter, 3-12
NLS_LENGTH_SEMANTICS parameter, 2-13
NLS_LIST_SEPARATOR parameter, 3-43
NLS_LOWER SQL function, 5-11, 9-2
NLS_MONETARY_CHARACTERS parameter, 3-40
NLS_NCHAR_CONV_EXCP parameter, 3-43
NLS_NUMERIC_CHARACTERS parameter, 3-32
NLS_SESSION_PARAMETERS data dictionary view, 3-11
NLS_SORT parameter, 3-41, 5-21
NLS_TERRITORY parameter, 3-15
NLS_TIMESTAMP_FORMAT initialization parameter, 4-19
NLS_TIMESTAMP_FORMAT parameter
parameters
NLS_TIMESTAMP_FORMAT, 3-25, 3-26
NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 4-19
NLS_UPPER SQL function, 5-11, 5-12, 9-2
NLSRTL, 1-2
NLSSORT SQL function, 9-2, 9-9
syntax, 9-11
NLT files, 13-2
numbers, encoding, 2-4
numeric formats, 3-31
SQL masks, 9-14
numeric parameters, 3-31
NUMTODSINTERVAL SQL function, 4-17
NUMTOYMINTERVAL SQL function, 4-17
NVARCHAR datatype
Pro*C/C++, 7-24
NVARCHAR2 datatype, 7-6

O

obsolete locale data, A-38
OCI
binding and defining CLOB and NCLOB data in OCI, 7-21
binding and defining SQL NCHAR datatypes, 7-20
setting the character set, 10-2
SQL CHAR datatypes, 7-19
OCI and Unicode, 7-3
OCI character set conversion, 7-16
data loss, 7-15
performance, 7-16
OCI client applications
using Unicode character sets, 7-18
OCI data conversion
data expansion, 7-17
OCI_ATTR_CHARSET_FORM attribute, 7-15
OCI_ATTR_MAXDATA_SIZE attribute, 7-17
OCI_UTF16ID character set ID, 7-14
OCIBind() function, 7-19
OCICharSetConversionIsReplacementUsed(), 10-8
OCICharSetConvert(), 10-8
OCICharsetToUnicode(), 10-7
OCIDefine() function, 7-19
OCIEnvNlsCreate(), 7-14, 10-2
OCILobRead() function, 7-21
OCILobWrite() function, 7-21
OCIMessageClose(), 10-8
OCIMessageGet(), 10-8
OCIMessageOpen(), 10-8
OCIMultiByteInSizeToWideChar(), 10-5
OCIMultiByteStrCaseConversion(), 10-6
OCIMultiByteStrcat(), 10-6
OCIMultiByteStrcmp(), 10-6
OCIMultiByteStrcpy(), 10-6
OCIMultiByteStrlen(), 10-6
OCIMultiByteStrncat(), 10-6
OCIMultiByteStrncmp(), 10-6
OCIMultiByteStrncpy(), 10-6
OCIMultiByteStrnDisplayLength(), 10-6
OCIMultiByteToWideChar(), 10-5
OCINlsCharSetIdToName(), 10-3
OCINlsCharSetNameTold(), 10-3
OCINlsEnvironmentVariableGet(), 10-3
OCINlsGetInfo(), 10-3
OCINlsNameMap(), 10-4
OCINlsNumericInfoGet(), 10-3
OCIUnicodeToCharset(), 10-7
OCIWideCharDisplayLength(), 10-6
OCIWideCharInSizeToMultiByte(), 10-5
OCIWideCharIsAlnum(), 10-7
OCIWideCharIsAlpha(), 10-7
OCIWideCharIsCntrl(), 10-7
OCIWideCharIsDigit(), 10-7
OCIWideCharIsGraph(), 10-7
OCIWideCharIsLower(), 10-7
OCIWideCharIsPrint(), 10-7
OCIWideCharIsPunct(), 10-7
OCIWideCharIsSingleByte(), 10-7
OCIWideCharIsSpace(), 10-7
OCIWideCharIsUpper(), 10-7
OCIWideCharIsXdigit(), 10-7
OCIWideCharMultibyteLength(), 10-6
OCIWideCharStrCaseConversion(), 10-6
OCIWideCharStrcat(), 10-5
OCIWideCharStrchr(), 10-5
OCIWideCharStrcmp(), 10-5
OCIWideCharStrcpy(), 10-5
OCIWideCharStrlen(), 10-6
OCIWideCharStrncat(), 10-5
OCIWideCharStrncmp(), 10-5
OCIWideCharStrncpy(), 10-6
OCIWideCharStrrchr(), 10-5
OCIWideCharToLower(), 10-5
OCIWideCharToMultiByte(), 10-5
OCIWideCharToUpper(), 10-5
ODBC Unicode applications, 7-40
OLE DB Unicode datatypes, 7-40
online table redefinition
migrating from CHAR to NCHAR, 11-12, 11-13
operating system
character set compatibility with applications, 2-16
ORA_NLS10 environment variable, 1-3
ORA_SDTZ environment variable, 4-19, 4-24
ORA_TZFILE environment variable, 4-19
Oracle Call Interface and Unicode, 7-3
Oracle Data Provide for .NET and Unicode, 7-3
Oracle Language and Character Set Detection Java classes, 8-32
Oracle Locale Builder
choosing a calendar format, 13-12
choosing currency formats, 13-16
choosing date and time formats, 13-13
displaying code chart, 13-18
Existing Definitions dialog box, 13-5
fonts, 13-2, 13-3
Open File dialog box, 13-7
Preview NLT screen, 13-6
restrictions on names for locale objects, 13-9
Session Log dialog box, 13-6
starting, 13-3
Oracle ODBC driver and Unicode, 7-3
Oracle OLE DB driver and Unicode, 7-3
Oracle Pro*C/C++ and Unicode, 7-3
oracle.i18n.lcsd package, 8-45
oracle.i18n.net package, 8-45
oracle.i18n.Servlet package, 8-45
oracle.i18n.text package, 8-45
oracle.i18n.util package, 8-46
oracle.sql.CHAR class
character set conversion, 7-31
getString() method, 7-31
getStringWithReplacement() method, 7-32
toString() method, 7-32
ORDER BY clause, 9-12
OS_TZ local operating system time zone, 4-24
overriding language and territory definitions, 3-8

P

page-charset, 8-38
parameters
BLANK_TRIMMING, 11-4
calendar, 3-27
character set conversion, 3-43
linguistic sorts, 3-41
methods of setting, 3-3
monetary, 3-33
NLS_CALENDAR, 3-30
NLS_COMP, 3-42
NLS_CREDIT, 3-40
NLS_CURRENCY, 3-34
NLS_DATE_FORMAT, 3-21
NLS_DATE_LANGUAGE, 3-22
NLS_DEBIT, 3-40
NLS_DUAL_CURRENCY, 3-37
NLS_ISO_CURRENCY, 3-35
NLS_LANG, 3-5
NLS_LANGUAGE, 3-12
NLS_LIST_SEPARATOR, 3-43
NLS_MONETARY_CHARACTERS, 3-40
NLS_NCHAR_CONV_EXCP, 3-43
NLS_NUMERIC_CHARACTERS, 3-32
NLS_SORT, 3-41
NLS_TERRITORY, 3-15
numeric, 3-31
setting, 3-2
time and date, 3-20
time zone, 3-25, 3-26
partitioned
indexes, 9-12
tables, 9-12
performance
choosing a database character set, 2-17
during OCI Unicode character set conversion, 7-16
phonetic writing systems, encoding, 2-4
PL/SQL and SQL and Unicode, 7-4
preserve parameter
Database Character Set Scanner, 12-19
primary level sort, 5-5
Private Use Area, 13-25
Pro*C/C++
data conversion, 7-22
NVARCHAR datatype, 7-24
UVARCHAR datatype, 7-24
VARCHAR datatype, 7-23
punctuation, encoding, 2-4

R

Real Application Clusters
database character set migration, 11-10
REGEXP SQL functions, 5-22
regular expressions
character class, 5-24
character range, 5-23
collation element delimiter, 5-23
equivalence class, 5-24
examples, 5-24
multilingual environment, 5-22
replacement characters
CONVERT SQL function, 9-6
restricted multilingual support, 2-24
restrictions
data truncation, 11-3
passwords, 11-3
space padding during export, 11-4
usernames, 11-3
reverse secondary sorting, 5-10
ROUND (date) SQL function, 4-17
RPAD SQL function, 7-11

S

scan modes
Database Character Set Scanner, 12-7
full database scan, 12-7
single table scan, 12-8
user tables scan, 12-8
scan.err file, 12-25
scan.out file, 12-22, 12-24, 12-25
scan.txt file, 12-25
searching multilingual documents, 6-21
searching string, 5-22
secondary level sort, 5-5
session parameters
ERROR_ON_OVERLAP, 4-20
session time zone, 4-24
SESSIONTIMEZONE SQL function, 4-17
setFormOfUse() method, 7-28
shift-sensitive variable-width multibyte encoding schemes, 2-10
single-byte encoding schemes, 2-9
sorting
reverse secondary, 5-10
specifying nondefault linguistic sorts, 3-41, 3-43
source_char_set parameter, A-19
space padding
during export, 11-4
special combination letters, 5-8, 5-10
special letters, 5-8, 5-10
special lowercase letters, 5-11
special uppercase letters, 5-11
SQL CHAR datatypes, 2-14
OCI, 7-19
SQL conditions
LIKE2, 9-8
LIKE4, 9-8
LIKEC, 9-8
SQL functions
ADD_MONTH, 4-16
CONVERT, 9-6
CURRENT_DATE, 4-17
CURRENT_TIMESTAMP, 4-17
datatype conversion, 7-9
DBTIMEZONE, 4-17
default values for NLS parameters, 9-3
EXTRACT (datetime), 4-17
FROM_TZ, 4-17
INSTR, 7-11, 9-6, 9-7
LAST_DAY, 4-16
LENGTH, 9-6, 9-7
LOCALTIMESTAMP, 4-17
MONTHS_BETWEEN, 4-16
N, 7-10
NCHR, 7-12
NEW_TIME, 4-16
NEXT_DAY, 4-16
NLS_CHARSET_DECL_LEN, 9-9
NLS_CHARSET_ID, 9-9
NLS_CHARSET_NAME, 9-9
NLS_INITCAP, 5-11, 9-2
NLS_LOWER, 5-11, 9-2
NLS_UPPER, 5-11, 5-12, 9-2
NLSSORT, 9-2, 9-9
NUMTODSINTERVAL, 4-17
NUMTOYMINTERVAL, 4-17
ROUND (date), 4-17
RPAD, 7-11
SESSIONTIMEZONE, 4-17
specifying NLS parameters, 9-3
SUBSTR, 9-6, 9-7
SUBSTR2, 9-7
SUBSTR4, 9-7
SUBSTRB, 9-7
SUBSTRC, 9-7
SYS_EXTRACT_UTC, 4-17
SYSDATE, 4-17
SYSTIMESTAMP, 4-17
TO_CHAR, 9-2
TO_CHAR (datetime), 4-18
TO_DATE, 7-10, 9-2
TO_DSINTERVAL, 4-18
TO_NCHAR, 7-10
TO_NUMBER, 9-2
TO_TIMESTAMP, 4-18
TO_TIMESTAMP_TZ, 4-18
TO_YMINTERVAL, 4-18
TRUNC (date), 4-17
TZ_OFFSET, 4-18
unacceptable NLS parameters, 9-5
UNISTR, 7-12
SQL NCHAR datatypes
binding and defining in OCI, 7-20
SQL statements
LIKE conditions, 9-8
strict superset, 6-3
string comparisons
WHERE clause, 9-11
string literals
Unicode, 7-11
string manipulation using OCI, 10-4
strings
searching, 5-22
SUBSTR SQL function, 9-7
SUBSTR SQL functions, 9-6, 9-7
SUBSTR, 9-7
SUBSTR2, 9-7
SUBSTR4, 9-7
SUBSTRB, 9-7
SUBSTRC, 9-7
SUBSTR4 SQL function, 9-7
SUBSTRB SQL function, 9-7
SUBSTRC SQL function, 9-7
superset, strict, 6-3
supersets and subsets, A-20
supplementary characters, 5-4, 6-3
linguistic sort support, A-28
supported datatypes, 2-19
supported territories, A-6
suppress parameter
Database Character Set Scanner, 12-20
surrogate pairs, 6-3
syllabary, 2-4
symbols, encoding, 2-4
SYS_EXTRACT_UTC SQL function, 4-17
SYSDATE SQL function, 4-17
effect of session time zone, 4-24
SYSTIMESTAMP SQL function, 4-17

T

table parameter
Database Character Set Scanner, 12-20
tables
partitioned, 9-12
territory
dependencies, 3-9
territory definition, 3-15
customizing, 13-11
overriding, 3-8
territory support, 1-7, A-6
territory variant, 3-9
tertiary level sort, 5-6
Thai and Laotian character rearrangement, 5-10
tilde, 7-36
time and date parameters, 3-20
time zone
database, 4-23
effect on SYSDATE SQL function, 4-24
session, 4-24
time zone abbreviations, 4-20
time zone data
source, 4-20
time zone environment variables, 4-19
time zone file
choosing, 4-20
default, 4-20
time zone names, 4-20
time zone parameters, 3-25, 3-26
time zones
converting, 4-25
customizing, 13-17
TIMESTAMP datatype, 4-5
when to use, 4-12
TIMESTAMP datatypes
choosing, 4-12
timestamp format, 3-25
TIMESTAMP WITH LOCAL TIME ZONE datatype, 4-7
when to use, 4-12
TIMESTAMP WITH TIME ZONE datatype, 4-5
when to use, 4-12
timezlrg.dat file, 13-17
timezone.dat file, 13-17
TO_CHAR (datetime) SQL function, 4-18
TO_CHAR SQL function, 9-2
default date format, 3-21, 4-19
format masks, 9-13
group separator, 3-32
language for dates, 3-22
spelling of days and months, 3-23
TO_DATE SQL function, 7-10, 9-2
default date format, 3-21, 4-19
format masks, 9-13
language for dates, 3-22
spelling of days and months, 3-23
TO_DSINTERVAL SQL function, 4-18
TO_NCHAR SQL function, 7-10
TO_NUMBER SQL function, 9-2
format masks, 9-13
TO_TIMESTAMP SQL function, 4-18
TO_TIMESTAMP_TZ SQL function, 4-18
TO_YMINTERVAL SQL function, 4-18
tochar parameter
Database Character Set Scanner, 12-20
toString() method, 7-32
transportable NLB data, 13-42
TRUNC (date) SQL function, 4-17
TZ_OFFSET SQL function, 4-18
TZABBREV, 4-20
TZNAME, 4-20

U

UCS-2 encoding, 6-4
Unicode, 6-2
binding and defining Java strings, 7-26
character code assignments, B-2
character set conversion between OCI client and database server, 7-15
code ranges for UTF-16 characters, B-2
code ranges for UTF-8 characters, B-2
data conversion in Java, 7-29
JDBC OCI driver, 7-4
JDBC programming, 7-25
JDBC Server Side internal driver, 7-4
JDBC Server Side thin driver, 7-4
JDBC thin driver, 7-4
ODBC and OLE DB programming, 7-37
Oracle Call Interface, 7-3
Oracle Data Provide for .NET, 7-3
Oracle ODBC driver, 7-3
Oracle OLE DB driver, 7-3
Oracle Pro*C/C++, 7-3
Oracle support, 6-5
parsing an XML stream with Java, 7-44
PL/SQL and SQL, 7-4
Private Use Area, 13-25
programming, 7-2
reading an XML file with Java, 7-43
string literals, 7-11
UCS-2 encoding, 6-4
UTF-16 encoding, 6-4
UTF-8 encoding, 6-3
writing an XML file with Java, 7-42
XML programming, 7-41
Unicode database, 6-7
case study, 6-15
choosing a character set, 6-12
using with Unicode datatypes (case study), 6-17
when to use, 6-10
Unicode datatypes, 6-8
case study, 6-16
choosing a national character set, 6-14
using with a Unicode database (case study), 6-17
when to use, 6-11
Unicode encoding, 6-3
Unicode fonts, 13-2
Unicode mode, 7-14
UNISTR SQL function, 7-12
unrestricted multilingual support, 2-25
url-rewrite-rule, 8-42
US7ASCII
supersets, A-21
user parameter
Database Character Set Scanner, 12-21
user-defined characters, 13-23
adding to a character set definition, 13-30
cross-references between character sets, 13-25
userid parameter
Database Character Set Scanner, 12-21
UTC, 4-5, 4-7
UTF-16 encoding, 6-4, B-3
UTF8 character set, 6-7, A-19
UTF-8 encoding, 6-3, B-3
UTFE character set, 6-6, 6-8, A-19
UTL_FILE package, using with NCHAR, 7-12
UTL_I18N PL/SQL package, 8-47
UTL_LMS PL/SQL package, 8-47
UVARCHAR datatype
Pro*C/C++, 7-24

V

V$NLS_PARAMETERS dynamic performance view, 3-12
V$NLS_VALID_VALUES dynamic performance view, 3-12
VARCHAR datatype
Pro*C/C++, 7-23
variable-width multibyte encoding schemes, 2-10
version 8 NCHAR columns
migrating to Oracle9i and later, 11-11

W

wave dash, 7-36
WHERE clause
string comparisons, 9-11

X

XML
parsing in Unicode with Java, 7-44
reading in Unicode with Java, 7-43
writing in Unicode with Java, 7-42
XML programming
Unicode, 7-41