Oracle9i Application Server Globalization Support Guide -- Index

accessing the database server, 2-27

ALTER SESSION statement

in monolingual applications, 2-10

in multilingual applications, 2-10

Apache::Util module, 2-26

BC4J, configuring for multilingual support, 3-16

bidirectional languages

formatting HTML pages, 2-26

Business Components for Java (BC4J), configuring for multilingual support, 3-16

cascading style sheets, 2-26

C/C++

database access, 2-31

database access in multilingual applications, 2-31

translatable strings, 2-40

C/C++ runtime, configuring, 3-8

CHAR datatypes, 3-17

character set, definition, 1-2

CharEncoding attribute, 2-21

charset argument, 2-25

charset parameter, 2-14

ClickStream

components

ClickStream Configurator, 2-50

HTML Viewer, 2-50

Oracle Warehouse Builder Bridge, 2-50

configuring for multilingual support, 3-16

locale awareness, 2-50

usage restrictions, 2-50

configuring NLS_LANG

in Oracle HTTP Server files, 3-3

on UNIX platforms, 3-3

on Windows platforms, 3-4

configuring Oracle HTTP Server for multilingual support, 3-3

configuring Oracle9iAS Portal for multilingual support, 3-9

configuring the NLS_LANG environment variable, 3-3

Content-Type HTTP header, 2-14

CREATE DATABASE statement, 3-17

database

centralized, 1-7

configuring, 1-7

database access

C/C++, 2-31

Java, 2-27

JDBC, 2-28

multilingual non-Java applications, 2-28

OCI API, 2-32

Perl, 2-30

PL/SQL, 2-29

Unicode API, 2-32

Unicode bind and define in Pro*C/C++, 2-34

World-of-Books demo, 4-20

database character set

setting in the CREATE DATABASE statement, 3-17

database server

accessing, 2-27

demo

See World-of-Books demo, 4-2

Discoverer

configuring Java Plus for multilingual support, 3-15

locale awareness, 2-49, 2-50

doGet() function, 2-14

encoding

UTF-16, 1-8

UTF-32, 1-8

UTF-8, 1-8

encoding HTML pages, 2-11

encoding URLs, 2-24

Java, 2-24

Perl, 2-26

PL/SQL, 2-25

World-of-Books demo, 4-18

entities

named and numbered, 2-20

ESCAPE() function, 2-25

escape_uri() function, 2-26

fonts

specifying in HTML pages, 2-26

Forms Services

configuring for multilingual support, 3-12

locale awareness, 2-44

locale awareness in a monolingual application, 2-45

locale awareness in a multilingual application, 2-46

from_utf8() function, 2-18

GET requests, 2-20

getDateTimeInstance() method, 2-7

getParameter() function, 2-21

getWriter() method, 2-15

HTML form input

encoding, 2-20

Java, 2-21

named and numbered entities, 2-20

Perl, 2-23

Perl in multilingual applications, 2-23

PL/SQL, 2-22

PL/SQL monolingual applications, 2-22

PL/SQL multilingual applications, 2-22

World-of-Books demo, 4-17

HTML page encoding

choosing for monolingual applications, 2-12

choosing for multilingual applications, 2-13

in PL/SQL and PSPs, monolingual environments, 2-16

in PL/SQL and PSPs, multilingual environments, 2-16

named and numbered entities, 2-20

specifying, 2-13

specifying in Java servlets and Java Server Pages, 2-14

specifying in Perl, 2-17

specifying in Perl for monolingual applications, 2-17

specifying in Perl for multilingual applications, 2-17

specifying in PL/SQL and PL/SQL Server Pages, 2-15

specifying in the HTML page header, 2-14

specifying in the HTTP header, 2-13

World-of-Books demo, 4-17

HTML pages

concatenating strings, 2-36

embedding text into images, 2-36

fallback mechanism for translation, 2-36

formatting for bidirectional languages, 2-26

formatting in World-of-Books demo, 4-19

formatting to accommodate text in different languages, 2-26

JavaScript code, 2-36

organizing content for translation, 2-35

organizing static files for translation, 2-36

space for dynamic text, 2-36

specifying fonts, 2-26

translatable C/C++ and Perl strings, 2-40

translatable dynamic content in application schema, 2-43

translatable strings in message tables, 2-41

translation guidelines, 2-35

user interface strings, 2-35

HTTP Content-Type header, 2-17

HttpServletRequest.getParameter() API, 2-21

IANA encoding names for commonly used locales, 2-12

Java

accessing the database, 2-27

encoding URLs, 2-24

HTML form input, 2-21

organizing translatable static strings, 2-38

Java encoding names for commonly used locales, 2-12

Java Server Pages

specifying HTML page encoding, 2-14

Java servlets

specifying HTML page encoding, 2-14

JDBC

database access, 2-28

LANG environment variable, 3-7, 3-8

languages

supported by Oracle9iAS, A-1

LC_ALL environment variable, 2-8, 3-7, 3-8

locale

as ISO standard, 2-3

as Java locale object, 2-3, 2-4

as NLS_LANGUAGE and NLS_TERRITORY parameters, 2-4

as POSIX locale name, 2-4

based on the default ISO locale of the user's browser, 2-6

changing operating system locale, 2-8

common representations in different programming environments, 2-4

definition, 1-2

determined by user input, 2-6

determining user's locale in multilingual applications, 2-6

using user profile information from an LDAP directory server, 2-6

locale awareness

in multilingual Perl and C/C++ applications, 2-11

in Oracle9iAS ClickStream applications, 2-50

in Oracle9iAS Discoverer applications, 2-49, 2-50

World-of-Books demo, 4-12

determining locale, 4-13

localizer methods, 4-14

Locale.setDefault() method, 2-7

localizer methods, World-of-Books demo, 4-14

message tables

translatable strings, 2-41

mod, 2-17

mod_jserv runtime for Java, configuring, 3-7

mod_oc4j, 3-7

mod_oc4j runtime for Java, configuring, 3-7

mod_perl environment, 2-17

mod_perl runtime for Perl scripts, configuring, 3-8

mod_plsql module

datatypes, 2-22

HTML form input in monolingual applications, 2-22

mod_plsql runtime for PL/SQL and PL/SQL Server Pages, configuring, 3-7

monolingual applications

advantages, 1-5

architecture, 1-3

disadvantages, 1-5

multilingual applications

advantages, 1-7

architecture, 1-5

database access with C/C++, 2-31

database access with Perl, 2-31

database access with Unicode API, 2-32

database access with Unicode bind and define in Pro*C/C++, 2-34

disadvantages, 1-7

HTML form input in Perl, 2-23

native encodings for commonly used locales, 2-12

native2ascii utility, 2-37

NCHAR datatypes, 3-17

NLS_LANG parameter, 2-9

configuring, 3-3

configuring in Oracle HTTP Server files, 3-3

configuring on UNIX platforms, 3-3

configuring on Windows platforms, 3-4

setting in a monolingual application architecture, 3-4

setting in a multilingual application architecture, 3-6

values for commonly used locales, 3-5

OCI API

database access, 2-32

Unicode API, 2-32

Oracle character set names for commonly used locales, 2-12

Oracle HTTP Server

configuring for multilingual support, 3-3

Oracle9iAS BC4J, configuring for multilingual support, 3-16

Oracle9iAS ClickStream

components

ClickStream Configurator, 2-50

HTML Viewer, 2-50

Oracle Warehouse Builder Bridge, 2-50

configuring for multilingual support, 3-16

locale awareness, 2-50

usage restrictions, 2-50

Oracle9iAS Discoverer

configuring Java Plus for multilingual support, 3-15

HTML Viewer, 2-50

locale awareness, 2-49, 2-50

Oracle9iAS Forms Services

configuring for multilingual support, 3-12

locale awareness, 2-44

Oracle9iAS Portal

configuring for multilingual support, 3-9

Oracle9iAS Reports Services

locale awareness, 2-48

Oracle9iAS Single Sign-On

configuring for multilingual support, 3-12

Perl

database access, 2-30

database access in multilingual applications, 2-31

encoding URLs, 2-26

HTML form input, 2-23

HTML form input in multilingual applications, 2-23

specifying HTML page encoding, 2-17

specifying HTML page encoding for monolingual applications, 2-17

specifying HTML page encoding for multilingual applications, 2-17

translatable strings, 2-40

PL/SQL

database access, 2-29

encoding URLs, 2-25

HTML form input, 2-22

HTML form input in monolingual applications, 2-22

HTML form input in multilingual applications, 2-22

PL/SQL and PL/SQL Server Pages

specifying HTML page encoding, 2-15

Portal

configuring for multilingual support, 3-9

POSIX locale names, 3-7

POST requests, 2-20

Pro*C/C++

database access, 2-34

programming environments supported by Oracle9iAS, 2-2

Reports Server

configuring for multilingual support, 3-14

Reports Services

locale awareness, 2-48

locale awareness in a monolingual application, 2-49

locale awareness in a multilingual application, 2-49

page encoding in HTML output, 2-19

page encoding in XML output, 2-19

specifying the page encoding, 2-18

runtime default locale, configuring in a monolingual application architecture, 3-6

schema

translatable content, 2-43

Servlet API, 2-21

setContentType() method, 2-14

setlocale() function

monolingual applications, 2-8

multilingual applications, 2-8

setting NLS_LANG parameter

in a monolingual application architecture, 3-4

in a multilingual application architecture, 3-6

Single Sign-On

configuring for multilingual support, 3-12

String.getBytes() method, 2-7

String.getBytes(String encoding) method, 2-7

strlen() function, 2-33

supported languages, A-1

text datatypes, 2-33

to_utf8() function, 2-24

translation

organizing HTML page content, 2-35

Unicode API

database access, 2-32

Unicode bind and define

database access, 2-34

Unicode data

storing in the database, 3-17

Unicode, definition, 1-3

UNICODE::MAPUTF8 Perl module, 2-18

url argument, 2-25

URLs

encoding, 2-24

encoding in Java, 2-24

encoding in Perl, 2-26

encoding in PL/SQL, 2-25

encoding in World-of-Books demo, 4-18

with embedded query strings, 2-24

utext datatype, 2-33, 2-34

UTF-16 encoding, 1-8

UTF-32 encoding, 1-8

UTF-8 encoding, 1-8, 2-23

for HTML pages, 2-13

limitations with Netscape 4.x browser, 2-13

UTL_URL package, 2-25

uvarchar datatype, 2-34

wcslen() function, 2-33

Web Toolkit API, 2-16

World-of-Books demo

architecture, 4-2

building, 4-8

database access, 4-20

deploying, 4-9

design, 4-4

directory structure, 4-7

encoding URLs, 4-18

formatting HTML pages, 4-19

HTML form input, 4-17

HTML page encoding, 4-17

locale awareness, 4-12

determining locale, 4-13

localizer methods, 4-14

online help, 4-21

organizing HTML content, 4-20

organizing static files, 4-21

overview, 4-2

resource bundles, 4-21

running, 4-10

schema design, 4-5

books table, 4-5

customers table, 4-5

docs table (book content), 4-6

searching book contents, 4-16

sorting query results, 4-15

source file location, 4-7