Index
A
- abbreviations
- languages A.1
- abstract data type
- creating as NCHAR 2.3.9
- accent-insensitive linguistic sort 5.5
- ADD_MONTHS SQL function 4.4
- ADO interface and Unicode 7.6.6
- AL16UTF16 character set 6.2.3, A.4.5
- AL24UTFFSS character set 6.2.3
- AL32UTF8 character set 6.2.3, 6.3.1, A.4.5
- ALTER SESSION statement
- application-locales 8.8.3
- ASCII encoding 2.1.3.1
B
- base letters 5.3.2.1.1, 5.4.1
- BFILE data
- loading into LOBs 9.3.4
- binary sorts 5.2
- binding and defining CLOB and NCLOB data in OCI 7.3.7
- binding and defining SQL CHAR datatypes in OCI 7.3.4
- binding and defining SQL NCHAR datatypes in OCI 7.3.5
- BLANK_TRIMMING parameter 11.1.1.1
- BLOBs
- creating indexes 6.5.4.3
- byte semantics 2.2, 3.12.1
C
- calendars
- Calendar Utility 12.12
- canonical equivalence 5.3.2, 5.4.7
- case 5.1
- case-insensitive linguistic sort 5.5
- CESU-8 compliance A.4.5
- character data
- converting with CONVERT SQL function 9.2.1
- character data conversion
- database character set 11.2
- character data scanning
- before character set migration 11.2
- character rearrangement 5.4.9
- character repertoire 2.1.1
- characters
- character semantics 2.2, 3.12.1
- character set
- character set conversion
- character set definition
- character set encodings for conversion only A.4.6
- character set migration
- character sets
- AL16UTF16 6.2.3
- AL24UTFFSS 6.2.3
- AL32UTF8 6.2.3
- ASCII A.4.1
- changing after database creation 2.5
- choosing 11.1
- conversion 2.3.3, 2.6.1, 9.2.1
- conversion using OCI 10.7
- customizing 12.5
- data loss 11.1.2.1
- EBCDIC A.4.1
- encoding 2.1
- ISO 8859 series 2.1.3.1
- migration 11.1, 11.1.1
- naming 2.1.5
- national 6.3.2, 7.2.1.1
- other ASCII-based A.4.2
- other EBCDIC-based A.4.2
- restrictions on character sets used to express names 2.3.5.1
- supersets and subsets A.4.7
- supported A.4
- supporting different character repertoires 2.1.3
- universal A.4.5
- UTFE 6.2.3
- character snational 2.3.8
- character type conversion
- error reporting 3.11.1
- choosing a character set 11.1
- client-only character sets A.4.4
- client operating system
- character set compatibility with applications 2.3.2
- CLOB and NCLOB data
- binding and defining in OCI 7.3.7
- CLOBs
- creating indexes 6.5.4.2
- C number format mask 3.9.3
- code chart
- displaying and printing 12.4
- code point 2.1.1
- collation
- comparisons
- linguistic 5.6
- compatibility
- client operating system and application character sets 2.3.2
- composed characters 5.4.4
- context-sensitive characters 5.4.6
- contracting characters 5.4.4
- contracting letters 5.4.11
- control characters, encoding 2.1.2.3
- conversion
- between character set ID number and character set name 9.2.4
- converting character data
- CONVERT SQL function 9.2.1
- converting character data between character sets 9.2.1
- CONVERT SQL function 9.2.1
- convert time zones 4.11
- Coordinated Universal Time 4.2.1.3, 4.2.1.4
- creating a database with Unicode datatypes 6.3.2
- creating a Unicode database 6.3.1
- CSREPAIR script 11.3
- currencies
- formats 3.9.1
- CURRENT_DATE SQL function 4.4
- CURRENT_TIMESTAMP SQL function 4.4
D
- database character set
- Database Migration Assistant for Unicode (DMU) 11.2.1
- database schemas
- designing for multiple languages 6.5
- database time zone 4.9
- data-bound collation
- data conversion
- data expansion
- data inconsistencies causing data loss 11.1.2.2
- data loss
- Data Pump PL/SQL packages and character set migration 11.1.2.3
- data truncation 11.1.1
- restrictions 11.1.1.1
- datatype conversion
- data types
- date and time parameters 3.6
- date formats 3.6.1, 3.6.1.1, 9.3.1
- and partition bound expressions 3.6.1.1
- dates
- datetime data types 4.2
- inserting values 4.2.1.5
- datetime format parameters 4.5.1
- Daylight Saving Time
- Daylight Saving Time Upgrade parameter 4.5.4
- days
- DBTIMEZONE SQL function 4.4
- detecting language and character sets
- Globalization Development Kit 8.7.6
- detection
- supported languages and character sets A.5
- diacritic 5.1
- DMU
- Database Migration Assistant for Unicode 11.2.1
- DST_UPGRADE_INSERT_CONV inititialization parameter 4.5.4
- DUCET (Default Unicode Collation Element Table) 5.3.3
E
F
G
- GDK application configuration file 8.8
- example 8.8.8
- GDK application framework for J2EE 8.6
- GDK components 8.4
- GDK error messages 8.11
- GDK Java API 8.7
- GDK Java supplied packages and classes 8.9
- GDK Localizer object 8.6.4
- Globalization Development Kit 8.1
- application configuration file 8.8
- character set conversion 8.7.3
- components 8.4
- defining supported application locales 8.6.5
- e-mail programs 8.7.8
- error messages 8.11
- framework 8.6
- integrating locale sources 8.6.2
- Java API 8.7
- Java supplied packages and classes 8.9
- locale detection 8.6.3
- Localizer object 8.6.4
- managing localized content in static files 8.6.7.2
- managing strings in JSPs and Java servlets 8.6.7.1
- non_ASCII input and output in an HTML page 8.6.6
- Oracle binary and linguistic sorts 8.7.5
- Oracle date, number, and monetary formats 8.7.4
- Oracle language and character set detection 8.7.6
- Oracle locale information 8.7.1
- Oracle locale mapping 8.7.2
- Oracle translated locale and time zone names 8.7.7
- supported locale resources 8.6.2
- globalization features 1.2
- globalization support
- architecture 1.1
- Greenwich Mean Time 4.2.1.3, 4.2.1.4
- guessing the language or character set 11.4
I
- IANA character sets
- mapping with ISO locales 8.6.6
- ideographic writing systems, encoding 2.1.2.2
- ignorable characters 5.4.2
- implicit datatype conversion 7.2.4
- indexes
- initialization parameter
- DST_UPGRADE_INSERT_CONV 4.5.4
- initialization parameters
- INSTR SQL functions 7.2.6
- Internet application
- interval data types 4.2, 4.2.2
- inserting values 4.2.2.3
- ISO 8859 character sets 2.1.3.1
- ISO locales
- mapping with IANA character sets 8.6.6
- ISO standard
- date format 9.3.2
- ISO standard date format 3.7.1.2, 9.3.2
- ISO week number 9.3.2
- IW format element 9.3.2
- IY format element 9.3.2
L
- language
- detecting with Globalization Development Kit 8.7.6
- language abbreviations A.1
- Language and Character Set File Scanner 11.4
- language definition
- languages
- error messages A.2
- languages and character sets
- supported by LCSSCAN A.5
- language support 1.2.1
- LAST_DAY SQL function 4.4
- LCSCCAN
- error messages 11.4.5
- LCSSCAN 11.4
- LCSSCAN command
- length semantics 2.2, 3.12
- LIKE conditions in SQL statements 9.2.3
- linguistic collation
- linguistic collation definitions
- supported A.6
- linguistic comparisons 5.6
- linguistic indexes 5.7
- linguistic sorts
- list parameter 3.8
- lmsgen utility 10.9
- loading external BFILE data into LOBs 9.3.4
- LOBs
- locale 3.2
- locale-charset-map 8.8.1
- locale-determine-rule 8.8.4
- locale information
- mapping between Oracle and other standards 10.4
- locale-parameter-name 8.8.5
- LOCALTIMESTAMP SQL function 4.4
M
- message-bundles 8.8.6
- migration
- character sets 11.1
- mixed character sets
- causing data loss 11.1.2.2
- monetary parameters 3.9
- monolingual Internet application 8.2.1
- monolingual linguistic collations
- supported A.6
- monolingual linguistic sorts
- example 5.5.3
- months
- MONTHS_BETWEEN SQL function 4.4
- multibyte encoding schemes 2.1.4.2
- multilexers
- creating 6.5.4.1
- multilingual data
- specifying column lengths 6.5.1
- multilingual document search
- creating indexes 6.5.4
- multilingual Internet application 8.2.2
- multilingual linguistic collations
- supported A.6
- multilingual linguistic sorts
- example 5.5.3
- multiple languages
N
- national character set 2.3.8, 6.3.2, 7.2.1.1, 7.2.1.2
- NCHAR data type
- creating abstract data type 2.3.9
- NCLOB datatype 7.2.1.3
- NEW_TIME SQL function 4.4
- NEXT_DAY SQL function 4.4
- NLB data
- transportable 12.10
- NLB file 12.1.3.1
- NLB files 12.1
- generating and installing 12.7
- NLS_CALENDAR parameter 3.7.2
- NLS_COMP parameter 3.10.2
- NLS_CREDIT parameter 3.9.7
- NLS_CURRENCY parameter 3.9.2
- NLS_DATE_FORMAT initialization parameter 4.5.1
- NLS_DATE_FORMAT parameter 3.6.1.1
- NLS_DATE_LANGUAGE parameter 3.6.1.2
- NLS_DEBIT parameter 3.9.8
- NLS_DUAL_CURRENCY parameter 3.9.4
- NLS_ISO_CURRENCY parameter 3.9.3
- NLS_LANG parameter 3.2
- NLS_LENGTH_SEMANTICS initialization parameter 2.2
- NLS_LENGTH_SEMANTICS session parameter 2.2
- NLS_LIST_SEPARATOR parameter 3.11
- NLS_MONETARY_CHARACTERS parameter 3.9.6
- NLS_NCHAR_CONV_EXCP parameter 3.11.1
- NLS_NUMERIC_CHARACTERS parameter 3.8.2
- NLS_SORT parameter 3.10.1
- NLS_TERRITORY parameter 3.5.2
- NLS_TIMESTAMP_FORMAT initialization parameter 4.5.1
- NLS_TIMESTAMP_TZ_FORMAT initialization parameter 4.5.1
- NLS Calendar Utility 12.12
- NLS parameters
- NLSRTL 1.1.1
- NLS Runtime Library 1.1.1
- NLSSORT SQL function 9.2.5
- syntax 9.2.5.1
- NLT files 12.1
- numbers, encoding 2.1.2.3
- numeric formats 3.8.1
- SQL masks 9.3.3
- numeric parameters 3.8
- NUMTODSINTERVAL SQL function 4.4
- NUMTOYMINTERVAL SQL function 4.4
- NVARCHAR datatype
- Pro*C/C++ 7.4.3
O
- obsolete character sets A.9.4
- OCI
- OCI_UTF16ID character set ID 7.3.1
- OCI and Unicode 7.1.1
- OCI character set conversion 7.3.2.2
- OCICharSetConvert() 10.7
- OCI client applications
- using Unicode character sets 7.3.3
- OCI data conversion
- data expansion 7.3.2.3
- OCINlsCharSetIdToName() 10.3
- OCINlsCharSetNameTold() 10.3
- OCINlsEnvironmentVariableGet() 10.3
- OCINlsGetInfo() 10.3
- OCINlsNumericInfoGet() 10.3
- OCIWideCharIsUpper() 10.7
- ODBC Unicode applications 7.6.4
- OLE DB Unicode datatypes 7.6.5
- operating system
- character set compatibility with applications 2.3.2
- ORA_DST_AFFECTED SQL function 4.4
- ORA_DST_CONVERT SQL function 4.4
- ORA_DST_ERROR SQL function 4.4
- ORA_SDTZ environment variable 4.5.2
- ORA_TZFILE environment variable 4.5.2
- Oracle Call Interface and Unicode 7.1.1
- Oracle Data Provide for .NET and Unicode 7.1.1
- Oracle Data Pump and character set conversion 11.1.2.3
- Oracle Language and Character Set Detection Java classes 8.7.6
- Oracle Locale Builder
- choosing a calendar format 12.3
- choosing currency formats 12.3
- choosing date and time formats 12.3
- displaying code chart 12.4
- Existing Definitions dialog box 12.1.3.1
- Open File dialog box 12.1.3.4
- Preview NLT screen 12.1.3.3
- restrictions on names for locale objects 12.2
- Session Log dialog box 12.1.3.2
- starting 12.1.2
- Oracle ODBC driver and Unicode 7.1.1
- Oracle OLE DB driver and Unicode 7.1.1
- Oracle Pro*C/C++ and Unicode 7.1.1
- ORDER BY clause 9.2.5.3
- overriding language and territory definitions 3.2.2
P
- page-charset 8.8.2
- parameters
- BLANK_TRIMMING 11.1.1.1
- calendar 3.7
- character set conversion 3.11
- linguistic sorts 3.10
- methods of setting 3.1
- monetary 3.9
- NLS_CALENDAR 3.7.2
- NLS_COMP 3.10.2
- NLS_CREDIT 3.9.7
- NLS_CURRENCY 3.9.2
- NLS_DATE_FORMAT 3.6.1.1
- NLS_DATE_LANGUAGE 3.6.1.2
- NLS_DEBIT 3.9.8
- NLS_DUAL_CURRENCY 3.9.4
- NLS_ISO_CURRENCY 3.9.3
- NLS_LANG 3.2
- NLS_LIST_SEPARATOR 3.11
- NLS_MONETARY_CHARACTERS 3.9.6
- NLS_NCHAR_CONV_EXCP 3.11.1
- NLS_NUMERIC_CHARACTERS 3.8.2
- NLS_SORT 3.10.1
- NLS_TERRITORY 3.5.2
- numeric 3.8
- time and date 3.6
- performance
- phonetic writing systems, encoding 2.1.2.1
- PL/SQL and SQL and Unicode 7.1.1
- primary level sort 5.3.2.1.1
- Private Use Area 12.5.3
- Pro*C/C++
- punctuation, encoding 2.1.2.3
R
S
- searching multilingual documents 6.5.4
- searching string 5.8
- secondary level sort 5.3.2.1.2
- session time zone 4.10
- SESSIONTIMEZONE SQL function 4.4
- shift-sensitive variable-width multibyte encoding schemes 2.1.4.2
- single-byte encoding schemes 2.1.4.1
- sorting
- space padding
- during export 11.1.1.1
- special combination letters 5.4.4, 5.4.11
- special letters 5.4.5, 5.4.10
- special lowercase letters 5.4.13
- special uppercase letters 5.4.12
- SQL CHAR datatypes 2.3
- OCI 7.3.4
- SQL function
- SQL functions
- ADD_MONTHS 4.4
- CONVERT 9.2.1
- CURRENT_DATE 4.4
- CURRENT_TIMESTAMP 4.4
- datatype conversion 7.2.5
- DBTIMEZONE 4.4
- default values for NLS parameters 9.1.1
- EXTRACT (datetime) 4.4
- FROM_TZ 4.4
- INSTR 7.2.6
- LAST_DAY 4.4
- LOCALTIMESTAMP 4.4
- MONTHS_BETWEEN 4.4
- NEW_TIME 4.4
- NEXT_DAY 4.4
- NLSSORT 9.2.5
- NUMTODSINTERVAL 4.4
- NUMTOYMINTERVAL 4.4
- ROUND (date) 4.4
- RPAD 7.2.6
- SESSIONTIMEZONE 4.4
- specifying NLS parameters 9.1.2
- SYS_EXTRACT_UTC 4.4
- SYSDATE 4.4
- SYSTIMESTAMP 4.4
- TO_CHAR (datetime) 4.4
- TO_DSINTERVAL 4.4
- TO_TIMESTAMP 4.4
- TO_TIMESTAMP_TZ 4.4
- TO_YMINTERVAL 4.4
- TRUNC (date) 4.4
- TZ_OFFSET 4.4
- unacceptable NLS parameters 9.1.3
- SQL NCHAR datatypes
- binding and defining in OCI 7.3.5
- SQL statements
- LIKE conditions 9.2.3
- strict superset 6.2.2.1
- string comparisons
- WHERE clause 9.2.5.2
- string literals
- Unicode 7.2.7
- string manipulation using OCI 10.5
- strings
- searching 5.8
- superset, strict 6.2.2.1
- supersets and subsets A.4.7
- supplementary characters 5.3.2
- linguistic collation support A.6
- supported datatypes 2.3.9
- supported territories A.3
- syllabary 2.1.2.2
- symbols, encoding 2.1.2.3
- SYS_EXTRACT_UTC SQL function 4.4
- SYSDATE SQL function 4.4
- SYSTIMESTAMP SQL function 4.4
T
- territory
- dependencies 3.2.3
- territory definition 3.5.2
- territory support 1.2.2, A.3
- territory variant 3.2.3
- tertiary level sort 5.3.2.1.3
- Thai and Laotian character rearrangement 5.4.9
- tilde 7.5.7.1
- time and date parameters 3.6
- TIMESTAMP data type
- when to use 4.2.1.6
- TIMESTAMP data types
- choosing 4.2.1.6
- timestamp format 3.6.2.1
- TIMESTAMP WITH LOCAL TIME ZONE data type
- when to use 4.2.1.6
- TIMESTAMP WITH TIME ZONE data type
- when to use 4.2.1.6
- time zone
- time zone file
- time zones
- TO_CHAR (datetime) SQL function 4.4
- TO_CHAR SQL function
- TO_DATE SQL function
- TO_DSINTERVAL SQL function 4.4
- TO_NUMBER SQL function
- format masks 9.3.1
- TO_TIMESTAMP_TZ SQL function 4.4
- TO_TIMESTAMP SQL function 4.4
- TO_YMINTERVAL SQL function 4.4
- transportable NLB data 12.10
- TRUNC (date) SQL function 4.4
- TZ_OFFSET SQL function 4.4
- TZABBREV 4.6
- TZNAME 4.6
U
- UCS-2 encoding 6.2.2.3
- Unicode 6.1
- binding and defining Java strings 7.5.1
- character code assignments B.1
- character set conversion between OCI client and database server 7.3.2
- code ranges for UTF-16 characters B.1
- code ranges for UTF-8 characters B.1
- data conversion in Java 7.5.5
- encoding 6.2.2
- fonts 12.1.1
- JDBC OCI driver 7.1.1
- JDBC programming 7.5
- JDBC Server Side internal driver 7.1.1
- JDBC Server Side thin driver 7.1.1
- JDBC thin driver 7.1.1
- mode 7.3.1
- ODBC and OLE DB programming 7.6
- Oracle Call Interface 7.1.1
- Oracle Data Provide for .NET 7.1.1
- Oracle ODBC driver 7.1.1
- Oracle OLE DB driver 7.1.1
- Oracle Pro*C/C++ 7.1.1
- Oracle support 6.2.3
- parsing an XML stream with Java 7.7.3
- PL/SQL and SQL 7.1.1
- Private Use Area 12.5.3
- programming 7.1
- reading an XML file with Java 7.7.2
- string literals 7.2.7
- UCS-2 encoding 6.2.2.3
- UTF-16 encoding 6.2.2.2
- UTF-8 encoding 6.2.2.1
- writing an XML file with Java 7.7.1
- XML programming 7.7
- Unicode database 6.3.1
- case study 6.4
- Unicode datatypes 6.3.2
- case study 6.4
- upgrade
- url-rewrite-rule 8.8.7
- US7ASCII
- supersets A.4.7
- user-defined characters 12.5.1
- UTC 4.2.1.3, 4.2.1.4
- UTF-16 encoding 6.2.2.2, B.2
- UTF8 character set 6.3.1, A.4.5
- UTF-8 encoding 6.2.2.1, B.3
- UTFE character set 6.2.3, A.4.5