Skip Headers

Oracle9i Database Globalization Support Guide
Release 2 (9.2)

Part Number A96529-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

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


Numerics

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

A

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

B

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

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

D

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

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

F

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

G

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

H

help parameter
Character Set Scanner, 11-13

I

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

J

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

L

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

M

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

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

O

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

P

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

Q

QUERY_REWRITE_ENABLED initialization parameter, 4-14

R

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

S

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

T

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

U

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

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

W

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

Go to previous page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback