Globalization Support Features
Overview of Globalization
6-2 Oracle Database 2 Day Developer's Guide
Globalization Support Features
Oracle Database standard features include:
Language support
: This feature enables you to store, process, and retrieve data in
native languages. Through the use of Unicode databases and data types, Oracle
Database supports most contemporary languages. See
Territory support
: This feature supports cultural conventions that are specific to
geographical locations. The default local time format, date format, numeric
conventions, and monetary conventions depend on the local territory setting. See
Date and time formats:
This feature supports local formats for displaying the
hour, day, month, and year. Time zones and daylight saving support are also
available. See
Monetary and numeric formats
: This feature supports local formats for
representing currency, credit, debit symbols, and numbers. See
Calendars feature
: This feature supports seven different calendar systems in use
around the world: Gregorian, Japanese Imperial, ROC Official (Republic of China),
Thai Buddha, Persian, English Hijrah, and Arabic Hijrah. See
Linguistic sorting:
This feature supports linguistic definitions for culturally
Character set support
: This feature supports a large number of single-byte,
multibyte, and fixed-width encoding schemes that are based on national,
international, and vendor-specific standards. See Oracle Database Installation Guide
for your platform for a listing of the character sets supported by Oracle Database.
Character semantics
: This feature supports character semantics. It is useful for
defining the storage requirements for multibyte strings of varying widths in terms
of characters instead of bytes. See
Unicode support:
This feature supports Unicode, which is a universal encoded
character set that enables you to store information in any language, using a single
character set. You can use SQL and PL/SQL to insert and retrieve Unicode data.
See
Viewing the Current NLS Parameter Values
In SQL Developer, the National Language Support Parameters report lists the values
of parameters for globalization support.
The NLS parameter values in this report are used at the start of all sessions within SQL
Developer, as explained in
See Also:
Oracle Database Globalization Support Guide for a complete
discussion of globalization support with Oracle Database,
including setting up the globalization support environment
Oracle Database SQL Language Reference for information about date
and time formats