Globalization Support

Globalization Support Architecture

Oracle's globalization support enables you to store, process, and retrieve data in native languages. It ensures that database utilities, error messages, sort order, and date, time, monetary, numeric, and calendar conventions automatically adapt to any native language and locale.

Globalization Support Features

The database enables you to store, process, and retrieve data in native languages. The languages that can be stored in a database are all languages written in scripts that are encoded by Oracle-supported character sets.

Choosing a Character Set

When computer systems process characters, they use numeric codes instead of the graphical representation of the character. For example, when the database stores the letter A, it actually stores a numeric code that is interpreted by software as that letter. Read on to know more about Globalization Support.

Monolingual and Multilingual Database Scenario

The simplest example of an NLS database setup is when both the client and the server run in the same language environment and use the same character encoding. This monolingual scenario has the advantage of fast response because the overhead associated with character set conversion is avoided.Read on to know more about Globalization Support.

Setting NLS Parameters

As initialization parameters on the server. You can include parameters in the initialization parameter file to specify a default session NLS environment. These settings have no effect on the client side; they control only the server's behavior.Read on to know more about Globalization Support.

Checking NLS Parameters

You can find the values for NLS parameters in some views or by using an OCI function call.Applications can check the current session, instance and database NLS parameters by querying the following data dictionary views.

Date and Time Parameters

Oracle enables you to control many aspects of date and time display. Many different date formats are used throughout the world.Read on to know more about Globalization Support.

Calender and Numeric Parameters

Oracle allows you to control calendar-related items through the use of parameters.The type of calendar information stored for each territory is as follows:First Day of the Week , First Calendar Week of the Year ,Number of Days and Months in a Year ,First Year of Era.

Monetary, Lingusitic Sorting and Character Parameters

Oracle allows you to control how currency and financial symbols appear. Many different currency formats are used throughout the world.Read on to know more about Globalization Support.

Linguistic Sorting

Different languages have different sort orders. What's more, different cultures or countries using the same alphabets may sort words differently. For example, in Danish, the letter Æ is after Z, while Y and Ü are considered to be variants of the same letter. Sort order can be case sensitive or insensitive and can ignore accents or not.

Supporting Multilingual Databases with Unicode

Dealing with many different languages in the same application or database has been complicated and difficult for a long time. To overcome the limitations of existing character encodings, several organizations began working on the creation of a global character set in the late 1980s.

Choosing and Migrating Character Sets

Choosing the appropriate database character set for your database is an important decision and requires taking into account many factors. Some of these factors are: The type of data Oracle DBA need to store , The number of languages the database character set can represent , The different sizing requirements of each character set and their performance implications .Read on to know more about Globalization Support.

Customizing Locale Data

After a locale definition file is created using the Locale Builder, it must be compiled into platform-specific binary files that can be dynamically loaded into memory at runtime. The NLS Data Installation Utility (lxinst) described in this chapter allows Oracle DBA to convert and install locale definition text files into binary format, and merge it into an NLS data object set.

More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking