Oracle9i Database Globalization Support Guide -- Index

7-bit encoding schemes, 2-9

8-bit encoding schemes, 2-9

abbreviations

languages, A-2

abstract datatype

creating as NCHAR, 2-19

ADO interface and Unicode, 6-34

AL16UTF16 character set, 5-6, A-18

AL24UTFFSS character set, 5-6

AL32UTF8 character set, 5-6, 5-7, A-18

ALTER DATABASE CHARACTER SET statement, 10-10

migrating character sets in Oracle9i Real Application Clusters, 10-10

migrating data, 10-8

using with selective imports, 10-10

ALTER DATABASE NATIONAL CHARACTER SET statement, 10-10, 10-12

ALTER SESSION statement

SET NLS_CURRENCY clause, 3-33, 3-35

SET NLS_DATE_FORMAT clause, 3-19

SET NLS_LANGUAGE clause, 3-16

SET NLS_NUMERIC_CHARACTERS clause, 3-32

SET NLS_TERRITORY clause, 3-16

ALTER TABLE MODIFY statement

migrating from CHAR to NCHAR, 10-12, 10-13

Arial Unicode MS font, 12-2

array parameter

Character Set Scanner, 11-10

ASCII encoding, 2-6

base characters, 4-5

base letter, 4-9

BFILE data

loading into LOBs, 7-15

binary sort, 4-2

example, 4-7

binding and defining CLOB and NCLOB data in OCI, 6-21

binding and defining SQL CHAR datatypes in OCI, 6-18

binding and defining SQL NCHAR datatypes in OCI, 6-20

BLANK_TRIMMING parameter, 10-4

BLOBs

creating indexes, 5-24

boundaries parameter

Character Set Scanner, 11-10

byte semantics, 2-12, 3-43

C number format mask, 3-34

Calendar Utility, 12-17

calendars

customizing, 12-17

parameter, 3-26

supported, A-25

canonical equivalence, 4-4, 4-10

capture parameter

Character Set Scanner, 11-10

case, 4-2

case-insensitive search, 4-16

CESU-8 compliance, A-18

changing the national character set, 10-12

CHAR columns

migrating to NCHAR columns, 10-12

character data

converting with CONVERT SQL function, 7-6

character data conversion

database character set, 10-8

character data scanning

before character set migration, 10-7

character rearrangement, 4-11

character repertoire, 2-3

character semantics, 2-12, 3-43

character set

changing after database creation, 2-20

conversion, 2-16, 12-25

customizing, 12-23

data loss during conversion, 2-16

encoding, 2-2

national, 2-18, 5-9, 6-5, 6-6

character set conversion

between OCI client and database server, 6-15

for Java applications, 9-4

for JDBC thin drivers, 9-7

parameters, 3-42

character set definition

customizing, 12-27

guidelines for editing files, 12-27

naming files, 12-27

character set migration

from single-byte to multibyte, 10-9

identifying character data conversion problems, 10-7

postmigration tasks, 10-16

scanning character data, 10-7

Character Set Scanner, 11-1, 11-12

array parameter, 11-10

boundaries parameter, 11-10

capture parameter, 11-10

CSM$COLUMNS table, 11-30

CSM$ERRORS table, 11-30

CSM$TABLES table, 11-30

CSMV$COLUMNS view, 11-31

CSMV$CONSTRAINTS view, 11-32

CSMV$ERROR view, 11-33

CSMV$INDEXES view, 11-33

CSMV$TABLES view, 11-34

Database Scan Summary Report, 11-20

error messages, 11-34

exclude parameter, 11-11

feedback parameter, 11-11

fromnchar parameter, 11-12

full parameter, 11-12

help parameter, 11-13

Individual Exception Report, 11-27

invoking, 11-6

lastrpt parameter, 11-13

maxblocks parameter, 11-14

online help, 11-7

parameter file, 11-8

parameters, 11-9

performance, 11-31

platform compatibility, 11-6

preserve parameter, 11-14

scan modes, 11-4

suppress parameter, 11-15

table parameter, 11-15

tochar parameter, 11-16

user parameter, 11-16

userid parameter, 11-17

views, 11-31

character sets

AL16UTF16, 5-6

AL24UTFFSS, 5-6

AL32UTF8, 5-6

Asian, A-8

choosing, 10-2

choosing a character set for a Unicode database, 5-12

choosing a national character set, 5-14

conversion, 2-21, 7-6

conversion using OCI, 8-48

data loss, 10-4

European, A-9

ISO 8859 series, 2-7

Middle Eastern, A-15

migration, 10-2

migration from single-byte to multibyte, 10-9

naming, 2-11

restrictions on character sets used to express names, 2-17

supersets and subsets, A-19

supported, A-6

supporting different character repertoires, 2-5

universal, A-18

UTFE, 5-6

character type conversion

error reporting, 3-42

characters

available in all Oracle database character sets, 2-5

context-sensitive, 4-10

contracting, 4-9

user-defined, 12-24

choosing a character set, 10-2

choosing between a Unicode database and Unicode datatypes, 5-10

client operating system

character set compatibility with applications, 2-16

CLOB and NCLOB data

binding and defining in OCI, 6-21

CLOBs

creating indexes, 5-23

code chart

displaying and printing, 12-18

code point, 2-2

collation

customizing, 12-35

compatibility

client operating system and application character sets, 2-16

composed characters, 4-9

concatenation operator, 7-15

context-sensitive characters, 4-10

contracting characters, 4-9

contracting letters, 4-11

control characters, encoding, 2-4

conversion

between character set ID number and character set name, 7-9

CONVERT SQL function, 7-6

character sets, A-18

converting character data

CONVERT SQL function, 7-6

converting character data between character sets, 7-6

cost-based optimizer, 4-15

creating a database with Unicode datatypes, 5-8

creating a Unicode database, 5-8

CSM$COLUMNS table, 11-30

CSM$ERRORS table, 11-30

CSM$TABLES table, 11-30

CSMIG user, 11-5

csminst.sql script

running, 11-6

CSMV$COLUMNS view, 11-31

CSMV$CONSTRAINTS view, 11-32

CSMV$ERROR view, 11-33

CSMV$INDEXES view, 11-33

CSMV$TABLES view, 11-34

currencies

formats, 3-32

customizing time zone data, 12-17

data conversion

in Pro*C/C++, 6-22

JDBC driver, 6-29

OCI driver, 6-27

ODBC and OLE DB drivers, 6-30

thin driver, 6-28

Unicode Java strings, 6-27

data dictionary views

NLS_DATABASE_PARAMETERS, 3-9

NLS_INSTANCE_PARAMETERS, 3-9

NLS_SESSION_PARAMETER, 3-9

data expansion

during data conversion, 6-17

data expansion during character set migration, 10-2

data expansion during conversion

JDBC thin driver, 9-12

data inconsistencies causing data loss, 10-5

data loss

caused by data inconsistencies, 10-5

during character set migration, 10-4

during OCI Unicode character set conversion, 6-15

from mixed character sets, 10-6

data loss during character set conversion, 2-16

data loss during datatype conversion

exceptions, 6-7

data truncation, 10-2

restrictions, 10-3

database character set

character data conversion, 10-8

choosing, 2-14

compatibility between client operating system and applications, 2-16

performance, 2-17

Database Scan Summary Report, 11-20

database schemas

designing for multiple languages, 5-18

datatype conversion

data loss and exceptions, 6-7

implicit, 6-8

SQL functions, 6-9

datatypes

abstract, 2-19

supported, 2-19

date and time parameters, 3-17

date formats, 3-18, 7-13

and partition bound expressions, 3-19

dates

ISO standard, 3-27, 7-14

NLS_DATE_LANGUAGE parameter, 3-20

days

format element, 3-21

language of names, 3-21

DBMS_LOB PL/SQL package, 7-15

DBMS_LOB.LOADBLOBFROMFILE procedure, 7-15

DBMS_LOB.LOADCLOBFROMFILE procedure, 7-15

DBMS_REDEFINITION.CAN_REDEF_TABLE procedure, 10-14

decimal character restrictions, 3-31

dest_char_set parameter, A-18

diacritic, 4-2

dynamic performance views

V$NLS_PARAMETERS, 3-9

V$NLS_VALID_VALUES, 3-9

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

variable-width multibyte, 2-10

error messages

languages, A-4

translation, A-4

euro

Oracle support, 3-37

exclude parameter

Character Set Scanner, 11-11

expanding characters, 4-11

characters

expanding, 4-10

features, new, xxvii

feedback parameter

Character Set Scanner, 11-11

fixed-width multibyte encoding schemes, 2-10

fonts

Unicode, 12-2

Unicode for UNIX, 12-3

Unicode for Windows, 12-2

format elements, 7-14

C, 7-14

D, 7-14

day, 3-21

G, 7-14

IW, 7-14

IY, 7-14

L, 7-14

month, 3-21

RM, 7-13

RN, 7-14

format masks, 3-31, 7-13

formats

currency, 3-32

date, 3-18

numeric, 3-30

time, 3-21

fromchar parameter, 11-12

Character Set Scanner, 11-12

fromnchar parameter

Character Set Scanner, 11-12

full parameter

Character Set Scanner, 11-12

generic base letter search, 4-16

getString() method, 9-3, 9-8

getStringWithReplacement() method, 9-3, 9-8

getSubString() method, 9-3

getUnicodeStream() method, 9-3

globalization features, 1-6

globalization support

architecture, 1-2

help parameter

Character Set Scanner, 11-13

ideographic writing systems, encoding, 2-4

ignorable characters, 4-9

implicit datatype conversion, 6-8

indexes

creating for documents stored as CLOBs, 5-23

creating for multilingual document search, 5-22

creating indexes for documents stored as BLOBs, 5-24

partitioned, 7-12

Individual Exception Report, 11-27

INSTR SQL function, 6-11

INSTR SQL functions, 7-6, 7-7

ISO 8859 character sets, 2-7

ISO standard

date format, 7-14

ISO standard date format, 3-27, 7-14

ISO week number, 7-14

IW format element, 7-14

IY format element, 7-14

Java

Unicode data conversion, 6-27

Java runtime environment, 9-3

Java Stored Procedures

globalization support, 9-18

Java stored procedures, 9-18

Java strings

binding and defining in Unicode, 6-26

Java Virtual Machine, 9-16

globalization support, 9-16

java.sql.ResultSet class, 9-3

JDBC class library

character set conversion, 9-5

JDBC drivers

character set conversion, 9-4

globalization support, 9-2, 9-3

JDBC OCI driver, 9-2

and Unicode, 6-3

character set conversion, 9-6

JDBC programming

Unicode, 6-25

JDBC server-side internal driver, 9-2

character set conversion, 9-7

JDBC server-side thin driver, 9-2

JDBC thin driver, 9-2

and Unicode, 6-4

character set conversion, 9-7

data expansion during conversion, 9-12

SQL CHAR data size restriction, 9-11

JVM, 9-16

globalization support, 9-16

language abbreviations, A-2

language definition

customizing, 12-8

overriding, 3-7

language support, 1-7

languages

error messages, A-4

lastrpt parameter

Character Set Scanner, 11-13

length semantics, 2-12, 3-42

LENGTH SQL functions, 7-6, 7-7

LIKE conditions in SQL statements, 7-8

LIKE2 SQL condition, 7-8

LIKE4 SQL condition, 7-8

LIKEC SQL condition, 7-8

linguistic sort definitions

supported, A-22

linguistic sorts

controlling, 7-12

customizing, 12-35

characters with diacritics, 12-38, 12-41

levels, 4-5

parameters, 3-39

lmsgen utility, 8-57

loading external BFILE data into LOBs, 7-15

LOBs

loading external BFILE data, 7-15

storing documents in multiple languages, 5-21

locale, 3-4

locale information

mapping between Oracle and other standards, 8-14

lxegen utility, 12-18

maxblocks parameter

Character Set Scanner, 11-14

migrating character sets in Oracle9i Real Application Clusters, 10-10

migration

CHAR columns to NCHAR columns, 10-12

character sets, 10-2

from a single-byte character set to a multibyte character set, 10-9

Oracle8 NCHAR columns to Oracle9i, 10-11

to NCHAR datatypes, 10-11

mixed character sets

causing data loss, 10-6

monetary parameters, 3-32

monolingual linguistic sort

example, 4-7

monolingual linguistic sorts

supported, A-22

months

format element, 3-21

language of names, 3-21

multibyte encoding schemes, 2-10

fixed-width, 2-10

shift-sensitive variable-width, 2-10

variable-width, 2-10

multilexers

creating, 5-23

multilingual data

specifying column lengths, 5-19

multilingual demo, 9-23

multilingual document search

creating indexes, 5-22

multilingual linguistic sort

example, 4-7

multilingual linguistic sorts

supported, A-24

multilingual support

restricted, 2-24

unrestricted, 2-25

multiple languages

designing database schemas, 5-18

storing data, 5-19

storing documents in LOBs, 5-21

N SQL function, 6-10

national character set, 2-18, 5-9, 6-5, 6-6

before Oracle9i, 5-8

NCHAR

creating abstract datatype, 2-19

NCHAR columns

migrating from Oracle8 to Oracle9i, 10-11

NCHAR datatype, 6-5

migrating, 10-11

migration, 10-11

NCHR SQL function, 6-12

NCLOB datatype, 6-6

new features, xxvii

NLB files, 12-2

generating and installing, 12-43

NLS Calendar Utility, 12-17

NLS parameters

default values in SQL functions, 7-3

list, 3-3

setting, 3-2

specifying in SQL functions, 7-3

unacceptable in SQL functions, 7-5

using in SQL functions, 7-2

NLS Runtime Library, 1-2

NLS_CALENDAR parameter, 3-29

NLS_CHARSET_DECL_LEN SQL function, 7-10

NLS_CHARSET_ID SQL function, 7-9

NLS_CHARSET_NAME SQL function, 7-9

NLS_COMP parameter, 3-41, 4-15, 7-12

NLS_CREDIT parameter, 3-38

NLS_CURRENCY parameter, 3-32

NLS_DATABASE_PARAMETERS data dictionary view, 3-9

NLS_DATE_FORMAT parameter, 3-18

NLS_DATE_LANGUAGE parameter, 3-20

NLS_DEBIT parameter, 3-38

NLS_DUAL_CURRENCY parameter, 3-35

NLS_INITCAP SQL function, 4-12, 7-2

NLS_INSTANCE_PARAMETERS data dictionary view, 3-9

NLS_ISO_CURRENCY parameter, 3-34

NLS_LANG environment variable

JDBC OCI driver, 9-6

NLS_LANG parameter, 3-4

choosing a locale, 3-4

client setting, 3-8

examples, 3-6

OCI client applications, 6-18

specifying, 3-6

UNIX client, 3-8

Windows client, 3-8

NLS_LANGUAGE parameter, 3-10

NLS_LENGTH_SEMANTICS parameter, 2-12

NLS_LIST_SEPARATOR parameter, 3-41

NLS_LOWER SQL function, 4-12, 7-2

NLS_MONETARY_CHARACTERS parameter, 3-38

NLS_NCHAR_CONV_EXCP parameter, 3-42

NLS_NUMERIC_CHARACTERS parameter, 3-30

NLS_SESSION_PARAMETERS data dictionary view, 3-9

NLS_SORT parameter, 3-39, 4-15

NLS_TERRITORY parameter, 3-13

NLS_TIMESTAMP_FORMAT parameter

parameters

NLS_TIMESTAMP_FORMAT, 3-22

NLS_TIMESTAMP_TZ_FORMAT parameter, 3-23

NLS_UPPER SQL function, 4-12, 7-2

NLSRTL, 1-2

NLSSORT SQL function, 7-2, 7-10

syntax, 7-11

NLT files, 12-2

numbers, encoding, 2-4

numeric formats, 3-30

SQL masks, 7-14

numeric parameters, 3-30

NVARCHAR datatype

Pro*C/C++, 6-24

NVARCHAR2 datatype, 6-6

obsolete locale data, A-27

OCI

binding and defining CLOB and NCLOB data in OCI, 6-21

binding and defining SQL NCHAR datatypes, 6-20

setting the character set, 8-2

SQL CHAR datatypes, 6-18

OCI and Unicode, 6-3

OCI character set conversion, 6-16

data loss, 6-15

performance, 6-15

OCI client applications

using Unicode character sets, 6-18

OCI data conversion

data expansion, 6-17

OCI_ATTR_CHARSET_FORM attribute, 6-15

OCI_ATTR_MAXDATA_SIZE attribute, 6-17

OCI_NLS_MAXBUFSZ, 8-9, 8-13

OCI_UTF16ID character set ID, 6-13

OCI_UTF16ID mode, 8-2

OCIBind() function, 6-18

OCICharSetConversionIsReplacementUsed(), 8-48, 8-52

OCICharSetConvert(), 8-48

OCICharSetToUnicode(), 8-48

OCICharsetToUnicode(), 8-48

OCIDefine() function, 6-18

OCIEnvCreate(), 8-2

OCIEnvNlsCreate function, OCI

setting the character set, xxix

OCIEnvNlsCreate(), 6-13, 8-2

OCILobRead() function, 6-21

OCILobWrite() function, 6-21

OCIMessageClose(), 8-54, 8-56

OCIMessageGet(), 8-54, 8-55

OCIMessageOpen(), 8-54

OCIMultiByteInSizeToWideChar(), 8-16, 8-19

OCIMultiByteStrCaseConversion(), 8-18, 8-38

OCIMultiByteStrcat(), 8-17, 8-34

OCIMultiByteStrcmp(), 8-17, 8-32

OCIMultiByteStrcpy(), 8-18, 8-35

OCIMultiByteStrlen(), 8-18, 8-37

OCIMultiByteStrncat(), 8-17, 8-38

OCIMultiByteStrncmp(), 8-17, 8-33

OCIMultiByteStrncpy(), 8-18, 8-38

OCIMultiByteStrnDisplayLength(), 8-18, 8-38

OCIMultiByteToWideChar(), 8-16, 8-18

OCINlsCharSetConvert(), 8-50

OCINlsCharSetIdToName(), 8-11

OCINlsCharSetNameTold(), 8-10

OCINlsGetInfo(), 8-7

OCINlsNameMap(), 8-14

OCINlsNumericInfoGet(), 8-12

OCISessionBegin(), 8-2

OCIUnicodeToCharSet(), 8-49

OCIUnicodeToCharset(), 8-48

OCIWideCharDisplayLength(), 8-17, 8-31

OCIWideCharInSizeToMultiByte(), 8-16, 8-21

OCIWideCharIsAlnum(), 8-40, 8-41

OCIWideCharIsAlpha(), 8-40, 8-41

OCIWideCharIsCntrl(), 8-40, 8-42

OCIWideCharIsDigit(), 8-40, 8-42

OCIWideCharIsGraph(), 8-40, 8-43

OCIWideCharIsLower(), 8-40, 8-43

OCIWideCharIsPrint(), 8-40, 8-44

OCIWideCharIsPunct(), 8-40, 8-44

OCIWideCharIsSingleByte(), 8-40, 8-47

OCIWideCharIsSpace(), 8-40, 8-45

OCIWideCharIsUpper(), 8-40, 8-45

OCIWideCharIsXdigit(), 8-40, 8-46

OCIWideCharMultiByteLength(), 8-31

OCIWideCharMultibyteLength(), 8-17

OCIWideCharStrCaseConversion(), 8-17, 8-30

OCIWideCharStrcat(), 8-17, 8-25

OCIWideCharStrchr(), 8-17, 8-26

OCIWideCharStrcmp(), 8-16, 8-23

OCIWideCharStrcpy(), 8-17, 8-28

OCIWideCharStrlen(), 8-17, 8-29

OCIWideCharStrncat(), 8-17, 8-30

OCIWideCharStrncmp(), 8-17, 8-24

OCIWideCharStrncpy(), 8-17, 8-28

OCIWideCharStrrchr(), 8-17, 8-30

OCIWideCharToLower(), 8-16, 8-22

OCIWideCharToMultiByte(), 8-16, 8-20

OCIWideCharToUpper(), 8-16, 8-22

ODBC Unicode applications, 6-32

OLE DB Unicode datatypes, 6-33

online table redefinition

migrating from CHAR to NCHAR, 10-12, 10-13

operating system

character set compatibility with applications, 2-16

ORA_NLS33 directory, 1-3

ORA_TZFILE environment variable, 12-17

Oracle Call Interface and Unicode, 6-3

Oracle Locale Builder

choosing a calendar format, 12-12

choosing currency formats, 12-15

choosing date and time formats, 12-13

displaying code chart, 12-18

Existing Definitions dialog box, 12-5

fonts, 12-2, 12-3

Open File dialog box, 12-7

Preview NLT screen, 12-6

restrictions on names for locale objects, 12-9

Session Log dialog box, 12-5

starting, 12-3

Oracle ODBC driver and Unicode, 6-3

Oracle OLE DB driver and Unicode, 6-3

Oracle Pro*C/C++ and Unicode, 6-3

Oracle Real Application Clusters

during database character set migration, 10-10

Oracle SQLJ and Unicode, 6-4

Oracle8 NCHAR columns

migrating to Oracle9i, 10-11

oracle.sql.CHAR class, 9-3

character set conversion, 9-8

getString() method, 9-8

getStringWithReplacement() method, 9-8

toString() method, 9-8

oracle.sql.CLOB class, 9-3

oracle.sql.NString class, 9-16

ORDER BY clause, 7-12

overriding language and territory definitions, 3-7

parameters

BLANK_TRIMMING, 10-4

calendar, 3-26

character set conversion, 3-42

linguistic sorts, 3-39

methods of setting, 3-3

monetary, 3-32

NLS_CALENDAR, 3-29

NLS_COMP, 3-41

NLS_CREDIT, 3-38

NLS_CURRENCY, 3-32

NLS_DATE_FORMAT, 3-18

NLS_DATE_LANGUAGE, 3-20

NLS_DEBIT, 3-38

NLS_DUAL_CURRENCY, 3-35

NLS_ISO_CURRENCY, 3-34

NLS_LANG, 3-4

NLS_LANGUAGE, 3-10

NLS_LIST_SEPARATOR, 3-41

NLS_MONETARY_CHARACTERS, 3-38

NLS_NCHAR_CONV_EXCP, 3-42

NLS_NUMERIC_CHARACTERS, 3-30

NLS_SORT, 3-39

NLS_TERRITORY, 3-13

NLS_TIMESTAMP_TZ_FORMAT, 3-23

numeric, 3-30

setting, 3-2

time and date, 3-17

time zone, 3-22

partitioned

indexes, 7-12

tables, 7-12

performance

choosing a database character set, 2-17

during OCI Unicode character set conversion, 6-15

phonetic writing systems, encoding, 2-4

PL/SQL and SQL and Unicode, 6-4

preserve parameter

Character Set Scanner, 11-14

primary level sort, 4-5

Private Use Area, 12-26

Pro*C/C++

data conversion, 6-22

NVARCHAR datatype, 6-24

UVARCHAR datatype, 6-24

VARCHAR datatype, 6-23

punctuation, encoding, 2-4

QUERY_REWRITE_ENABLED initialization parameter, 4-14

replacement characters

CONVERT SQL function, 7-6

restricted multilingual support, 2-24

restrictions

data truncation, 10-3

passwords, 10-3

space padding during export, 10-4

usernames, 10-3

reverse secondary sorting, 4-11

RPAD SQL function, 6-11

scan modes

Character Set Scanner, 11-4

full database scan, 11-4

single table scan, 11-5

user tables scan, 11-5

search, generic base letter, 4-16

searching multilingual documents, 5-22

secondary level sort, 4-5

shift-sensitive variable-width multibyte encoding schemes, 2-10

single-byte encoding schemes, 2-9

sorting

reverse secondary, 4-11

specifying nondefault linguistic sorts, 3-39, 3-41

source_char_set parameter, A-18

space padding

during export, 10-4

special combination letters, 4-9, 4-11

special letters, 4-10, 4-11

special lowercase letters, 4-12

special uppercase letters, 4-12

SQL CHAR datatypes, 2-14

inserting a Java string, 9-4

OCI, 6-18

SQL conditions

LIKE2, 7-8

LIKE4, 7-8

LIKEC, 7-8

SQL functions

CONVERT, 7-6

datatype conversion, 6-9

default values for NLS parameters, 7-3

INSTR, 6-11, 7-6, 7-7

LENGTH, 7-6, 7-7

N, 6-10

NCHR, 6-12

NLS_CHARSET_DECL_LEN, 7-10

NLS_CHARSET_ID, 7-9

NLS_CHARSET_NAME, 7-9

NLS_INITCAP, 4-12, 7-2

NLS_LOWER, 4-12, 7-2

NLS_UPPER, 4-12, 7-2

NLSSORT, 7-2, 7-10

RPAD, 6-11

specifying NLS parameters, 7-3

SUBSTR, 7-6, 7-7

SUBSTR2, 7-7

SUBSTR4, 7-7

SUBSTRB, 7-7

SUBSTRC, 7-7

TO_CHAR, 7-2

TO_DATE, 6-10, 7-2

TO_NCHAR, 6-10

TO_NUMBER, 7-2

unacceptable NLS parameters, 7-5

UNISTR, 6-12

using NLS parameters, 7-2

SQL NCHAR datatypes

binding and defining in OCI, 6-20

using JDBC, 9-7

SQL statements

LIKE conditions, 7-8

SQLJ

globalization support, 9-14

multilingual demo application, 9-23

programming with Unicode, 6-25

translators, 9-3

using Unicode characters, 9-15

stored procedures

Java, 9-18

strict superset, 5-3

string comparisons

WHERE clause, 7-11

string literals

Unicode, 6-11

string manipulation using OCI, 8-15

SUBSTR SQL function, 7-7

SUBSTR SQL functions, 7-6, 7-7

SUBSTR, 7-7

SUBSTR2, 7-7

SUBSTR4, 7-7

SUBSTRB, 7-7

SUBSTRC, 7-7

SUBSTR4 SQL function, 7-7

SUBSTRB SQL function, 7-7

SUBSTRC SQL function, 7-7

superset, strict, 5-3

supersets and subsets, A-19

supplementary characters, 4-4, 5-3

linguistic sort support, A-25

supported datatypes, 2-19

supported territories, A-5

suppress parameter

Character Set Scanner, 11-15

surrogate pairs, 5-3

syllabary, 2-4

symbols, encoding, 2-4

table parameter

Character Set Scanner, 11-15

tables

partitioned, 7-12

territory definition, 3-13

customizing, 12-11

overriding, 3-7

territory support, 1-7, A-5

tertiary level sort, 4-6

Thai and Laotian character rearrangement, 4-11

tilde, 9-13

time and date parameters, 3-17

time zone information

Oracle's source, 3-24

time zone parameters, 3-22

changing during a session, 3-25

creating a database, 3-24

time zones

customizing, 12-17

timestamp format, 3-22

timestamp with time zone, 3-23

timezlrg.dat file, 12-17

timezone.dat file, 12-17

TO_CHAR SQL function, 7-2

default date format, 3-18

format masks, 7-13

group separator, 3-31

language for dates, 3-20

spelling of days and months, 3-20

TO_DATE SQL function, 6-10, 7-2

default date format, 3-18

format masks, 7-13

language for dates, 3-20

spelling of days and months, 3-20

TO_NCHAR SQL function, 6-10

TO_NUMBER SQL function, 7-2

format masks, 7-13

tochar parameter

Character Set Scanner, 11-16

toString() method, 9-3, 9-8

translators

SQLJ, 9-3

UCS-2 encoding, 5-4

Unicode, 5-2

binding and defining Java strings, 6-26

character code assignments, B-2

character set conversion between OCI client and database server, 6-15

code ranges for UTF-16 characters, B-2

code ranges for UTF-8 characters, B-2

data conversion in Java, 6-27

JDBC and SQLJ programming, 6-25

JDBC OCI driver, 6-3

JDBC thin driver, 6-4

ODBC and OLE DB programming, 6-29

Oracle Call Interface, 6-3

Oracle ODBC driver, 6-3

Oracle OLE DB driver, 6-3

Oracle Pro*C/C++, 6-3

Oracle SQLJ, 6-4

Oracle support, 5-5

PL/SQL and SQL, 6-4

Private Use Area, 12-26

programming, 6-2

string literals, 6-11

UCS-2 encoding, 5-4

UTF-16 encoding, 5-4

UTF-8 encoding, 5-3

Unicode database, 5-7

case study, 5-16

choosing a character set, 5-12

using with Unicode datatypes (case study), 5-18

when to use, 5-10

Unicode datatypes, 5-8

case study, 5-17

choosing a national character set, 5-14

using with a Unicode database (case study), 5-18

when to use, 5-11

Unicode encoding, 5-3

Unicode escape sequence, 9-15

Unicode fonts, 12-2

Unicode mode, 6-13, 8-2

UNISTR SQL function, 6-12

unrestricted multilingual support, 2-25

US7ASCII

supersets, A-20

user parameter

Character Set Scanner, 11-16

user-defined characters, 12-24

adding to a character set definition, 12-30

cross-references between character sets, 12-26

supporting in Java, 12-32

userid parameter

Character Set Scanner, 11-17

UTF-16 encoding, 5-4, B-3

UTF8 character set, 5-7, A-18

UTF-8 encoding, 5-3, B-4

UTFE character set, 5-6, 5-8, A-18

UTL_FILE package, using with NCHAR, 6-12

UVARCHAR datatype

Pro*C/C++, 6-24

V$NLS_PARAMETERS dynamic performance view, 3-9

V$NLS_VALID_VALUES dynamic performance view, 3-9

V$TIMEZONE_NAMES view, 12-17

VARCHAR datatype

Pro*C/C++, 6-23

variable-width multibyte encoding schemes, 2-10

wave dash, 9-13

WHERE clause

string comparisons, 7-11

Index

Numerics

A

B

C

D

E

F

G

H

I

J

L

M

N

O

P

Q

R

S

T

U

V

W