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

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information

Source : Oracle Documentation | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info

Oracle Forum   

Oracle DBA Tutorial
Oracle Enterprise Manager
Configuring client/server network
Database Instance
Database Storage Structures
DBA Accounts
Managing Oracle Objects
Backup & Recovery Concepts
Database Monitoring

SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ