|Oracle® Database 2 Day + Application Express Developer's Guide
Part Number E11946-01
This section describes some basic information about globalization. It also leads you through the steps to specify how the application determines global identification.
This section contains the following topics:
You can develop applications in Application Builder that run concurrently in different languages. This feature enables different users to view the application in their own language and data in the appropriate formats.
When rendering a page in the application, Oracle Application Express first determines the language for an application based on the method you specified. Then, the Application Express engine alters the session language and territory settings for a specific page request. It then looks for a translated application in the appropriate language. If the Application Express engine finds that language, it renders the application using that definition. Otherwise, it renders the application in the base (or primary) application language.
Even if your application is not translated, the language display determines the format for displaying data so that end users view numbers, dates, and currency in the appropriate formats.
As part of the application definition settings, you can specify how the application determines which language and formats to display. You can base it on the user's browser language preference or restrict it to the language you specify.
To specify the method for determining global identification:
Click Application Builder and then select the application.
Click Shared Components.
Under Globalization, click Edit Attributes.
Under Globalization, specify the following:
This option enables users to view the application in the language specified in their browsers.
Automatic CSV Encoding controls the encoding of all comma-delimited (CSV) report output in an application. If Automatic CSV Encoding is set to Yes, CSV report output is properly converted to a character set compatible with localized desktop applications. The character set for the CSV encoding is determined by the Application Language Derived From setting.
For example, the end user whose browser setting is German (de) sees these changes on the Employees page of AnyCo Corp:
The euro currency symbol appears for the amounts in the Salary and Remuneration columns.
The amounts reflect the formatting used in Germany (commas and decimals).
The Hire Date reflects the date format used in Germany.
Note that the application fields are not yet translated. For instructions on translating your application, see "Managing Application Globalization" in Oracle Application Express Application Builder User's Guide.