Index

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

Numerics

  • 7-bit encoding schemes 1
  • 8-bit encoding schemes 1

A

  • abbreviations
    • languages 1
  • abstract data type
    • creating as NCHAR 1
  • accent 1
  • accent-insensitive linguistic sort 1
  • ADD_MONTHS SQL function 1
  • ADO interface and Unicode 1
  • AL16UTF16 character set 1 , 2
  • AL24UTFFSS character set 1
  • AL32UTF8 character set 1 , 2 , 3
  • ALTER SESSION statement
    • SET NLS_CURRENCY clause 1 , 2
    • SET NLS_LANGUAGE clause 1
    • SET NLS_NUMERIC_CHARACTERS clause 1
    • SET NLS_TERRITORY clause 1
  • application-locales 1
  • ASCII encoding 1

B

  • base letters 1 , 2
  • BFILE data
    • loading into LOBs 1
  • binary sorts
    • case-insensitive and accent-insensitive 1
    • example 1
  • binding and defining CLOB and NCLOB data in OCI 1
  • binding and defining SQL CHAR datatypes in OCI 1
  • binding and defining SQL NCHAR datatypes in OCI 1
  • BLANK_TRIMMING parameter 1
  • BLOBs
    • creating indexes 1
  • byte semantics 1 , 2

C

  • calendars
    • customizing 1
    • parameter 1
    • supported 1
  • Calendar Utility 1
  • canonical equivalence 1 , 2
  • case 1
  • case-insensitive linguistic collation 1
  • case-sensitive linguistic collation 1
  • case sensitivity 1
  • CESU-8 compliance 1
  • character data
    • converting with CONVERT SQL function 1
  • character data conversion
    • database character set 1
  • character data scanning
    • before character set migration 1
  • character rearrangement 1
  • character repertoire 1
  • characters
    • available in all Oracle database character sets 1
    • context-sensitive 1
    • contracting 1
    • user-defined 1
  • character semantics 1 , 2
  • character set
    • conversion 1
    • data loss
      • during conversion 1
    • detecting with Globalization Development Kit 1
    • national 1
  • character set conversion
    • between OCI client and database server 1
    • parameters 1
  • character set definition
    • customizing 1
    • guidelines for editing files 1
    • naming files 1
  • character set migration
    • identifying character data conversion problems 1
    • scanning character data 1
  • character sets
    • AL16UTF16 1
    • AL24UTFFSS 1
    • AL32UTF8 1
    • ASCII 1
    • changing after database creation 1
    • choosing 1
    • conversion 1 , 2 , 3
    • conversion using OCI 1
    • customizing 1
    • data loss 1
    • EBCDIC 1
    • encoding 1
    • ISO 8859 series 1
    • migration 1 , 2
    • naming 1
    • national 1 , 2
    • other ASCII-based 1
    • other EBCDIC-based 1
    • restrictions on character sets used to express names 1
    • supersets and subsets 1
    • supported 1
    • supporting different character repertoires 1
    • universal 1
    • UTFE 1
  • character snational 1
  • character type conversion
    • error reporting 1
  • choosing a character set 1
  • client operating system
    • character set compatibility with applications 1
  • CLOB and NCLOB data
    • binding and defining in OCI 1
  • CLOBs
    • creating indexes 1
  • C number format mask 1
  • code chart
    • displaying and printing 1
  • code point 1
  • collation
    • case-insensitive 1
    • case-sensitive 1
    • customizing 1
    • Hiragana and Katakana 1
    • linguistic 1
    • monolingual 1
    • multilingual 1
    • Unicode Collation Algorithm 1
  • column-level collation 1
  • comparisons
    • linguistic 1
  • compatibility
    • client operating system and application character sets 1
  • composed characters 1
  • context-sensitive characters 1
  • contracting characters 1
  • contracting letters 1
  • control characters, encoding 1
  • conversion
    • between character set ID number and character set name 1
  • converting character data
    • CONVERT SQL function 1
  • converting character data between character sets 1
  • CONVERT SQL function
    • character sets 1
  • convert time zones 1
  • Coordinated Universal Time 1 , 2
  • creating a database with Unicode datatypes 1
  • creating a Unicode database 1
  • CSREPAIR script 1
  • currencies
    • formats 1
  • CURRENT_DATE SQL function 1
  • CURRENT_TIMESTAMP SQL function 1

D

  • database character set
    • character data conversion 1
    • choosing 1
    • compatibility between client operating system and applications 1
    • performance 1
  • Database Migration Assistant for Unicode (DMU) 1
  • database schemas
    • designing for multiple languages 1
  • database time zone 1
  • data-bound collation
    • collation derivation 1
    • collation derivation and determination rules for SQL operations 1
    • collation determination 1
  • data conversion
    • in Pro*C/C++ 1
    • OCI driver 1
    • ODBC and OLE DB drivers 1
    • thin driver 1
    • Unicode Java strings 1
  • data expansion
    • during character set migration 1
    • during data conversion 1
  • data inconsistencies causing data loss 1
  • data loss
    • caused by data inconsistencies 1
    • during character set conversion 1
    • during character set migration 1
    • during datatype conversion
      • exceptions 1
    • during OCI Unicode character set conversion 1
    • from mixed character sets 1
  • Data Pump PL/SQL packages and character set migration 1
  • data truncation
    • restrictions 1
  • datatype conversion
    • data loss and exceptions 1
    • implicit 1
    • SQL functions 1
  • data types
    • abstract 1
    • datetime 1
    • inserting values into datetime data types 1
    • inserting values into interval data types 1
    • interval 1 , 2
    • supported 1
  • date and time parameters 1
  • date formats
    • and partition bound expressions 1
  • dates
    • ISO standard 1 , 2
    • NLS_DATE_LANGUAGE parameter 1
  • datetime data types
    • inserting values 1
  • datetime format parameters 1
  • Daylight Saving Time
    • Oracle support 1
    • rules 1
  • Daylight Saving Time Upgrade parameter 1
  • days
    • format element 1
    • language of names 1
  • DBTIMEZONE SQL function 1
  • dest_char_set parameter 1
  • detecting language and character sets
    • Globalization Development Kit 1
  • detection
    • supported languages and character sets 1
  • diacritic 1
  • DMU
    • Database Migration Assistant for Unicode 1
  • DST_UPGRADE_INSERT_CONV inititialization parameter 1
  • DUCET (Default Unicode Collation Element Table) 1

E

  • encoding
    • control characters 1
    • ideographic writing systems 1
    • numbers 1
    • phonetic writing systems 1
    • punctuation 1
    • symbols 1
  • encoding schemes
    • 7-bit 1
    • 8-bit 1
    • fixed-width 1
    • multibyte 1
    • shift-sensitive variable-width 1
    • shift-sensitive variable-width multibyte 1
    • single-byte 1
    • variable-width 1
  • environment variables
    • ORA_SDTZ 1
    • ORA_TZFILE 1
  • error messages
    • languages 1
    • translation 1
  • euro
    • Oracle support 1
  • expanding characters
    • characters
      • expanding 1
  • EXTRACT (datetime) SQL function 1

F

  • fixed-width multibyte encoding schemes 1
  • fonts
    • Unicode 1
  • format elements
    • C 1
    • D 1
    • day 1
    • G 1
    • IW 1
    • IY 1
    • L 1
    • month 1
    • RM 1
    • RN 1
  • format masks 1 , 2
  • formats
    • currency 1
    • date 1 , 2
    • numeric 1
    • time 1
  • FROM_TZ SQL function 1

G

  • GDK application configuration file
    • example 1
  • GDK application framework for J2EE 1
  • GDK components 1
  • GDK error messages 1
  • GDK Java API 1
  • GDK Java supplied packages and classes 1
  • GDK Localizer object 1
  • Globalization Development Kit
    • application configuration file 1
    • character set conversion 1
    • components 1
    • defining supported application locales 1
    • e-mail programs 1
    • error messages 1
    • framework 1
    • integrating locale sources 1
    • Java API 1
    • Java supplied packages and classes 1
    • locale detection 1
    • Localizer object 1
    • managing localized content in static files 1
    • managing strings in JSPs and Java servlets 1
    • non_ASCII input and output in an HTML page 1
    • Oracle binary and linguistic sorts 1
    • Oracle date, number, and monetary formats 1
    • Oracle language and character set detection 1
    • Oracle locale information 1
    • Oracle locale mapping 1
    • Oracle translated locale and time zone names 1
    • supported locale resources 1
  • globalization features 1
  • globalization support
    • architecture 1
  • Greenwich Mean Time 1 , 2
  • guessing the language or character set 1

H

  • Hiragana 1

I

  • IANA character sets
    • mapping with ISO locales 1
  • ideographic writing systems, encoding 1
  • ignorable characters 1
  • implicit datatype conversion 1
  • indexes
    • creating for documents stored as CLOBs 1
    • creating for multilingual document search 1
    • creating indexes for documents stored as BLOBs 1
    • linguistic 1
  • initialization parameter
    • DST_UPGRADE_INSERT_CONV 1
  • initialization parameters
    • NLS_DATE_FORMAT 1
    • NLS_TIMESTAMP_FORMAT 1
    • NLS_TIMESTAMP_TZ_FORMAT 1
  • INSTR SQL functions 1
  • Internet application
    • locale
      • determination 1
    • monolingual 1 , 2
    • multilingual 1 , 2
  • interval data types
    • inserting values 1
  • ISO 8859 character sets 1
  • ISO locales
    • mapping with IANA character sets 1
  • ISO standard
    • date format 1
  • ISO standard date format 1 , 2
  • ISO week number 1
  • IW format element 1
  • IY format element 1

J

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

K

  • Katakana 1

L

  • language
    • detecting with Globalization Development Kit 1
  • language abbreviations 1
  • Language and Character Set File Scanner 1
  • language definition
    • customizing 1
    • overriding 1
  • languages
    • error messages 1
  • languages and character sets
    • supported by LCSSCAN 1
  • language support 1
  • LAST_DAY SQL function 1
  • LCSCCAN
    • error messages 1
  • LCSSCAN
    • supported languages and character sets 1 , 2
  • LCSSCAN command
    • BEGIN parameter 1
    • END parameter 1
    • examples 1
    • FILE parameter 1
    • HELP parameter 1
    • online help 1
    • RESULTS parameter 1
  • length semantics 1 , 2
  • LIKE conditions in SQL statements 1
  • linguistic collation definitions
    • supported 1
  • linguistic comparisons 1
  • linguistic indexes 1
  • linguistic sorts
    • accent-insensitive 1
    • BINARY 1
    • BINARY_AI, linguistic sorts
      • BINARY_CI 1
    • case-insensitive 1
    • controlling 1
    • customizing
      • characters with diacritics 1 , 2
    • levels 1
    • list of defaults 1
    • parameters 1
  • list parameter 1
  • lmsgen utility 1
  • loading external BFILE data into LOBs 1
  • LOBs
    • loading external BFILE data 1
    • storing documents in multiple languages 1
  • locale
    • dependencies 1
    • of Internet application
      • determining 1
    • variant 1
  • locale-charset-map 1
  • locale-determine-rule 1
  • locale information
    • mapping between Oracle and other standards 1
  • locale-parameter-name 1
  • LOCALTIMESTAMP SQL function 1

M

  • message-bundles 1
  • migration
    • character sets 1
  • mixed character sets
    • causing data loss 1
  • monetary parameters 1
  • monolingual Internet application 1
  • monolingual linguistic collations
    • supported 1
  • monolingual linguistic sorts
    • example 1
  • months
    • format element 1
    • language of names 1
  • MONTHS_BETWEEN SQL function 1
  • multibyte encoding schemes
    • fixed-width 1
    • shift-sensitive variable-width 1
    • variable-width 1
  • multilexers
    • creating 1
  • multilingual data
    • specifying column lengths 1
  • multilingual document search
    • creating indexes 1
  • multilingual Internet application 1
  • multilingual linguistic collations
    • supported 1
  • multilingual linguistic sorts
    • example 1
  • multiple languages
    • designing database schemas 1
    • storing data 1
    • storing documents in LOBs 1

N

  • national character set 1 , 2 , 3 , 4
  • NCHAR data type
    • creating abstract data type 1
  • NCLOB datatype 1
  • NEW_TIME SQL function 1
  • NEXT_DAY SQL function 1
  • NLB data
    • transportable 1
  • NLB file 1
  • NLB files
    • generating and installing 1
  • NLS_CALENDAR parameter 1
  • NLS_COMP parameter 1
  • NLS_CREDIT parameter 1
  • NLS_CURRENCY parameter 1
  • NLS_DATE_FORMAT initialization parameter 1
  • NLS_DATE_FORMAT parameter 1
  • NLS_DATE_LANGUAGE parameter 1
  • NLS_DEBIT parameter 1
  • NLS_DUAL_CURRENCY parameter 1
  • NLS_ISO_CURRENCY parameter 1
  • NLS_LANG parameter
    • choosing a locale 1
    • client setting 1
    • examples 1
    • OCI client applications 1
    • specifying 1
    • UNIX client 1
    • Windows client 1
  • NLS_LENGTH_SEMANTICS initialization parameter 1
  • NLS_LENGTH_SEMANTICS session parameter 1
  • NLS_LIST_SEPARATOR parameter 1
  • NLS_MONETARY_CHARACTERS parameter 1
  • NLS_NCHAR_CONV_EXCP parameter 1
  • NLS_NUMERIC_CHARACTERS parameter 1
  • NLS_SORT parameter 1
  • NLS_TERRITORY parameter 1
  • NLS_TIMESTAMP_FORMAT initialization parameter 1
  • NLS_TIMESTAMP_TZ_FORMAT initialization parameter 1
  • NLS Calendar Utility 1
  • NLS parameters
    • default values in SQL functions 1
    • list 1
    • setting 1
    • specifying in SQL functions 1
    • unacceptable in SQL functions 1
  • NLSRTL 1
  • NLS Runtime Library 1
  • NLSSORT SQL function
    • syntax 1
  • NLT files 1
  • numbers, encoding 1
  • numeric formats
    • SQL masks 1
  • numeric parameters 1
  • NUMTODSINTERVAL SQL function 1
  • NUMTOYMINTERVAL SQL function 1
  • NVARCHAR datatype
    • Pro*C/C++ 1

O

  • obsolete character sets 1
  • OCI
    • binding and defining CLOB and NCLOB data in OCI 1
    • binding and defining SQL NCHAR datatypes 1
    • SQL CHAR datatypes 1
  • OCI_UTF16ID character set ID 1
  • OCI and Unicode 1
  • OCI character set conversion
    • data loss 1
    • performance 1
  • OCICharSetConvert() 1
  • OCI client applications
    • using Unicode character sets 1
  • OCI data conversion
    • data expansion 1
  • OCINlsCharSetIdToName() 1
  • OCINlsCharSetNameTold() 1
  • OCINlsEnvironmentVariableGet() 1
  • OCINlsGetInfo() 1
  • OCINlsNumericInfoGet() 1
  • OCIWideCharIsUpper() 1
  • ODBC Unicode applications 1
  • OLE DB Unicode datatypes 1
  • operating system
    • character set compatibility with applications 1
  • ORA_DST_AFFECTED SQL function 1
  • ORA_DST_CONVERT SQL function 1
  • ORA_DST_ERROR SQL function 1
  • ORA_SDTZ environment variable 1
  • ORA_TZFILE environment variable 1
  • Oracle Call Interface and Unicode 1
  • Oracle Data Provide for .NET and Unicode 1
  • Oracle Data Pump and character set conversion 1
  • Oracle Language and Character Set Detection Java classes 1
  • Oracle Locale Builder
    • choosing a calendar format 1
    • choosing currency formats 1
    • choosing date and time formats 1
    • displaying code chart 1
    • Existing Definitions dialog box 1
    • Open File dialog box 1
    • Preview NLT screen 1
    • restrictions on names for locale objects 1
    • Session Log dialog box 1
    • starting 1
  • Oracle ODBC driver and Unicode 1
  • Oracle OLE DB driver and Unicode 1
  • Oracle Pro*C/C++ and Unicode 1
  • ORDER BY clause 1
  • overriding language and territory definitions 1

P

  • page-charset 1
  • parameters
    • BLANK_TRIMMING 1
    • calendar 1
    • character set conversion 1
    • linguistic sorts 1
    • methods of setting 1
    • monetary 1
    • NLS_CALENDAR 1
    • NLS_COMP 1
    • NLS_CREDIT 1
    • NLS_CURRENCY 1
    • NLS_DATE_FORMAT 1
    • NLS_DATE_LANGUAGE 1
    • NLS_DEBIT 1
    • NLS_DUAL_CURRENCY 1
    • NLS_ISO_CURRENCY 1
    • NLS_LANG 1
    • NLS_LIST_SEPARATOR 1
    • NLS_MONETARY_CHARACTERS 1
    • NLS_NCHAR_CONV_EXCP 1
    • NLS_NUMERIC_CHARACTERS 1
    • NLS_SORT 1
    • NLS_TERRITORY 1
    • numeric 1
    • time and date 1
  • performance
    • choosing a database character set 1
    • during OCI Unicode character set conversion 1
  • phonetic writing systems, encoding 1
  • PL/SQL and SQL and Unicode 1
  • primary level sort 1
  • Private Use Area 1
  • Pro*C/C++
    • data conversion 1
    • NVARCHAR datatype 1
    • VARCHAR datatype 1
  • punctuation, encoding 1

R

  • regular expressions
    • character class 1
    • character range 1
    • collation element delimiter 1
    • equivalence class 1
    • examples 1
    • multilingual environment 1
  • replacement characters
    • CONVERT SQL function 1
  • restrictions
    • data truncation 1
    • passwords 1
    • space padding during export 1
    • usernames 1
  • reverse secondary sorting 1
  • ROUND (date) SQL function 1
  • RPAD SQL function 1

S

  • searching multilingual documents 1
  • searching string 1
  • secondary level sort 1
  • session time zone 1
  • SESSIONTIMEZONE SQL function 1
  • shift-sensitive variable-width multibyte encoding schemes 1
  • single-byte encoding schemes 1
  • sorting
    • reverse secondary 1
    • specifying nondefault linguistic sorts 1
  • source_char_set parameter 1
  • space padding
    • during export 1
  • special combination letters 1 , 2
  • special letters 1 , 2
  • special lowercase letters 1
  • special uppercase letters 1
  • SQL CHAR datatypes
    • OCI 1
  • SQL function
    • ORA_DST_AFFECTED 1
    • ORA_DST_CONVERT 1
    • ORA_DST_ERROR 1
  • SQL functions
    • ADD_MONTHS 1
    • CONVERT 1
    • CURRENT_DATE 1
    • CURRENT_TIMESTAMP 1
    • datatype conversion 1
    • DBTIMEZONE 1
    • default values for NLS parameters 1
    • EXTRACT (datetime) 1
    • FROM_TZ 1
    • INSTR 1
    • LAST_DAY 1
    • LOCALTIMESTAMP 1
    • MONTHS_BETWEEN 1
    • NEW_TIME 1
    • NEXT_DAY 1
    • NLSSORT 1
    • NUMTODSINTERVAL 1
    • NUMTOYMINTERVAL 1
    • ROUND (date) 1
    • RPAD 1
    • SESSIONTIMEZONE 1
    • specifying NLS parameters 1
    • SYS_EXTRACT_UTC 1
    • SYSDATE 1
    • SYSTIMESTAMP 1
    • TO_CHAR (datetime) 1
    • TO_DSINTERVAL 1
    • TO_TIMESTAMP 1
    • TO_TIMESTAMP_TZ 1
    • TO_YMINTERVAL 1
    • TRUNC (date) 1
    • TZ_OFFSET 1
    • unacceptable NLS parameters 1
  • SQL NCHAR datatypes
    • binding and defining in OCI 1
  • SQL statements
    • LIKE conditions 1
  • strict superset 1
  • string comparisons
    • WHERE clause 1
  • string literals
    • Unicode 1
  • string manipulation using OCI 1
  • strings
    • searching 1
  • superset, strict 1
  • supersets and subsets 1
  • supplementary characters
    • linguistic collation support 1
  • supported datatypes 1
  • supported territories 1
  • syllabary 1
  • symbols, encoding 1
  • SYS_EXTRACT_UTC SQL function 1
  • SYSDATE SQL function 1
  • SYSTIMESTAMP SQL function 1

T

  • territory
    • dependencies 1
  • territory definition
    • customizing 1
    • overriding 1
  • territory support 1 , 2
  • territory variant 1
  • tertiary level sort 1
  • Thai and Laotian character rearrangement 1
  • tilde 1
  • time and date parameters 1
  • TIMESTAMP data type
    • when to use 1
  • TIMESTAMP data types
    • choosing 1
  • timestamp format 1
  • TIMESTAMP WITH LOCAL TIME ZONE data type
    • when to use 1
  • TIMESTAMP WITH TIME ZONE data type
    • when to use 1
  • time zone
    • abbreviations 1
    • database 1
    • data source 1
    • environment variables 1
    • file 1
    • names 1
    • session 1
  • time zone file
    • choosing 1
    • upgrade steps 1
    • upgrading 1
  • time zones
    • converting 1
    • upgrading time zone file 1
  • TO_CHAR (datetime) SQL function 1
  • TO_CHAR SQL function
    • format masks 1
    • group separator 1
    • spelling of days and months 1
  • TO_DATE SQL function
    • format masks 1
    • spelling of days and months 1
  • TO_DSINTERVAL SQL function 1
  • TO_NUMBER SQL function
    • format masks 1
  • TO_TIMESTAMP_TZ SQL function 1
  • TO_TIMESTAMP SQL function 1
  • TO_YMINTERVAL SQL function 1
  • transportable NLB data 1
  • TRUNC (date) SQL function 1
  • TZ_OFFSET SQL function 1
  • TZABBREV 1
  • TZNAME 1

U

  • UCS-2 encoding 1
  • Unicode
    • binding and defining Java strings 1
    • character code assignments 1
    • character set conversion between OCI client and database server 1
    • code ranges for UTF-16 characters 1
    • code ranges for UTF-8 characters 1
    • data conversion in Java 1
    • encoding 1
    • fonts 1
    • JDBC OCI driver 1
    • JDBC programming 1
    • JDBC Server Side internal driver 1
    • JDBC Server Side thin driver 1
    • JDBC thin driver 1
    • mode 1
    • ODBC and OLE DB programming 1
    • Oracle Call Interface 1
    • Oracle Data Provide for .NET 1
    • Oracle ODBC driver 1
    • Oracle OLE DB driver 1
    • Oracle Pro*C/C++ 1
    • Oracle support 1
    • parsing an XML stream with Java 1
    • PL/SQL and SQL 1
    • Private Use Area 1
    • programming 1
    • reading an XML file with Java 1
    • string literals 1
    • UCS-2 encoding 1
    • UTF-16 encoding 1
    • UTF-8 encoding 1
    • writing an XML file with Java 1
    • XML programming 1
  • Unicode database
    • case study 1
  • Unicode datatypes
    • case study 1
  • upgrade
    • Daylight Saving Time 1
  • url-rewrite-rule 1
  • US7ASCII
    • supersets 1
  • user-defined characters
    • adding to a character set definition 1
    • cross-references between character sets 1
  • UTC 1 , 2
  • UTF-16 encoding 1 , 2
  • UTF8 character set 1 , 2
  • UTF-8 encoding 1 , 2
  • UTFE character set 1 , 2

V

  • VARCHAR datatype
    • Pro*C/C++ 1
  • variable-width multibyte encoding schemes 1

W

  • wave dash 1
  • WHERE clause
    • string comparisons 1

X

  • XML
    • parsing in Unicode with Java 1
    • reading in Unicode with Java 1
    • writing in Unicode with Java 1
  • XML programming
    • Unicode 1