1. Index

Index

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

Numerics

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
    • case-insensitive and accent-insensitive 5.5.2
    • example 5.5.3
  • 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
  • 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
    • available in all Oracle database character sets 2.1.3
    • context-sensitive 5.4.6
    • contracting 5.4.4
    • user-defined 12.5.1
  • character semantics 2.2, 3.12.1
  • character set
    • conversion 12.5.2
    • data loss
      • during conversion 2.3.3
    • detecting with Globalization Development Kit 8.7.6
    • national 7.2.1.2
  • character set conversion
    • between OCI client and database server 7.3.2
    • parameters 3.11
  • character set definition
  • character set encodings for conversion only A.4.6
  • character set migration
    • identifying character data conversion problems 11.2
    • scanning character data 11.2
  • character sets
  • character snational 2.3.8
  • character type conversion
  • 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
  • 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
  • CURRENT_DATE SQL function 4.4
  • CURRENT_TIMESTAMP SQL function 4.4

D

  • database character set
    • character data conversion 11.2
    • choosing 2.3
    • compatibility between client operating system and applications 2.3.2
    • performance 2.3.4
  • 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
    • collation derivation C
    • collation derivation and determination rules for SQL operations C
    • collation determination C
  • data conversion
  • data expansion
    • during character set migration 11.1.1
    • during data conversion 7.3.2.3
  • data inconsistencies causing data loss 11.1.2.2
  • data loss
    • caused by data inconsistencies 11.1.2.2
    • during character set conversion 2.3.3
    • during character set migration 11.1.2.1
    • during datatype conversion
    • during OCI Unicode character set conversion 7.3.2.1
    • from mixed character sets 11.1.2.2
  • Data Pump PL/SQL packages and character set migration 11.1.2.3
  • data truncation 11.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
  • 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
  • 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

H

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
    • creating for documents stored as CLOBs 6.5.4.2
    • creating for multilingual document search 6.5.4
    • creating indexes for documents stored as BLOBs 6.5.4.3
    • linguistic 5.7
  • initialization parameter
    • DST_UPGRADE_INSERT_CONV 4.5.4
  • initialization parameters
    • NLS_DATE_FORMAT 4.5.1
    • NLS_TIMESTAMP_FORMAT 4.5.1
    • NLS_TIMESTAMP_TZ_FORMAT 4.5.1
  • INSTR SQL functions 7.2.6
  • Internet application
  • interval data types 4.2, 4.2.2
  • ISO 8859 character sets 2.1.3.1
  • ISO locales
    • mapping with IANA character sets 8.6.6
  • ISO standard
  • 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

J

  • Java
    • Unicode data conversion 7.5.5
  • Java strings
    • binding and defining in Unicode 7.5.1
  • JDBC OCI driver
  • JDBC programming
  • JDBC Server Side internal driver
  • JDBC Server Side thin driver
  • JDBC thin driver

K

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
  • LCSSCAN 11.4
    • supported languages and character sets 11.4.4, A.5
  • LCSSCAN command
  • length semantics 2.2, 3.12
  • LIKE conditions in SQL statements 9.2.3
  • linguistic collation
    • accent-insensitive collation 5.5
    • case-insensitive collation 5.5
    • overview 5.3
  • 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
    • loading external BFILE data 9.3.4
    • storing documents in multiple languages 6.5.3
  • locale 3.2
    • dependencies 3.2.3
    • of Internet application
    • variant 3.2.3
  • 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
  • monetary parameters 3.9
  • monolingual Internet application 8.2.1
  • monolingual linguistic collations
    • supported A.6
  • monolingual linguistic sorts
  • months
  • MONTHS_BETWEEN SQL function 4.4
  • multibyte encoding schemes 2.1.4.2
  • multilexers
  • multilingual data
    • specifying column lengths 6.5.1
  • multilingual document search
  • multilingual Internet application 8.2.2
  • multilingual linguistic collations
    • supported A.6
  • multilingual linguistic sorts
  • multiple languages
    • designing database schemas 6.5
    • storing data 6.5.2
    • storing documents in LOBs 6.5.3

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
  • 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
    • default values in SQL functions 9.1.1
    • list 3.1
    • setting 3.1
    • specifying in SQL functions 9.1.2
    • unacceptable in SQL functions 9.1.3
  • NLSRTL 1.1.1
  • NLS Runtime Library 1.1.1
  • NLSSORT SQL function 9.2.5
  • NLT files 12.1
  • numbers, encoding 2.1.2.3
  • numeric formats 3.8.1
  • numeric parameters 3.8
  • NUMTODSINTERVAL SQL function 4.4
  • NUMTOYMINTERVAL SQL function 4.4
  • NVARCHAR datatype

O

  • obsolete character sets A.9.4
  • OCI
    • binding and defining CLOB and NCLOB data in OCI 7.3.7
    • binding and defining SQL NCHAR datatypes 7.3.5
    • SQL CHAR datatypes 7.3.4
  • 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
  • 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

R

  • regular expressions
    • character class 5.9.3
    • character range 5.9.1
    • collation element delimiter 5.9.2
    • equivalence class 5.9.4
    • examples 5.9.5
    • multilingual environment 5.9
  • replacement characters
    • CONVERT SQL function 9.2.1
  • restrictions
  • reverse secondary sorting 5.4.8
  • ROUND (date) SQL function 4.4
  • RPAD SQL function 7.2.6

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
    • reverse secondary 5.4.8
    • specifying nondefault linguistic sorts 3.10.1
  • space padding
  • 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
  • SQL function
    • ORA_DST_AFFECTED 4.4
    • ORA_DST_CONVERT 4.4
    • ORA_DST_ERROR 4.4
  • 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
  • strict superset 6.2.2.1
  • string comparisons
  • string literals
  • 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
  • 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
  • TIMESTAMP data types
  • timestamp format 3.6.2.1
  • TIMESTAMP WITH LOCAL TIME ZONE data type
  • TIMESTAMP WITH TIME ZONE data type
  • time zone
  • time zone file
  • time zones
    • converting 4.11
    • upgrading time zone file 4.7
  • 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
  • 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
    • Daylight Saving Time 4.5.4
    • time zone data upgrade overview 4.7
    • time zone data upgrade using the DBMS_DST package 4.7.2
    • time zone data upgrade using the utltz_* scripts 4.7.1
  • url-rewrite-rule 8.8.7
  • US7ASCII
  • user-defined characters 12.5.1
    • adding to a character set definition 12.5.6
    • cross-references between character sets 12.5.4
  • 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

V

  • VARCHAR datatype
  • variable-width multibyte encoding schemes 2.1.4.2

W

X

  • XML
    • parsing in Unicode with Java 7.7.3
    • reading in Unicode with Java 7.7.2
    • writing in Unicode with Java 7.7.1
  • XML programming