Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Organization

Related Documentation

Conventions

1 Overview of Globalization Support in Oracle9iAS

Globalizing Internet Applications

Globalization Concepts

Locale

Character Set

Unicode

Designing a Global Internet Application

Monolingual Internet Application Architecture

Multilingual Internet Application Architecture

Using a Centralized Database

2 Developing Global Internet Applications for Oracle9iAS

Overview of Developing Global Internet Applications

Developing Locale-Aware Internet Applications

Determining the User's Locale in Monolingual Applications

Determining the User's Locale in Multilingual Applications

Locale Awareness in Java Applications

Locale Awareness in Monolingual Java Applications

Locale Awareness in Multilingual Java Applications

Locale Awareness in Perl and C/C++ Applications

Locale Awareness in Monolingual Perl and C/C++ Applications

Locale Awareness in Multilingual Perl and C/C++ Applications

Locale Awareness in SQL and PL/SQL Applications

Locale Awareness in Monolingual SQL and PL/SQL Applications

Locale Awareness in Multilingual SQL and PL/SQL Applications

Encoding HTML Pages

Choosing an HTML Page Encoding

Choosing an HTML Page Encoding for Monolingual Applications

Choosing an HTML Page Encoding for Multilingual Applications

Specifying the Page Encoding for HTML Pages

Specifying the Encoding in the HTTP Header

Specifying the Encoding in the HTML Page Header

Specifying the Page Encoding in Java Servlets and Java Server Pages

Specifying the Page Encoding in SQL and PL/SQL Server Pages

Specifying the Page Encoding in PL/SQL and PSPs for Monolingual Environments

Specifying the Page Encoding in PL/SQL and PSPs for Multilingual Environments

Specifying the Page Encoding in Perl

Specifying the Page Encoding in Perl for Monolingual Applications

Specifying the Page Encoding in Perl for Multilingual Applications

Specifying the Page Encoding in Oracle9iAS Reports Services Applications

Specifying the Page Encoding in JSP Reports for the Web

Specifying the Page Encoding in HTML and XML Output for Paper Layout

Specifying the Page Encoding in HTML for Reports Services

Specifying the Page Encoding in XML for Reports Services

Handling HTML Form Input

Handling HTML Form Input in Java

Handling HTML Form Input in PL/SQL

Handling HTML Form Input in PL/SQL for Monolingual Applications

Handling HTML Form Input in PL/SQL for Multilingual Applications

Handling HTML Form Input in Perl

Encoding URLs

Encoding URLs in Java

Encoding URLs in PL/SQL

Encoding URLs in Perl

Formatting HTML Pages to Accommodate Text in Different Languages

Accessing the Database Server

Using JDBC to Access the Database

Using PL/SQL to Access the Database

Using Perl to Access the Database

Using C/C++ to Access the Database

Using the OCI API to Access the Database

Using the Unicode API Provided with OCI to Access the Database

Using Unicode Bind and Define in Pro*C/C++ to Access the Database

Organizing the Content of HTML Pages for Translation

Translation Guidelines for HTML Page Content

Organizing Static Files for Translation

Organizing Translatable Static Strings for Java Servlets and Java Server Pages

Retrieving Strings in Monolingual Applications

Retrieving Strings in Multilingual Applications

Organizing Translatable Static Strings in C/C++ and Perl

Organizing Translatable Static Strings in Message Tables

Organizing Translatable Dynamic Content in Application Schema

Locale Awareness in Oracle9iAS Forms Services

Locale Awareness in a Monolingual Oracle9iAS Forms Services Application

Locale Awareness in a Multilingual Oracle9iAS Forms Services Application

Locale Awareness in Oracle9iAS Reports Services

Locale Awareness in a Monolingual Oracle9iAS Reports Services Application

Locale Awareness in a Multilingual Oracle9iAS Reports Services Application

Locale Awareness in Oracle9iAS Discoverer

Locale Awareness in Oracle9iAS Clickstream Intelligence Applications

3 Configuring Oracle9iAS for Global Application Deployment

About Manually Editing HTTP Server and OC4J Configuration Files

Configuring Oracle HTTP Server for Multilingual Support

Configuring the NLS_LANG Environment Variable

Setting NLS_LANG in a Monolingual Application Architecture

Setting NLS_LANG in a Multilingual Application Architecture

Configuring the Runtime Default Locale in a Monolingual Application Architecture

mod_jserv Runtime for Java

mod_oc4j Runtime for Java

mod_plsql Runtime for PL/SQL and PL/SQL Server Pages

mod_perl Runtime for Perl Scripts

C/C++ Runtime

Configuring Transfer Mode for mod_plsql Runtime

Configuring Oracle9iAS Portal for Multilingual Support

Configuring Oracle9iAS Single Sign-On for Multilingual Support

Configuring Oracle9iAS Forms Services for Multilingual Support

Configuring Oracle9iAS Reports Services for Multilingual Support

Configuring Oracle9iAS Discoverer for Multilingual Support

Configuring Oracle9iAS Clickstream Intelligence for Multilingual Support

Configuring Oracle9i Business Components for Java for Multilingual Support

Configuring a Centralized Database for Multilingual Support

4 A Multilingual Demo for Oracle9iAS

Description of the World-of-Books Demo

Architecture and Design of the World-of-Books Demo

World-of-Books Architecture

World-of-Books Design

World-of-Books Schema Design

Building, Deploying, and Running the World-of-Books Demo

How to Build the World-of-Books Demo

How to Deploy the World-of-Books Demo

How to Run the World-of-Books Demo

Locale Awareness of the World-of-Books Demo

How World-of-Books Determines the User's Locale

How World-of-Books Uses Locale Information in Localizer Methods

How World-of-Books Sorts Query Results

How World-of-Books Searches the Contents of Books

Encoding HTML Pages for the World-of-Books Demo

Handling HTML Form Input for the World-of-Books Demo

Encoding URLs in the World-of-Books Demo

Formatting HTML Pages in the World-of-Books Demo

Accessing the Database in the World-of-Books Demo

Organizing the Content of HTML Pages in the World-of-Books Demo

Static Files for World-of-Books Online Help

Using Resource Bundles for the Content of World-of-Books HTML Pages

A Oracle9i Application Server Supported Languages

Glossary

Index