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