Index
A B C D E F G H I J L M N O P Q R S T U V W X
Symbols
- $ORACLE_HOME/nls/data directory, 1.1.1
- $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat time zone file, 4.6
- $ORACLE_HOME/oracore/zoneinfo/timezone.dat time zone file, 4.6
Numerics
- 7-bit encoding schemes, 2.1.4.1, 2.1.4.1
- 8-bit encoding schemes, 2.1.4.1, 2.1.4.1
A
- abbreviations
-
- languages, A.1
- abstract datatype
-
- creating as NCHAR, 2.3.9
- accent, 5.5
- accent-insensitive linguistic sort, 5.5
- ADCS script
-
- migrating character sets in Real Application Clusters, 11.2.2.1
- 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
-
- SET NLS_CURRENCY clause, 3.8.2, 3.8.3
- SET NLS_LANGUAGE clause, 3.4.2.1
- SET NLS_NUMERIC_CHARACTERS clause, 3.7.2
- SET NLS_TERRITORY clause, 3.4.2.1
- ALTER TABLE MODIFY statement
-
- migrating from CHAR to NCHAR, 11.3.3, 11.3.3.1
- analyse_histgrm.sql script, 12.8
- analyse_rule.sql script, 12.8
- analyse_source.sql script, 12.8
- application-locales, 8.8.3
- Arial Unicode MS font, 13.1.1.1
- array parameter
-
- Database Character Set Scanner, 12.5
- ASCII encoding, 2.1.3.1
- AT LOCAL clause, 4.10
- AT TIME ZONE clause, 4.10
B
- base letters, 5.3.3.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
-
- creating indexes, 6.5.4.3
- boundaries parameter
-
- Database Character Set Scanner, 12.5
- byte semantics, 2.2, 3.11.1
C
- C number format mask, 3.8.3
- Calendar Utility, 13.3.2
- calendars
-
- customizing, 13.3.2
- parameter, 3.6
- supported, A.7
- canonical equivalence, 5.3.2, 5.4.6
- capture parameter
-
- Database Character Set Scanner, 12.5
- case, 5.1
- case-insensitive linguistic sort, 5.5
- CESU-8 compliance, A.4.5
- CHAR columns
-
- migrating to NCHAR columns, 11.3.3
- 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.8
- character repertoire, 2.1.1
- character semantics, 2.2, 3.11.1
- character set
-
- conversion, 13.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.10
- character set definition
-
- customizing, 13.5.6
- guidelines for editing files, 13.5.5
- naming files, 13.5.5
- character set migration
-
- CSALTER script, 11.2.2
- identifying character data conversion problems, 11.2
- postmigration tasks, 11.4
- scanning character data, 11.2
- character sets
-
- AL16UTF16, 6.2.3
- AL24UTFFSS, 6.2.3
- AL32UTF8, 6.2.3
- Asian, A.4.1, A.4.1, A.4.1
- changing after database creation, 2.4
- choosing, 11.1
- choosing a character set for a Unicode database, 6.3.4
- choosing a national character set, 6.3.4
- conversion, 2.3.3, 2.5.1, 9.2.1
- conversion using OCI, 10.7
- customizing, 13.5
- data loss, 11.1.2.1
- encoding, 2.1
- European, A.4.2, A.4.2
- ISO 8859 series, 2.1.3.1
- Middle Eastern, A.4.4
- migrating and the data dictionary, 12.8
- migration, 11.1, 11.1.1
- naming, 2.1.5
- national, 6.3.2, 7.2.1.1
- 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.10.1
- characters
-
- available in all Oracle database character sets, 2.1.3
- context-sensitive, 5.4.5
- contracting, 5.4.3
- user-defined, 13.5.1
- choosing a character set, 11.1
- choosing between a Unicode database and Unicode datatypes, 6.3.3
- 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
- code chart
-
- displaying and printing, 13.4
- code point, 2.1.1
- collation
-
- customizing, 13.6
- column parameter
-
- Database Character Set Scanner, 12.5
- compatibility
-
- client operating system and application character sets, 2.3.2
- composed characters, 5.4.3
- context-sensitive characters, 5.4.5
- contracting characters, 5.4.3
- contracting letters, 5.4.10
- control characters, encoding, 2.1.2.3
- conversion
-
- between character set ID number and character set name, 9.2.4
- CONVERT SQL function, 9.2.1
-
- character sets, A.4.6
- convert time zones, 4.10
- convertible data
-
- data dictionary, 12.8
- converting character data
-
- CONVERT SQL function, 9.2.1
- converting character data between character sets, 9.2.1
- 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
- CSALTER script, 11.2.2, 11.2.2.1
-
- checking phase, 12.10.1
- running, 12.10
- updating phase, 12.10.2
- CSM$COLUMNS table, 12.9.1.2
- CSM$ERRORS table, 12.9.1.3
- CSM$TABLES table, 12.9.1.1
- CSMIG user, 12.4.2
- csminst.sql script
-
- running, 12.4.2
- CSMV$COLUMNS view, 12.11.1
- CSMV$CONSTRAINTS view, 12.11.2
- CSMV$ERROR view, 12.11.3
- CSMV$INDEXES view, 12.11.4
- CSMV$TABLES view, 12.11.5
- currencies
-
- formats, 3.8.1
- CURRENT_DATE SQL function, 4.4
- CURRENT_TIMESTAMP SQL function, 4.4
- customizing time zone data, 13.3.1
D
- data conversion
-
- in Pro*C/C++, 7.4.1
- OCI driver, 7.5.5.1
- ODBC and OLE DB drivers, 7.6.3
- thin driver, 7.5.5.2
- Unicode Java strings, 7.5.5
- data dictionary
-
- changing character sets, 12.8
- convertible or lossy data, 12.8
- data dictionary views
-
- NLS_DATABASE_PARAMETERS, 3.3.1
- NLS_INSTANCE_PARAMETERS, 3.3.1
- NLS_SESSION_PARAMETER, 3.3.1
- 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
-
- exceptions, 7.2.3
- during OCI Unicode character set conversion, 7.3.2.1
- from mixed character sets, 11.1.2.2
- data truncation, 11.1.1
-
- restrictions, 11.1.1.1
- 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 Character Set Scanner, 12.5
-
- analyse_histgrm.sql script, 12.8
- analyse_rule.sql script, 12.8
- analyse_source.sql script, 12.8
- array parameter, 12.5
- boundaries parameter, 12.5
- capture parameter, 12.5
- column parameter, 12.5
- CSM$COLUMNS table, 12.9.1.2
- CSM$ERRORS table, 12.9.1.3
- CSM$TABLES table, 12.9.1.1
- CSMV$COLUMNS view, 12.11.1
- CSMV$CONSTRAINTS view, 12.11.2
- CSMV$ERROR view, 12.11.3
- CSMV$INDEXES view, 12.11.4
- CSMV$TABLES view, 12.11.5
- Database Scan Summary Report, 12.7.1
- error messages, 12.12
- exclude parameter, 12.5
- feedback parameter, 12.5
- fromnchar parameter, 12.5
- full parameter, 12.5
- help parameter, 12.5
- Individual Exception Report, 12.7.2
- invoking, 12.4.3
- lastrpt parameter, 12.5, 12.5
- maxblocks parameter, 12.5
- online help, 12.4.5
- performance, 12.9.2
- preserve parameter, 12.5
- query parameter, 12.5
- restrictions, 12.9.3
- scan modes, 12.3
- suppress parameter, 12.5
- table parameter, 12.5
- tochar parameter, 12.5
- user parameter, 12.5
- userid parameter, 12.5
- utility, 12.2
- views, 12.11
- Database Scan Summary Report, 12.7.1
- database schemas
-
- designing for multiple languages, 6.5
- database time zone, 4.8
- datatype conversion
-
- data loss and exceptions, 7.2.3
- implicit, 7.2.4
- SQL functions, 7.2.5
- datatypes
-
- abstract, 2.3.9
- DATE, 4.2.1.1
- datetime, 4.2
- inserting values into datetime datatypes, 4.2.1.5
- inserting values into interval datatypes, 4.2.2.3
- interval, 4.2, 4.2.2
- INTERVAL DAY TO SECOND, 4.2.2.2
- INTERVAL YEAR TO MONTH, 4.2.2.1
- supported, 2.3.9
- TIMESTAMP, 4.2.1.2
- TIMESTAMP WITH LOCAL TIME ZONE, 4.2.1.4
- TIMESTAMP WITH TIME ZONE, 4.2.1.3
- date and time parameters, 3.5
- DATE datatype, 4.2.1.1
- date formats, 3.5.1, 3.5.1.1, 9.3.1
-
- and partition bound expressions, 3.5.1.1
- dates
-
- ISO standard, 3.6.1.2, 9.3.2
- NLS_DATE_LANGUAGE parameter, 3.5.1.2
- datetime datatypes, 4.2
-
- inserting values, 4.2.1.5
- datetime format parameters, 4.5.1
- Daylight Saving Time
-
- Oracle support, 4.11
- daylight saving time session parameter, 4.5.3
- days
-
- format element, 3.5.1.2
- language of names, 3.5.1.2
- DB_TZ database time zone, 4.9
- DBMS_LOB PL/SQL package, 9.3.4
- DBMS_LOB.LOADBLOBFROMFILE procedure, 9.3.4
- DBMS_LOB.LOADCLOBFROMFILE procedure, 9.3.4
- DBMS_REDEFINITION.CAN_REDEF_TABLE procedure, 11.3.3.2
- DBTIMEZONE SQL function, 4.4
- dest_char_set parameter, A.4.6
- detecting language and character sets
-
- Globalization Development Kit, 8.7.6
- detection
-
- supported languages and character sets, A.5
- diacritic, 5.1
- dynamic performance views
-
- V$NLS_PARAMETERS, 3.3.2
- V$NLS_VALID_VALUES, 3.3.2
E
- encoding
-
- control characters, 2.1.2.3
- ideographic writing systems, 2.1.2.2
- numbers, 2.1.2.3
- phonetic writing systems, 2.1.2.1
- punctuation, 2.1.2.3
- symbols, 2.1.2.3
- encoding schemes
-
- 7-bit, 2.1.4.1, 2.1.4.1
- 8-bit, 2.1.4.1, 2.1.4.1
- fixed-width, 2.1.4.2
- multibyte, 2.1.4.2
- shift-sensitive variable-width, 2.1.4.2
- shift-sensitive variable-width multibyte, 2.1.4.2
- single-byte, 2.1.4.1
- variable-width, 2.1.4.2
- environment variables
-
- ORA_SDTZ, 4.5.2, 4.9
- ORA_TZFILE, 4.5.2
- error messages
-
- languages, A.2
- translation, A.2
- ERROR_ON_OVERLAP_TIME session parameter, 4.5.3
- euro
-
- Oracle support, 3.8.5
- exclude parameter
-
- Database Character Set Scanner, 12.5
- expanding characters, 5.4.9
-
- characters
-
- expanding, 5.4.4
- EXTRACT (datetime) SQL function, 4.4
F
- feedback parameter
-
- Database Character Set Scanner, 12.5
- fixed-width multibyte encoding schemes, 2.1.4.2
- fonts
-
- Unicode, 13.1.1
- Unicode for UNIX, 13.1.1.2
- Unicode for Windows, 13.1.1.1
- format elements, 9.3.3
-
- C, 9.3.3
- D, 9.3.3
- day, 3.5.1.2
- G, 9.3.3
- IW, 9.3.2
- IY, 9.3.2
- L, 9.3.3
- month, 3.5.1.2
- RM, 9.3.1
- RN, 9.3.3
- format masks, 3.7.2, 9.3.1
- formats
-
- currency, 3.8.1
- date, 3.5.1.1, 4.5.1
- numeric, 3.7.1
- time, 3.5.2
- FROM_TZ SQL function, 4.4
- fromchar parameter, 12.5
-
- Database Character Set Scanner, 12.5
- fromnchar parameter
-
- Database Character Set Scanner, 12.5
- full parameter
-
- Database Character Set Scanner, 12.5
G
- GDK
-
- application configuration file, 8.6.1
- GDK application configuration file, 8.8
-
- example, 8.8.8
- GDK application framework for J2EE, 8.6, 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
- gdkapp.xml application configuration file, 8.8
- gdkapp.xml GDK application configuration file, 8.6.1
- getString() method, 7.5.6.1
- getStringWithReplacement() method, 7.5.6.1
- 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, 12.1
H
- help parameter
-
- Database Character Set Scanner, 12.5
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
- partitioned, 9.2.5.3
- Individual Exception Report, 12.7.2
- 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, 9.2.2, 9.2.2
- Internet application
-
- locale
-
- determination, 8.3.1
- monolingual, 8.2, 8.2.1
- multilingual, 8.2, 8.2.2
- interval datatypes, 4.2, 4.2.2
-
- inserting values, 4.2.2.3
- INTERVAL DAY TO SECOND datatype, 4.2.2.2
- INTERVAL YEAR TO MONTH datatype, 4.2.2.1
- 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.6.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 drivers
-
- form of use argument, 7.5.3
- JDBC OCI driver
-
- and Unicode, 7.1.1
- JDBC programming
-
- Unicode, 7.5
- JDBC Server Side internal driver
-
- and Unicode, 7.1.1
- JDBC Server Side thin driver
-
- and Unicode, 7.1.1
- JDBC thin driver
-
- and Unicode, 7.1.1
L
- language
-
- detecting with Globalization Development Kit, 8.7.6
- language abbreviations, A.1
- Language and Character Set File Scanner, 12.1
- language definition
-
- customizing, 13.2
- overriding, 3.2.2
- language support, 1.2.1
- languages
-
- error messages, A.2
- languages and character sets
-
- supported by LCSSCAN, A.5
- LAST_DAY SQL function, 4.4
- lastrpt parameter
-
- Database Character Set Scanner, 12.5, 12.5
- LCSCCAN
-
- error messages, 12.1.5
- LCSSCAN, 12.1
-
- supported languages and character sets, 12.1.4, A.5
- LCSSCAN command
-
- BEGIN parameter, 12.1.1
- END parameter, 12.1.1
- examples, 12.1.2
- FILE parameter, 12.1.1
- HELP parameter, 12.1.3
- online help, 12.1.3
- RESULTS parameter, 12.1.1
- syntax, 12.1.1
- length semantics, 2.2, 3.11
- LENGTH SQL functions, 9.2.2, 9.2.2
- LIKE conditions in SQL statements, 9.2.3
- LIKE2 SQL condition, 9.2.3
- LIKE4 SQL condition, 9.2.3
- LIKEC SQL condition, 9.2.3
- linguistic sort definitions
-
- supported, A.6
- linguistic sorts
-
- accent-insensitive, 5.5
- BINARY, 5.5.2
- BINARY_AI, linguistic sorts
-
- BINARY_CI, 5.5.2
- case-insensitive, 5.5
- controlling, 9.2.5.4
- customizing, 13.6
-
- characters with diacritics, 13.6.1, 13.6.2
- levels, 5.3.3.1
- list of defaults, A.1
- parameters, 3.9
- list parameter, 3.7
- 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
- detection
-
- Globalization Development Kit, 8.6.3
- of Internet application
-
- determining, 8.3.1
- variant, 3.2.3
- locale information
-
- mapping between Oracle and other standards, 10.4
- locale-charset-map, 8.8.1
- locale-determine-rule, 8.8.4
- LocaleMapper class, 8.7.8
- locale-parameter-name, 8.8.5
- LOCALTIMESTAMP SQL function, 4.4
- lossy data
-
- data dictionary, 12.8
- lxegen utility, 13.3.2
M
- maxblocks parameter
-
- Database Character Set Scanner, 12.5
- message-bundles, 8.8.6
- migrating a character set
-
- CSALTER script, 11.2.2
- migrating character sets in Real Application Clusters, 11.2.2.1
- migration
-
- CHAR columns to NCHAR columns, 11.3.3
- character sets, 11.1
- to NCHAR datatypes, 11.3
- version 8 NCHAR columns to Oracle9i and later, 11.3.1
- mixed character sets
-
- causing data loss, 11.1.2.2
- monetary parameters, 3.8
- monolingual Internet application, 8.2.1
- monolingual linguistic sorts
-
- example, 5.5.3
- supported, A.6
- months
-
- format element, 3.5.1.2
- language of names, 3.5.1.2
- MONTHS_BETWEEN SQL function, 4.4
- multibyte encoding schemes, 2.1.4.2
-
- fixed-width, 2.1.4.2
- shift-sensitive variable-width, 2.1.4.2
- variable-width, 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 sorts
-
- example, 5.5.3
- supported, A.6
- multilingual support
-
- restricted, 2.6.1
- unrestricted, 2.6.2
- multiple languages
-
- designing database schemas, 6.5
- storing data, 6.5.2
- storing documents in LOBs, 6.5.3
N
- N SQL function, 7.2.5
- national character set, 2.3.8, 6.3.2, 7.2.1.1, 7.2.1.2
- NCHAR columns
-
- migrating from version 8 to Oracle9i and later, 11.3.1
- NCHAR datatype, 7.2.1.1
-
- creating abstract datatype, 2.3.9
- migrating, 11.3
- migration, 11.3.1
- NCHR SQL function, 7.2.7
- NCLOB datatype, 7.2.1.3
- NEW_TIME SQL function, 4.4
- NEXT_DAY SQL function, 4.4
- NLB data
-
- transportable, 13.10
- NLB file, 13.1.3.1
- NLB files, 13.1
-
- generating and installing, 13.7
- NLS Calendar Utility, 13.3.2
- 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
- NLS Runtime Library, 1.1.1
- NLS_CALENDAR parameter, 3.6.2
- NLS_CHARSET_DECL_LEN SQL function, 9.2.4.3
- NLS_CHARSET_ID SQL function, 9.2.4.2
- NLS_CHARSET_NAME SQL function, 9.2.4.1
- NLS_COMP parameter, 3.9.2, 9.2.5.3
- NLS_CREDIT parameter, 3.8.7
- NLS_CURRENCY parameter, 3.8.2
- NLS_DATABASE_PARAMETERS data dictionary view, 3.3.1
- NLS_DATE_FORMAT initialization parameter, 4.5.1
- NLS_DATE_FORMAT parameter, 3.5.1.1
- NLS_DATE_LANGUAGE parameter, 3.5.1.2
- NLS_DEBIT parameter, 3.8.8
- NLS_DUAL_CURRENCY parameter, 3.8.4
- NLS_INITCAP SQL function, 5.4.11, 9.1
- NLS_INSTANCE_PARAMETERS data dictionary view, 3.3.1
- NLS_ISO_CURRENCY parameter, 3.8.3
- NLS_LANG parameter, 3.2
-
- choosing a locale, 3.2
- client setting, 3.2.4
- examples, 3.2.1
- OCI client applications, 7.3.3
- specifying, 3.2.1
- UNIX client, 3.2.4
- Windows client, 3.2.4
- NLS_LANGUAGE parameter, 3.4.1
- NLS_LENGTH_SEMANTICS parameter, 2.2
- NLS_LIST_SEPARATOR parameter, 3.10
- NLS_LOWER SQL function, 5.4.11, 5.5, 9.1
- NLS_MONETARY_CHARACTERS parameter, 3.8.6
- NLS_NCHAR_CONV_EXCP parameter, 3.10.1
- NLS_NUMERIC_CHARACTERS parameter, 3.7.2
- NLS_SESSION_PARAMETERS data dictionary view, 3.3.1
- NLS_SORT parameter, 3.9.1, 5.7.2.1
- NLS_TERRITORY parameter, 3.4.2
- NLS_TIMESTAMP_FORMAT initialization parameter, 4.5.1
- NLS_TIMESTAMP_FORMAT parameter
-
- parameters
-
- NLS_TIMESTAMP_FORMAT, 3.5.2.1, 3.5.2.2
- NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 4.5.1
- NLS_UPPER SQL function, 5.4.11, 5.5, 9.1
- NLSRTL, 1.1.1
- NLSSORT SQL function, 9.1, 9.2.5
-
- syntax, 9.2.5.1
- NLT files, 13.1
- numbers, encoding, 2.1.2.3
- numeric formats, 3.7.1
-
- SQL masks, 9.3.3
- numeric parameters, 3.7
- NUMTODSINTERVAL SQL function, 4.4
- NUMTOYMINTERVAL SQL function, 4.4
- NVARCHAR datatype
-
- Pro*C/C++, 7.4.3
- NVARCHAR2 datatype, 7.2.1.2
O
- obsolete locale data, 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
- setting the character set, 10.2
- SQL CHAR datatypes, 7.3.4
- OCI and Unicode, 7.1.1
- OCI character set conversion, 7.3.2.2
-
- data loss, 7.3.2.1
- performance, 7.3.2.2
- OCI client applications
-
- using Unicode character sets, 7.3.3
- OCI data conversion
-
- data expansion, 7.3.2.3
- OCI_ATTR_CHARSET_FORM attribute, 7.3.2.1
- OCI_ATTR_MAXDATA_SIZE attribute, 7.3.2.3
- OCI_UTF16ID character set ID, 7.3.1
- OCIBind() function, 7.3.4
- OCICharSetConversionIsReplacementUsed(), 10.7
- OCICharSetConvert(), 10.7
- OCICharsetToUnicode(), 10.7
- OCIDefine() function, 7.3.4
- OCIEnvNlsCreate(), 7.3.1, 10.2
- OCILobRead() function, 7.3.7
- OCILobWrite() function, 7.3.7
- OCIMessageClose(), 10.8
- OCIMessageGet(), 10.8
- OCIMessageOpen(), 10.8
- OCIMultiByteInSizeToWideChar(), 10.5
- OCIMultiByteStrCaseConversion(), 10.5
- OCIMultiByteStrcat(), 10.5
- OCIMultiByteStrcmp(), 10.5
- OCIMultiByteStrcpy(), 10.5
- OCIMultiByteStrlen(), 10.5
- OCIMultiByteStrncat(), 10.5
- OCIMultiByteStrncmp(), 10.5
- OCIMultiByteStrncpy(), 10.5
- OCIMultiByteStrnDisplayLength(), 10.5
- OCIMultiByteToWideChar(), 10.5
- OCINlsCharSetIdToName(), 10.3
- OCINlsCharSetNameTold(), 10.3
- OCINlsEnvironmentVariableGet(), 10.3
- OCINlsGetInfo(), 10.3, 10.3
- OCINlsNameMap(), 10.4
- OCINlsNumericInfoGet(), 10.3
- OCIUnicodeToCharset(), 10.7
- OCIWideCharDisplayLength(), 10.5
- OCIWideCharInSizeToMultiByte(), 10.5
- OCIWideCharIsAlnum(), 10.6
- OCIWideCharIsAlpha(), 10.6
- OCIWideCharIsCntrl(), 10.6
- OCIWideCharIsDigit(), 10.6
- OCIWideCharIsGraph(), 10.6
- OCIWideCharIsLower(), 10.6
- OCIWideCharIsPrint(), 10.6
- OCIWideCharIsPunct(), 10.6
- OCIWideCharIsSingleByte(), 10.6
- OCIWideCharIsSpace(), 10.6
- OCIWideCharIsUpper(), 10.6, 10.7
- OCIWideCharIsXdigit(), 10.6
- OCIWideCharMultibyteLength(), 10.5
- OCIWideCharStrCaseConversion(), 10.5
- OCIWideCharStrcat(), 10.5
- OCIWideCharStrchr(), 10.5
- OCIWideCharStrcmp(), 10.5
- OCIWideCharStrcpy(), 10.5
- OCIWideCharStrlen(), 10.5
- OCIWideCharStrncat(), 10.5
- OCIWideCharStrncmp(), 10.5
- OCIWideCharStrncpy(), 10.5
- OCIWideCharStrrchr(), 10.5
- OCIWideCharToLower(), 10.5
- OCIWideCharToMultiByte(), 10.5
- OCIWideCharToUpper(), 10.5
- ODBC Unicode applications, 7.6.4
- OLE DB Unicode datatypes, 7.6.5
- online table redefinition
-
- migrating from CHAR to NCHAR, 11.3.3, 11.3.3.2
- operating system
-
- character set compatibility with applications, 2.3.2
- ORA_NLS10 environment variable, 1.1.1
- ORA_SDTZ environment variable, 4.5.2, 4.9
- 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 Language and Character Set Detection Java classes, 8.7.6
- Oracle Locale Builder
-
- choosing a calendar format, 13.3
- choosing currency formats, 13.3
- choosing date and time formats, 13.3
- displaying code chart, 13.4
- Existing Definitions dialog box, 13.1.3.1
- fonts, 13.1.1.1, 13.1.1.2
- Open File dialog box, 13.1.3.4
- Preview NLT screen, 13.1.3.3
- restrictions on names for locale objects, 13.2
- Session Log dialog box, 13.1.3.2
- starting, 13.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
- oracle.i18n.lcsd package, 8.9.1
- oracle.i18n.net package, 8.9.2
- oracle.i18n.servlet package, 8.9.3
- oracle.i18n.text package, 8.9.4
- oracle.i18n.util package, 8.9.5
- oracle.sql.CHAR class
-
- character set conversion, 7.5.6.1
- getString() method, 7.5.6.1
- getStringWithReplacement() method, 7.5.6.1
- toString() method, 7.5.6.1
- ORDER BY clause, 9.2.5.4
- OS_TZ local operating system time zone, 4.9
- overriding language and territory definitions, 3.2.2
P
- page-charset, 8.8.2
- parameters
-
- BLANK_TRIMMING, 11.1.1.1
- calendar, 3.6
- character set conversion, 3.10
- linguistic sorts, 3.9
- methods of setting, 3.1
- monetary, 3.8
- NLS_CALENDAR, 3.6.2
- NLS_COMP, 3.9.2
- NLS_CREDIT, 3.8.7
- NLS_CURRENCY, 3.8.2
- NLS_DATE_FORMAT, 3.5.1.1
- NLS_DATE_LANGUAGE, 3.5.1.2
- NLS_DEBIT, 3.8.8
- NLS_DUAL_CURRENCY, 3.8.4
- NLS_ISO_CURRENCY, 3.8.3
- NLS_LANG, 3.2
- NLS_LANGUAGE, 3.4.1
- NLS_LIST_SEPARATOR, 3.10
- NLS_MONETARY_CHARACTERS, 3.8.6
- NLS_NCHAR_CONV_EXCP, 3.10.1
- NLS_NUMERIC_CHARACTERS, 3.7.2
- NLS_SORT, 3.9.1
- NLS_TERRITORY, 3.4.2
- numeric, 3.7
- setting, 3.1
- time and date, 3.5
- time zone, 3.5.2.1, 3.5.2.2
- partitioned
-
- indexes, 9.2.5.3
- tables, 9.2.5.3
- performance
-
- choosing a database character set, 2.3.4
- during OCI Unicode character set conversion, 7.3.2.2
- phonetic writing systems, encoding, 2.1.2.1
- PL/SQL and SQL and Unicode, 7.1.1
- preserve parameter
-
- Database Character Set Scanner, 12.5
- primary level sort, 5.3.3.1
- Private Use Area, 13.5.3
- Pro*C/C++
-
- data conversion, 7.4.1
- NVARCHAR datatype, 7.4.3
- UVARCHAR datatype, 7.4.4
- VARCHAR datatype, 7.4.2
- punctuation, encoding, 2.1.2.3
Q
- query parameter
-
- Database Character Set Scanner, 12.5
R
- Real Application Clusters
-
- database character set migration, 11.2.2.1
- REGEXP SQL functions, 5.9
- 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
- restricted multilingual support, 2.6.1, 2.6.1
- restrictions
-
- data truncation, 11.1.1.1
- passwords, 11.1.1.1
- space padding during export, 11.1.1.1
- usernames, 11.1.1.1
- reverse secondary sorting, 5.4.7
- ROUND (date) SQL function, 4.4
- RPAD SQL function, 7.2.6
S
- scan modes
-
- Database Character Set Scanner, 12.3
- full database scan, 12.3.1
- single table scan, 12.3.3
- user tables scan, 12.3.2
- scan.err file, 12.7
- scan.out file, 12.6.1.3, 12.6.2.3, 12.6.3.3, 12.6.3.6, 12.6.4.3
- scan.txt file, 12.7
- searching multilingual documents, 6.5.4
- searching string, 5.8
- secondary level sort, 5.3.3.2
- session parameters
-
- ERROR_ON_OVERLAP, 4.5.3
- session time zone, 4.9
- SESSIONTIMEZONE SQL function, 4.4
- setFormOfUse() method, 7.5.3
- shift-sensitive variable-width multibyte encoding schemes, 2.1.4.2
- single-byte encoding schemes, 2.1.4.1
- sorting
-
- reverse secondary, 5.4.7
- specifying nondefault linguistic sorts, 3.9.1, 3.9.2
- source_char_set parameter, A.4.6
- space padding
-
- during export, 11.1.1.1
- special combination letters, 5.4.3, 5.4.10
- special letters, 5.4.4, 5.4.9
- special lowercase letters, 5.4.12
- special uppercase letters, 5.4.11
- SQL CHAR datatypes, 2.3
-
- OCI, 7.3.4
- SQL conditions
-
- LIKE2, 9.2.3
- LIKE4, 9.2.3
- LIKEC, 9.2.3
- 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, 9.2.2, 9.2.2
- LAST_DAY, 4.4
- LENGTH, 9.2.2, 9.2.2
- LOCALTIMESTAMP, 4.4
- MONTHS_BETWEEN, 4.4
- N, 7.2.5
- NCHR, 7.2.7
- NEW_TIME, 4.4
- NEXT_DAY, 4.4
- NLS_CHARSET_DECL_LEN, 9.2.4.3
- NLS_CHARSET_ID, 9.2.4.2
- NLS_CHARSET_NAME, 9.2.4.1
- NLS_INITCAP, 5.4.11, 9.1
- NLS_LOWER, 5.4.11, 5.5, 9.1
- NLS_UPPER, 5.4.11, 5.5, 9.1
- NLSSORT, 9.1, 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
- SUBSTR, 9.2.2, 9.2.2
- SUBSTR2, 9.2.2
- SUBSTR4, 9.2.2
- SUBSTRB, 9.2.2
- SUBSTRC, 9.2.2
- SYS_EXTRACT_UTC, 4.4
- SYSDATE, 4.4
- SYSTIMESTAMP, 4.4
- TO_CHAR, 9.1
- TO_CHAR (datetime), 4.4
- TO_DATE, 7.2.5, 9.1
- TO_DSINTERVAL, 4.4
- TO_NCHAR, 7.2.5
- TO_NUMBER, 9.1
- 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
- UNISTR, 7.2.7
- 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
- SUBSTR SQL function, 9.2.2
- SUBSTR SQL functions, 9.2.2
-
- SUBSTR, 9.2.2
- SUBSTR2, 9.2.2
- SUBSTR4, 9.2.2
- SUBSTRB, 9.2.2
- SUBSTRC, 9.2.2
- SUBSTR4 SQL function, 9.2.2
- SUBSTRB SQL function, 9.2.2
- SUBSTRC SQL function, 9.2.2
- superset, strict, 6.2.2.1
- supersets and subsets, A.4.7
- supplementary characters, 5.3.2, 6.2.1
-
- linguistic sort support, A.6
- supported datatypes, 2.3.9
- supported territories, A.3
- suppress parameter
-
- Database Character Set Scanner, 12.5
- surrogate pairs, 6.2.1
- syllabary, 2.1.2.2
- symbols, encoding, 2.1.2.3
- SYS_EXTRACT_UTC SQL function, 4.4
- SYSDATE SQL function, 4.4
-
- effect of session time zone, 4.9
- sys.sys_tzuv2_temptab table, 4.7
- SYSTIMESTAMP SQL function, 4.4
T
- table parameter
-
- Database Character Set Scanner, 12.5
- tables
-
- partitioned, 9.2.5.3
- territory
-
- dependencies, 3.2.3
- territory definition, 3.4.2
-
- customizing, 13.3
- overriding, 3.2.2
- territory support, 1.2.2, A.3
- territory variant, 3.2.3
- tertiary level sort, 5.3.3.3
- Thai and Laotian character rearrangement, 5.4.8
- tilde, 7.5.7.1
- time and date parameters, 3.5
- time zone
-
- abbreviations, 4.6
- data source, 4.6
- database, 4.8
- effect on SYSDATE SQL function, 4.9
- environment variables, 4.5.2
- names, 4.6
- parameters, 3.5.2.1, 3.5.2.2
- session, 4.9
- time zone file
-
- choosing, 4.6
- default, 4.6
- time zones
-
- converting, 4.10
- customizing, 13.3.1
- upgrading definitions, 4.7
- TIMESTAMP datatype, 4.2.1.2
-
- when to use, 4.2.1.6
- TIMESTAMP datatypes
-
- choosing, 4.2.1.6
- timestamp format, 3.5.2.1
- TIMESTAMP WITH LOCAL TIME ZONE datatype, 4.2.1.4
-
- when to use, 4.2.1.6
- TIMESTAMP WITH TIME ZONE datatype, 4.2.1.3
-
- when to use, 4.2.1.6
- timezlrg.dat file, 13.3.1
- timezone.dat file, 13.3.1
- TO_CHAR (datetime) SQL function, 4.4
- TO_CHAR SQL function, 9.1
-
- default date format, 3.5.1.1, 4.5.1
- format masks, 9.3.1
- group separator, 3.7.2
- language for dates, 3.5.1.2
- spelling of days and months, 3.5.1.2
- TO_DATE SQL function, 7.2.5, 9.1
-
- default date format, 3.5.1.1, 4.5.1
- format masks, 9.3.1
- language for dates, 3.5.1.2
- spelling of days and months, 3.5.1.2
- TO_DSINTERVAL SQL function, 4.4
- TO_NCHAR SQL function, 7.2.5
- TO_NUMBER SQL function, 9.1
-
- format masks, 9.3.1
- TO_TIMESTAMP SQL function, 4.4
- TO_TIMESTAMP_TZ SQL function, 4.4
- TO_YMINTERVAL SQL function, 4.4
- tochar parameter
-
- Database Character Set Scanner, 12.5
- toString() method, 7.5.6.1
- transportable NLB data, 13.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.2
- 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, 13.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, 13.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.2
- UTF-16 encoding, 6.2.2.3
- 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
- choosing a character set, 6.3.4
- using with Unicode datatypes (case study), 6.4
- when to use, 6.3.3.1
- Unicode datatypes, 6.3.2
-
- case study, 6.4
- choosing a national character set, 6.3.4
- using with a Unicode database (case study), 6.4
- when to use, 6.3.3.2
- UNISTR SQL function, 7.2.7
- unrestricted multilingual support, 2.6.2
- url-rewrite-rule, 8.8.7
- US7ASCII
-
- supersets, A.4.7
- user parameter
-
- Database Character Set Scanner, 12.5
- user-defined characters, 13.5.1
-
- adding to a character set definition, 13.5.6
- cross-references between character sets, 13.5.4
- userid parameter
-
- Database Character Set Scanner, 12.5
- UTC, 4.2.1.3, 4.2.1.4
- UTF-16 encoding, 6.2.2.3, 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, 6.3.1, A.4.5
- UTL_FILE package, using with NCHAR, 7.2.9
- UTL_I18N PL/SQL package, 8.10
- UTL_LMS PL/SQL package, 8.10
- utltzuv2.sql script, 4.7
- UVARCHAR datatype
-
- Pro*C/C++, 7.4.4
V
- V$NLS_PARAMETERS dynamic performance view, 3.3.2
- V$NLS_VALID_VALUES dynamic performance view, 3.3.2
- VARCHAR datatype
-
- Pro*C/C++, 7.4.2
- variable-width multibyte encoding schemes, 2.1.4.2
- version 8 NCHAR columns
-
- migrating to Oracle9i and later, 11.3.1
W
- wave dash, 7.5.7.1
- WHERE clause
-
- string comparisons, 9.2.5.2
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
-
- Unicode, 7.7