Skip Headers

Oracle® Database Globalization Support Guide
10g Relea se 1 (10.1)
Part Number B10749-01

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& nbsp; 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/zone info/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
accen t-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
AL32UTF 8 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
< dd class="L1IX">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_TER RITORY clause, 3-18
ALTER TABLE MODIFY statement
migrating from CHAR to NCHAR, 11-12, 11-13
analyse_histgrm.sql script, 12-37
analyse_rul e.sql script, 12-37
analyse_source.sql script, 12-37
application-locales, 8-38
Arial Unicode MS f ont, 13-2
array parameter
Database Chara cter Set Scanner, 12-12
ASCII encoding, 2-6
AT LOCAL clause, 4-25
AT TIME ZONE clause , 4-25

B

base letter, 5-7< /dd>
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< /dd>
binding and defining CLOB and NCLOB data in OCI, 7-21
binding and defining SQL CHAR datatypes in OCI, 7-19
binding and d efining SQL NCHAR datatypes in OCI, 7-20
BLANK_TRIMMING parameter, 11-4
BLOBs
creating indexes, 6-23
boundaries parameter
Database Character Set S canner, 12-13
byte semantics, 2-12< /a>, 3-44

C

C number format mask, 3-36
Calendar Utility, 13-17
calendars
customizing, 13-17
parameter, 3-27
supported, A-28
canoni cal equivalence, 5-4, 5-9
capture paramet er
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
cha racter data conversion
database character set, 11-8
< /dd>
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
ch anging after database creation, 2-20
conversion, 2-17, 13-24
customizing, 13-22
data loss during conversion, 2-17
detecting with Globali zation Development Kit, 8-32
encoding, 2-2< /dd>
national, 2-19, 6-9, 7-6
character set conversion
between OCI client an d database server, 7-15
parameters, 3-43< /dd>
character set definition
customizing, 13-26
guidelines for editing files, 13-25
nami ng files, 13-25
character set migration
CSALTER script, 11-8
identifying character data conversion problem s, 11-7
postmigration tasks, 11-16
< dd class="L2IX">scanning character data, 11-7
character sets
AL16UTF16, 6-6
AL24UTFFSS, 6-6
AL32UTF8, 6-6
Asian, A-8
choosing, 11-2
choosing a ch aracter 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
r estrictions on character sets used to express names, 2-18
supersets and subs ets, A-20
supported, A-7
supporting different character repertoires, 2-5
universal, A-19
UTFE, 6-6
characte r 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
CL OB and NCLOB data
binding and defining in OCI, 7-21
< /dd>
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 chara cter 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$COL UMNS 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
CSM V$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
i n Pro*C/C++, 7-22
OCI driver, 7-29
< dd class="L2IX">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 view s
NLS_DATABASE_PARAMETERS, 3-11
NLS_INST ANCE_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< /a>
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 < dl class="L2IX">
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.s ql script, 12-37
analyse_rule.sql script, 12- 37
analyse_source.sql script, 12-37
array paramete r, 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
excl ude parameter, 12-13
feedback parameter, 12-1 4
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< /a>
maxblocks parameter, 12-18
online help, 12-10
performance, 12-39
pres erve 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 d atetime 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, < a href="ch9sql.htm#1006460">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
i nserting values, 4-8
datetime format parameters, 4-18
Daylight Saving Time
Oracle support, 4-26
daylight saving time session parameter, 4-20< /a>
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
detec tion
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 char acters, 2-4
ideographic writing systems, 2-4< /a>
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
exc lude parameter
Database Character Set Scanner, 12-13
expanding characters, 5-10
characters
expanding, 5-8
EXTRAC T (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 elem ents, 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, < a href="ch9sql.htm#1006906">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 applic ation 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< /dd>
gdkapp.xml application configuration file, 8-36
gdkapp.x ml GDK application configuration file, 8-15
GENERIC_BASELETTER linguistic sort , 5-12
getString() method, 7-31
getStringWithReplacement() method, 7-32
Globalization Develoopm ent Kit
Java API, 8-26
Globaliza tion 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 mess ages, 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 bi nary 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 map ping, 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
creatin g 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 ch aracter sets, 2-7
ISO locales
mapping wi th 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 conver sion, 7-29
Java strings
bindin g 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 int ernal driver
and Unicode, 7-4
JDBC Server Side thin driver
and Unicode, 7-4
< dd class="L1IX">JDBC thin driver
and Unicode, 7-4
data expansion during conversion, 7-35
SQL CHAR data size restrict ion, 7-34

L

language
detecting with Globalization Development Kit, 8-32
language ab breviations, 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 href="applocal.htm#634675">A-4
languages and character sets
supported by LCSSCAN, A-23
LAST_DAY SQL function, 4-16
lastrpt parameter
Database Character Set Scanner, < a href="ch12scan.htm#1006446">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< /a>
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< /a>
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 sor t definitions
supported, A-25
l inguistic sorts
controlling, 9-12
customiz ing, 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 betwe en 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
LOCALTIMEST AMP SQL function, 4-17
lossy data
data d ictionary, 12-36
lxegen utility, 13 -18

M< /font>

maxblocks parameter
Database Character Set Scanner , 12-18
message-bundles, 8-41
migrating a character set
CSALTER script, 11-8< /a>
migrating character sets in Real Application Clusters, 11-10
migration
CHAR columns to NCHAR columns, 11-1 2
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 linguist ic 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
multile xers
creating, 6-21
multilingu al data
specifying column lengths, 6-18
multilingual document search
creating indexes, 6-21< /dd>
multilingual Internet application, 8-5
multili ngual 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 cha racter set, 2-19, 6-9, 7-6
before Oracle9i, 6-9
NCHAR
creating abstract datatype, 2-20
N CHAR columns
migrating from version 8 to Oracle9i and later, 11-11
NCHAR datatype, 7-5
migra ting, 11-10
migration, 11-11
NCHR SQL function, 7-12
NCLOB datatype, 7-7
NEW_TIME SQL function, 4-16
NEX T_DAY SQL function, 4-16
NLB data
transp ortable, 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
unac ceptable in SQL functions, 9-5
NLS Runtime Library, 1-2
NLS_CALENDAR parameter, 3-30
NL S_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_CRED IT 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< /dd>
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 par ameter, 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_P ARAMETERS 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_T IMESTAMP_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< /dd>
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 cha racter set conversion, 7-16
data loss, 7-15
performance, 7-16
OCI clien t applications
using Unicode character sets, 7-18
OCI data conversion
data expansion, 7-17
OCI_ATTR_CHARSET_FORM attribute, 7-15
OCI_ATT R_MAXDATA_SIZE attribute, 7-17
OCI_UTF16ID character set ID, 7-14
OCIBind() function, 7-19
OCIC harSetConversionIsReplacementUsed(), 10-8
OCICharSetConvert(), 10-8
OCICharsetToUnicode(), 10-7
OC IDefine() function, 7-19
OCIEnvNlsCreate(), 7 -14, 10-2
OCILobRead() function, 7-21< /dd>
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
OCIMultiByteStrle n(), 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
OCINlsNumer icInfoGet(), 10-3
OCIUnicodeToCharset(), 10-7
OCIWideCharDisplayLength(), 10-6
OCIWideCharInSizeTo MultiByte(), 10-5
OCIWideCharIsAlnum(), 10-7
OCIWideCharIsAlpha(), 10-7
OCIWideCharIsCntrl(), 10-7
OCIWideCharIsDigit(), 10-7
OCIWideCharIsGraph(), 10-7
OCIWideCharIsLower(), 10-7
OCIWideCharIsPrint(), 10-7
OCIWideCha rIsPunct(), 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
OCIWideC harStrlen(), 10-6
OCIWideCharStrncat(), 10-5
OCIWideCharStrncmp(), 10-5
OCIWideCharStrncpy(), 10-6
OCIWideCharStrrchr(), 10-5
OCIWideCharToLower(), 10-5
OCIWideCharToMultiByte(), 10-5
OCIWideCharToUpper(), 10-5
ODBC U nicode 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 v ariable, 4-19, 4-24
ORA_TZFILE environmen t 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 L ocale 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 OD BC 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
or acle.i18n.text package, 8-45
oracle.i18n.util package, 8-46
oracle.sql.CHAR class
character set conversion, 7-31
getString() method, 7-31
g etStringWithReplacement() 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
m ethods 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
N LS_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
< dd class="L1IX">phonetic writing systems, encoding, 2-4
PL/SQL and SQL and U nicode, 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 datatyp e, 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 env ironment, 5-22
replacement characters
CONVERT SQL function, 9-6
restricted multilingual support, < a href="ch2chars.htm#1007294">2-24
restrictions
data truncation, 11-3
passwords, 11-3
spac e 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< /font>

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
< dd class="L1IX">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 e ncoding 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
CURRE NT_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
RP AD, 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< /dd>
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
S QL NCHAR datatypes
binding and defining in OCI, 7-20
SQL statements
LIKE conditions, 9-8
< /dl>
strict superset, 6-3
string comparisons
WHERE clause, 9-11
string literals
Unicode, 7-11
string manipulation us ing 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
< dd class="L2IX">SUBSTRC, 9-7
SUBSTR4 SQL function, 9-7
SUBSTRB SQL function, 9-7
SUBSTRC SQ L 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< /dd>
supported territories, A-6
suppress parameter
Database Character Set Scanner, 12-20
s urrogate pairs, 6-3
syllabary, 2-4
< dd class="L1IX">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 c haracter rearrangement, 5-10
tilde, 7-36< /dd>
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 n ames, 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
tim ezlrg.dat file, 13-17
timezone.dat file, 13-1 7
TO_CHAR (datetime) SQL function, 4-18
TO_CHAR SQ L 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
< dd class="L2IX">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() meth od, 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 defin ing 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 rang es 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< /a>
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 s tream 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 mu ltilingual 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 be tween 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
Pr o*C/C++, 7-24

V

V$NLS_PARAMETERS dynamic performanc e 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
Go to previous page
Previous
 Oracle
Copyr ight © 1996, 2003 Oracle Corporation
All Rights Reserved.		 < td align="center" valign="top">Go to Book List
Book List
Go to Documentation Home
Home		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Feedback
< /div>