Databases Reference
In-Depth Information
Figure 6-28.
The customers page in Icelandic
How It Works
To translate an application to another language, you must first extract all the resources used in your
application— which means, the error messages, labels, field captions and so on—into an XML file. This
file is called an XLIFF file. The XLIFF file can be sent to real-world translators, where each entry is
translated. The resulting XLIFF file is then reimported into APEX, where APEX will generate a new
application using the translated text in the XLIFF file.
The example in this recipe translates only two entries from the XLIFF file. If you wish to have the
entire application in 100% Icelandic, you will need to translate every entry in the file, including the form
and report names, error messages, and so on.
6-4. Storing and Displaying Dates with Time Zone Information
Problem
You have a requirement to generate a report listing events that occur in different locations around the
world in various time zones. Additionally, the report will be viewed by users from different countries and
time zones. You need to display dates and times that correspond to the local time zone of the accessing
user.
Solution
You will first need to create a table and some data for this recipe. Run the SQL in Listing 6-3 to create an
EVENTS table and add a couple of events for testing purposes.
