<i>Oracle8i National Language Support Guide</i> -- Index

abbreviations

AM/PM, 2-14

BC/AD, 2-14

Languages, A-2

ALTER SESSION command

SET NLS_CURRENCY option, 2-21, 2-22

SET NLS_DATE_FORMAT option, 2-12

SET NLS_LANGUAGE option, 2-9

SET NLS_NUMERIC_CHARACTERS option, 2-20

SET NLS_TERRITORY option, 2-9

ALTER SYSTEM command

SET NLS_LANGUAGE option, 2-9

alternate character mappings, 4-9

AM/PM abbreviation

ASCII character set

BC/AD abbreviation

calendar formats, 2-15

calendar parameter, 2-15

calendar systems, 2-6, 2-8, 2-11, 2-14, 2-17, 2-19, 2-20, 2-21, 2-22, 2-27, 2-28

supported, A-19

calendars, A-19, A-20

case-insensitive sorting, 2-26

CHAR datatype

multi-byte character sets and, 3-14

character data

binary sorts, 2-25

linguistic indexes, 2-26

linguistic sorts, 2-25

special cases, 2-26

sorting, 2-25

character set

conversion, 3-22

definition files, B-2

parameters, 2-29

character set conversion using OCI, 5-33

character sets

8-bit versus 7-bit, 4-4

conversion, 3-22

CONVERT function, 4-4

converting, 4-4

multi-byte, 3-14

pattern matching characters, 4-9

sorting data, 2-25

supported, 3-16

character string functionality and character sets

supported, 3-16

Codepoints, 4-9

Collation parameters, 2-24

concatenation operator, 4-11

conversions

between character set ID number and character set name, 4-5

CONVERT function, 4-4, 4-5

converting character sets, 4-4

currency

monetary units characters, 2-23

Currency formats, 2-20

currency symbol

default, 2-8

local currency symbol, 2-20

Customized Calendars, B-11

customized character sets, B-1

data

conversion, 4-4

CONVERT function, 4-5

Date formats, 2-12, 4-9

and partition bound expressions, 2-13

date parameters, 2-11

dates

ISO standard, 2-16, 4-10

NLS_DATE_LANGUAGE parameter, 2-14

NLS_TERRITORY parameter, 2-8

day

format element, 2-14

language of names, 2-14

decimal character

default, 2-8

NLS_NUMERIC_CHARACTERS parameter, 2-19

when not a period (.), 2-19

EBCDIC character set

sorting order, 2-25

environment variables

NLS_LANG, 2-4

Euro symbol

supported character sets, A-20

format elements, 4-9, 4-10

C, 4-10

D, 2-19, 4-10

day, 2-14

G, 2-19, 4-10

IW, 4-10

IY, 4-10

group separator, 2-19

default, 2-8

NLS_NUMERIC_CHARACTERS parameter, 2-19

indexes

partitioned, 4-8

initialization parameters

NLS_CALENDAR parameter, 2-6, 2-8, 2-11, 2-14, 2-17, 2-19, 2-20, 2-21, 2-22, 2-27, 2-28

NLS_LIST_SEPARATOR parameter, 2-29

NLS_MONETARY_CHARACTERS parameter, 2-23

ISO standard

date format, 2-16, 4-9, 4-10

ISO week number, 4-9

IW format element, 4-10

IY format element, 4-10

L format element, 2-20

Language support, 1-3

LIKE operator, 4-9

linguistic definitions

supported, A-17

linguistic definitions, NLS, A-16, A-17

linguistic indexes, 2-26

linguistic sorts, 2-25

controlling, 4-8

list separator, 2-29

local currency symbol, 2-20

LXBCNF executable, B-16

LXEGEN executable, B-11

LXINST executable, B-13

messages

error, A-4

monetary parameters, 2-20

monetary units characters, 2-23

month

format element, 2-14

language of names, 2-14

multi-byte character sets, 3-14

storing data, 3-14

naming database objects, 3-14

national character set

parameter, 2-29

National Language Support (NLS)

architecture, 1-1

calendars, A-19, A-20

linguistic definitions, A-16, A-17

NLS Configuration Utility, B-16

NLS Data Installation Utility, B-12

NLS_LANGUAGE parameter, 2-6, 4-4

NLS Calendar Utility, B-11

NLS data

error messages, A-4

obsolete, C-1

supported calendar systems, A-19

supported linguistic definitions, A-17

supported storage character sets, A-7

supported territories, A-5

NLS Data Installation Utility, B-12

NLS parameters

using in SQL functions, 4-1

NLS_CALENDAR parameter, 2-6, 2-8, 2-11, 2-14, 2-17, 2-19, 2-20, 2-21, 2-22, 2-27, 2-28

NLS_CHARSET_DECL_LEN function, 4-6

NLS_CHARSET_ID function, 4-5

NLS_CHARSET_NAME function, 4-5

NLS_COMP, 4-8

NLS_COMP parameter, 2-28

NLS_CREDIT environment variable, 2-24

NLS_CREDIT parameter, 2-20, 2-24

NLS_CURRENCY parameter, 2-20

NLS_DATE_FORMAT parameter, 2-11

NLS_DATE_LANGUAGE parameter, 2-14

NLS_DEBIT parameter, 2-24

NLS_DUAL_CURRENCY parameter, 2-22

NLS_ISO_CURRENCY parameter, 2-21

NLS_LANG, 2-3

NLS_LANG environment variable, 2-4, 3-16

NLS_LANG examples, 2-5

NLS_LANG, specifying, 2-5

NLS_LANGUAGE parameter, 2-6, 4-4

NLS_LIST_SEPARATOR parameter, 2-29

NLS_MONETARY_CHARACTERS parameter, 2-23

NLS_NCHAR environment variable, 3-16

NLS_NCHAR parameter, 2-29

NLS_NUMERIC_ CHARACTERS parameter, 2-19

NLS_NUMERIC_CHARACTERS parameter, 2-20

NLS_SORT parameter, 2-27, 2-28, 2-29

NLS_TERRITORY parameter, 2-8

NLSDATA (language independent data)

utilities for loading, B-12

NLSSORT function, 4-6

Numeric formats, 2-18, 4-10

Numeric parameters, 2-18

ORANLS option, B-13, B-16

ORDER BY clause, 4-8

sorting character data, 2-25

Overriding Language and Territory Specifications, 2-6

pad character

alternate mappings, 4-9

partitioned indexes, 4-8

partitioned tables, 4-8

percent sign

alternate mappings, 4-9

queries

ordering output, 2-25

replacement characters, 4-4

restricted multilingual support, 3-23

RM format element, 2-12

Roman numerals

format mask for, 2-12

setting NLS parameters, 2-1

sorting

character data, 2-25

double characters, 2-26

following language conventions, 2-25

order, 2-25

specifying non-default, 2-27, 2-28

storage character sets, A-6

supported, A-7

storing data

in multi-byte character sets, 3-14

string comparisons

and WHERE clause, 4-7

string manipulation using OCI, 5-6

supported character sets, 3-16

supported character string functionality and character sets, 3-16

tables

territory support, 1-4

Time parameters, 2-11

TO_CHAR function

default date format, 2-12

format masks, 4-9

group separator, 2-19

language for dates, 2-14

spelling of days and months, 2-14

TO_DATE function

default date format, 2-12

format masks, 4-9

language for dates, 2-14

spelling of days and months, 2-14

TO_NUMBER function

format masks, 4-9

group separator, 2-19

translated messages, A-4

underscore

alternate mappings, 4-9

UNICODE, 3-24

VARCHAR2 datatype

multi-byte character sets and, 3-14

week numbers, 4-9

WHERE clause

and string comparisons, 4-7