Index

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

---

A

abbreviations

AM/PM, 2-17

BC/AD, 2-17

languages, A-2

ALTER SESSION statement

SET NLS_CURRENCY clause, 2-24, 2-25

SET NLS_DATE_FORMAT clause, 2-15

SET NLS_LANGUAGE clause, 2-12

SET NLS_NUMERIC_CHARACTERS clause, 2-22

SET NLS_TERRITORY clause, 2-12

ALTER SYSTEM statement

SET NLS_LANGUAGE clause, 2-12

alternate character mappings, 4-10

AM/PM abbreviation

language of, 2-17

ASCII character set

sorting order, 2-28

---

B

BC/AD abbreviation

language of, 2-17

binary sorting, 2-28

---

C

calendar systems

support, A-21

calendars, A-21

customized, B-11

formats, 2-17

parameter, 2-17

systems, 2-20

case-insensitive sorting, 2-31

CHAR

class, 6-8

datatype

multi-byte character sets and, 3-15

object, creating, 6-8

character data

binary sorts, 2-28

linguistic indexes, 2-29

linguistic sorts, 2-28

special cases, 2-31

sorting, 2-28

character mappings

alternate, 4-10

character sets, 6-9

8-bit versus 7-bit, 4-5

Asian, A-7

conversion, 3-24

conversion using OCI, 5-34

converting, 4-5

definition files, B-2

European, A-9

Middle Eastern, A-15

multi-byte, 3-15

parameters, 2-34

pattern matching characters, 4-10

sorting data, 2-28

storage, A-6

supported, 3-18

supporting Euro symbol, A-23

universal, A-17

codepoints, 4-10

collation parameters, 2-27

concatenation operator, 4-12

conversions

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

CONVERT function, 4-5, 4-6

converting character sets, 4-5

currencies

formats, 2-23

monetary

units characters, 2-26

symbols

default, 2-10

local currency symbol, 2-23

customized

calendars, B-11

character sets, B-2

---

D

data

conversion, 4-5

date formats, 2-14, 4-10

and partition bound expressions, 2-15

date parameters, 2-13

dates

ISO standard, 2-18, 4-11

NLS_DATE_LANGUAGE parameter, 2-16

days

format element, 2-17

language of names, 2-17

decimal character

default, 2-10

NLS_NUMERIC_CHARACTERS parameter, 2-21

when not a period (.), 2-22

drivers

JDBC, 6-2

---

E

EBCDIC character set

sorting order, 2-28

EJB, 6-21

Enterprise Java Beans, 6-21

Euro symbol

supported character sets, A-23

---

F

format elements, 4-10, 4-11

C, 4-11

D, 2-22, 4-11

day, 2-17

G, 2-22, 4-11

IW, 4-11

IY, 4-11

L, 2-23, 4-11

month, 2-17

RM, 2-14, 4-10

RN, 4-11

formats

calendar, 2-17

currency, 2-23

numeric, 2-21

---

G

getString() method, 6-8

getStringWithReplacement() method, 6-8

group separator, 2-21

default, 2-10

NLS_NUMERIC_CHARACTERS parameter, 2-21

---

I

indexes

partitioned, 4-9

ISO standard

date format, 2-18, 4-11

ISO week number, 4-11

IW format element, 4-11

IY format element, 4-11

---

J

Java runtime environment, 6-2

Java stored procedures, 6-15

Java Virtual Machine, 6-14

java.sql.ResultSet, 6-3

JDBC

class library, 6-5

drivers, 6-2

OCI driver

NLS considerations, 6-6

Server driver, 6-7

Thin driver

NLS considerations, 6-7

JDBC drivers

and NLS, 6-4

JVM, 6-14

---

L

L format element, 2-23

language support, 1-5

languages

overriding, 2-6

LIKE operator, 4-10

linguistic definitions, A-19

supported, A-19

linguistic indexes, 2-29

linguistic sorts, 2-28

controlling, 4-9

list separator, 2-33

local currency symbol, 2-23

LXBCNF executable, B-17

LXEGEN executable, B-12

LXINST executable, B-13

---

M

messages

error, A-4

translated, A-4

monetary

parameters, 2-22

units characters, 2-26

months

format element, 2-17

language of names, 2-17

multi-byte character sets, 3-15

storing data, 3-15

---

N

naming database objects, 3-16

national character set

parameter, 2-34

National Language Support (NLS)

architecture, 1-2

NLS_LANGUAGE parameter, 4-4

NLS

and JDBC drivers, 6-4

conversions, 6-4

data size restrictions, 6-10

for JDBC OCI drivers, 6-6

for JDBC Thin drivers, 6-7

Java methods that employ, 6-3

ratio, 6-10

NLS Calendar Utility, B-11

NLS data

error messages, A-4

obsolete, C-2

supported calendar systems, A-21

supported linguistic definitions, A-19

supported territories, A-5

NLS Data Installation Utility, B-13

NLS parameters

default values, A-25

using in SQL functions, 4-2

NLS_CALENDAR parameter, 2-20

NLS_CHARSET_DECL_LEN function, 4-6

NLS_CHARSET_ID function, 4-6

NLS_CHARSET_NAME function, 4-6

NLS_COMP parameter, 2-32, 4-9

NLS_CREDIT parameter, 2-23, 2-27

NLS_CURRENCY parameter, 2-23

NLS_DATE_FORMAT parameter, 2-14

NLS_DATE_LANGUAGE parameter, 2-16

NLS_DEBIT parameter, 2-27

NLS_DUAL_CURRENCY parameter, 2-25

NLS_ISO_CURRENCY parameter, 2-24

NLS_LANG

choosing a locale with, 2-4

environment variable, 3-18, 6-6

examples, 2-5

specifying, 2-5

NLS_LANGUAGE parameter, 2-8

NLS_LIST_SEPARATOR parameter, 2-33

NLS_MONETARY_CHARACTERS parameter, 2-26

NLS_NCHAR environment variable, 3-18

NLS_NCHAR parameter, 2-34

NLS_NUMERIC_CHARACTERS parameter, 2-21

NLS_SORT parameter, 2-32, 2-33

NLS_TERRITORY parameter, 2-10

NLSDATA (language-independent data)

utilities for loading, B-12

NLSSORT function, 4-7

numeric

formats, 2-21, 4-11

parameters, 2-21

---

O

oracle.sql.CHAR, 6-3

oracle.sql.CHAR class, 6-8

getString() method, 6-8

getStringWithReplacement() method, 6-8

toString() method, 6-8

oracle.sql.CharacterSet class, 6-8

oracle.sql.CLOB, 6-3

ORANLS option, B-13, B-17

ORDER BY clause, 4-9

sorting character data, 2-28

overriding language and territory specifications, 2-6

---

P

pad character

alternate mappings, 4-10

parameters

calendar, 2-17

collation, 2-27

date, 2-13

monetary, 2-22

NLS default values, A-25

NLS_CALENDAR, 2-20

NLS_COMP, 2-32

NLS_CREDIT, 2-23, 2-27

NLS_CURRENCY, 2-23

NLS_DATE_FORMAT, 2-14

NLS_DATE_LANGUAGE, 2-16

NLS_DEBIT, 2-27

NLS_DUAL_CURRENCY, 2-25

NLS_ISO_CURRENCY, 2-24

NLS_LANGUAGE, 2-8

NLS_LIST_SEPARATOR, 2-33

NLS_MONETARY_CHARACTERS, 2-26

NLS_NCHAR, 2-34

NLS_NUMERIC_CHARACTERS, 2-21

NLS_SORT, 2-32, 2-33

NLS_TERRITORY, 2-10

numeric, 2-21

setting, 2-2

time, 2-13

partitioned

indexes, 4-9

tables, 4-9

percent sign

alternate mappings, 4-10

---

Q

queries

ordering output, 2-28

---

R

replacement characters, 4-5

restricted multilingual support, 3-26

RM format element, 2-14

Roman numerals

format mask for, 2-14

---

S

sorting

binary, 2-28

character data, 2-28

double characters, 2-31

following language conventions, 2-28

order, 2-28

specifying non-default, 2-32, 2-33

SQLJ

client, 6-30

SQLJ translators, 6-2

storage character sets, A-6

stored procedures

Java, 6-15

storing data

in multi-byte character sets, 3-15

string comparisons

and WHERE clause, 4-8

string manipulation using OCI, 5-7

supported character sets, 3-18

supported character string functionality and character sets, 3-18

---

T

tables

partitioned, 4-9

territories, 2-10

overriding, 2-6

supported, A-5

territory support, 1-6

time parameters, 2-13

TO_CHAR function

default date format, 2-14

format masks, 4-10

group separator, 2-22

language for dates, 2-16

spelling of days and months, 2-16

TO_DATE function

default date format, 2-14

format masks, 4-10

language for dates, 2-16

spelling of days and months, 2-16

TO_NUMBER function

format masks, 4-10

group separator, 2-22

toString() method, 6-8

translated messages, A-4

translators

SQLJ, 6-2

---

U

underscore

alternate mappings, 4-10

UNICODE, 3-27

UTF8, A-17

UTF8 support, A-18

UTFE, A-17

---

V

VARCHAR2 datatype

multi-byte character sets and, 3-15

---

W

WHERE clause

and string comparisons, 4-8