Oracle9i Globalization Support Guide
Release 1 (9.0.1)

Part Number A90236-02
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  R  S  T  U  W 


A

abbreviations
AM/PM, 3-17
BC/AD, 3-17
languages, A-2
AL32UTF8 character set, 5-5
ALTER DATABASE CHARACTER SET statement, 10-7
ALTER DATABASE NATIONAL CHARACTER SET statement, 10-7
ALTER SESSION statement
SET NLS_CURRENCY clause, 3-27, 3-28
SET NLS_DATE_FORMAT clause, 3-15
SET NLS_LANGUAGE clause, 3-12
SET NLS_NUMERIC_CHARACTERS clause, 3-26
SET NLS_TERRITORY clause, 3-12
ALTER SYSTEM statement
SET NLS_LANGUAGE clause, 3-12
AM/PM abbreviation
language of, 3-17
array parameter
Character Set Scanner Utility, 10-16
ASCII encoding, 2-6

B

BC/AD abbreviation
language of, 3-17
BLANK_TRIMMING paramter, 10-4
boundaries parameter
Character Set Scanner Utility, 10-17

C

calendar systems
support, A-26
calendars, A-26
customized, 12-7
formats, 3-21
parameter, 3-21
systems, 3-23
capture parameter
Character Set Scanner Utility, 10-17
CHAR
class, 9-8
character set
conversion, 2-11
encoding, 2-2
setting definition, 11-16
character set migration
data scanning, 10-7
Character Set Scanner
scan modes, 10-11
Character Set Scanner Utility, 10-1, 10-9, 10-18
array parameter, 10-16
boundaries parameter, 10-17
capture parameter, 10-17
compatibility, 10-13
feedback parameter, 10-18
fromnchar parameter, 10-18
full parameter, 10-19
help parameter, 10-19
invoking, 10-14
lastrpt parameter, 10-19, 10-20
maxblocks parameter, 10-20
online help, 10-14
parameter file, 10-15
parameters, 10-16
scanner messages, 10-40
scanner parameters, 10-16
scanner tables, 10-37
suppress parameter, 10-21
table parameter, 10-21
tochar parameter, 10-22
user parameter, 10-22
userid parameter, 10-23
character sets
8-bit versus 7-bit, 7-5
Asian, A-8
choosing, 10-2
conversion, 2-16
conversion using OCI, 8-35
converting, 7-5
data loss, 10-4
European, A-9
Middle Eastern, A-15
migrating, 10-2
migration, 10-2
naming, 2-10
parameters, 3-34
restrictions on expressing names and text, 2-13
storage, A-6
supported, 2-15
universal, A-18
choosing character sets, 10-2
collation
using Locale Builder Utility, 11-25
collation parameters, 3-32
concatenation operator, 7-14
conversion
between character set ID number and character set name, 7-9
CONVERT function, 7-5
converting
character sets, 7-5
CSM$COLUMNS parameter, 10-35
CSM$ERRORS parameter, 10-36
CSM$TABLES parameter, 10-35
CSMIG user, 10-13
CSMINST.SQL script, 10-13
running, 10-13
currencies
formats, 3-26
monetary
units characters, 3-30
symbols
default, 3-10
local currency symbol, 3-27
customized
calendars, 12-7
character sets, 12-2

D

data
conversion, 7-5
data conversion
database character set, 10-7
data expansion during character set migration, 10-2
data inconsistencies
causing data loss, 10-5
data loss
caused by data inconsistencies, 10-5
during character set migration, 10-4
from mixed character sets, 10-6
data scanning
character set migration, 10-7
data truncation, 10-2
restrictions, 10-3
database character set
choosing, 2-10
conversion, 10-7
database character set migration, 10-6
Database Scan Summary Report, 10-26, 10-27
date formats, 3-14, 7-12
and partition bound expressions, 3-16
dates
ISO standard, 3-22, 7-13
NLS_DATE_LANGUAGE parameter, 3-16
days
format element, 3-17
language of names, 3-17
decimal character
default, 3-10
NLS_NUMERIC_CHARACTERS parameter, 3-25
when not a period (.), 3-25
drivers
JDBC, 9-2

E

EJB, 9-25
encoding schemes, 2-8
Enterprise Java Beans, 9-25
explicit authentication, 9-25

F

feedback parameter
Character Set Scanner Utility, 10-18
format elements, 7-12, 7-13
C, 7-14
D, 3-25, 7-13
day, 3-17
G, 3-25, 7-13
IW, 7-13
IY, 7-13
L, 3-27, 7-13
month, 3-17
RM, 3-15, 7-12
RN, 7-14
formats
calendar, 3-21
currency, 3-26
numeric, 3-24
fromchar parameter, 10-18
Character Set Scanner Utility, 10-18
fromnchar parameter
Character Set Scanner Utility, 10-18
full parameter
Character Set Scanner Utility, 10-19

G

getString() method, 9-8
getStringWithReplacement() method, 9-8
Globalization
architecture, 1-2
globalization features, 1-5
group separator, 3-25
default, 3-10
NLS_NUMERIC_CHARACTERS parameter, 3-25

H

help parameter
Character Set Scanner Utility, 10-19

I

implicit authentication, 9-25
indexes
partitioned, 7-12
Individual Exception Report, 10-26, 10-33
ISO standard
date format, 3-22, 7-13
ISO week number, 7-13
IW format element, 7-13
IY format element, 7-13

J

Java runtime environment, 9-3
Java stored procedures, 9-16
Java Virtual Machine, 9-14
java.sql.ResultSet, 9-4
JDBC
class library, 9-6
drivers, 9-2
OCI driver
NLS considerations, 9-6
Server driver, 9-7
Thin driver
NLS considerations, 9-7
JDBC drivers
and NLS, 9-4
JVM, 9-14

L

L format element, 3-27
language definition
setting, 11-8
language support, 1-6
languages
overriding, 3-6
lastrpt parameter
Character Set Scanner Utility, 10-19, 10-20
linguistic definitions, A-22
supported, A-22
linguistic sorts
controlling, 7-12
list separator, 3-34
local currency symbol, 3-27
Locale Builder Utility, 11-3
restrictions, 11-5
LXEGEN executable, 12-8
LXINST executable, 12-8

M

maxblocks parameter
Character Set Scanner Utility, 10-20
messages
error, A-4
translated, A-4
migrating character sets, 10-2
migration
database character set, 10-6
mixed character sets
causing data loss, 10-6
monetary
parameters, 3-26
units characters, 3-30
months
format element, 3-17
language of names, 3-17

N

National Language Support (NLS)
NLS_LANGUAGE parameter, 7-5
NCHAR datatype migration, 5-16
NLB files, 11-2
NLS
and JDBC drivers, 9-4
conversions, 9-4
for JDBC OCI drivers, 9-6
for JDBC Thin drivers, 9-7
Java methods that employ, 9-4
NLS Calendar Utility, 12-7
NLS data
error messages, A-4
supported calendar systems, A-26
supported linguistic definitions, A-22
supported territories, A-5
NLS Data Installation Utility, 12-8
NLS locales, 3-4
NLS parameters
setting, 3-2
using in SQL functions, 7-2
NLS runtime library, 1-2
NLS_CALENDAR parameter, 3-23
NLS_CHARSET_DECL_LEN function, 7-9
NLS_CHARSET_ID function, 7-9
NLS_CHARSET_NAME function, 7-9
NLS_COMP parameter, 3-33, 7-11
NLS_CREDIT parameter, 3-26, 3-31
NLS_CURRENCY parameter, 3-26
NLS_DATE_FORMAT parameter, 3-14
NLS_DATE_LANGUAGE parameter, 3-16
NLS_DEBIT parameter, 3-31
NLS_DUAL_CURRENCY parameter, 3-29
NLS_ISO_CURRENCY parameter, 3-28
NLS_LANG
choosing a locale with, 3-4
environment variable, 9-6
examples, 3-6
specifying, 3-6
NLS_LANGUAGE parameter, 3-8
NLS_LIST_SEPARATOR parameter, 3-34
NLS_MONETARY_CHARACTERS parameter, 3-30
NLS_NUMERIC_CHARACTERS parameter, 3-25
NLS_SORT parameter, 3-32, 3-33
NLS_TERRITORY parameter, 3-10
NLSSORT function, 7-9
NLT files, 11-2
numeric
formats, 3-24, 7-13
parameters, 3-24

O

ORA_NLS33 directory, 1-3
Oracle Real Application Clusters
during database character set migration, 10-9
oracle.sql.CHAR, 9-4
oracle.sql.CHAR class, 9-8
getString() method, 9-8
getStringWithReplacement() method, 9-8
toString() method, 9-8
oracle.sql.CLOB, 9-4
ORANLS option, 12-8
ORDER BY clause, 7-12
overriding language and territory specifications, 3-6

P

parameters
BLANK_TRIMMING, 10-4
calendar, 3-21
collation, 3-32
CSM$COLUMNS, 10-35
CSM$ERRORS, 10-36
CSM$TABLES, 10-35
monetary, 3-26
NLS_CALENDAR, 3-23
NLS_COMP, 3-33
NLS_CREDIT, 3-26, 3-31
NLS_CURRENCY, 3-26
NLS_DATE_FORMAT, 3-14
NLS_DATE_LANGUAGE, 3-16
NLS_DEBIT, 3-31
NLS_DUAL_CURRENCY, 3-29
NLS_ISO_CURRENCY, 3-28
NLS_LANGUAGE, 3-8
NLS_LIST_SEPARATOR, 3-34
NLS_MONETARY_CHARACTERS, 3-30
NLS_NUMERIC_CHARACTERS, 3-25
NLS_SORT, 3-32, 3-33
NLS_TERRITORY, 3-10
numeric, 3-24
setting, 3-2
time, 3-14
partitioned
indexes, 7-12
tables, 7-12

R

replacement characters, 7-5
restricted multilingual support, 2-18
restrictions
data truncation, 10-3
passwords, 10-3
space padding during export, 10-4
usernames, 10-3
RM format element, 3-15
Roman numerals
format mask for, 3-15

S

scan modes
Character Set Scanner Utility, 10-11
database character sets
full database scan, 10-12
single table scan, 10-12
user tables scan, 10-12
sorting
specifying non-default, 3-32, 3-33
space padding
during export, 10-4
SQLJ
client, 9-35
SQLJ translators, 9-3
storage character sets, A-6
stored procedures
Java, 9-16
string comparisons
and WHERE clause, 7-11
string manipulation using OCI, 8-8
subsets
and supersets, A-19
supersets
and subsets, A-19
supported character sets, 2-15
supported character string functionality and character sets, 2-15
suppress parameter
Character Set Scanner Utility, 10-21

T

table parameter
Character Set Scanner Utility, 10-21
tables
partitioned, 7-12
territories, 3-10
overriding, 3-6
supported, A-5
territory definition
setting, 11-11
territory support, 1-6
time parameters, 3-14
TO_CHAR function
default date format, 3-14
format masks, 7-12
group separator, 3-25
language for dates, 3-16
spelling of days and months, 3-16
TO_DATE function
default date format, 3-14
format masks, 7-12
language for dates, 3-16
spelling of days and months, 3-16
TO_NUMBER function
format masks, 7-12
group separator, 3-25
tochar parameter
Character Set Scanner Utility, 10-22
toString() method, 9-8
translated messages, A-4
translators
SQLJ, 9-3

U

Unicode, 5-2
character code assignments, B-2
data migration, 5-14
Unicode encoding, 5-2
user parameter
Character Set Scanner Utility, 10-22
userid parameter
Character Set Scanner Utility, 10-23
UTF-16 encoding, B-3
UTF8, A-18
UTF8 character set, 5-5
UTF-8 encoding, B-3
UTFE, A-18
UTFE character set, 5-5

W

WHERE clause
and string comparisons, 7-11

Go to previous page
Oracle
Copyright © 1996-2001, 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