Oracle Database - NLS_LANGUAGE parameter

Card Puncher Data Processing


language specifies the language used for displaying Oracle messages, sorting, day names, and month names.



NLS_LANGUAGE is a Nls Parameter that define the language and implicitly the parameters:

if they are are not set.

How to

Choose a language for your database

When you create a database, you have to decide what language your data will be stored in. When you create a database, you can specify the territory and code set. The territory and code set may be different from the current operating system settings. If you do not explicitly choose a territory and code set at database creation time, the database will be created using the current locale. When you are choosing a code set, make sure it can encode all the characters in the language you will be using.

Another option is to store data in a Unicode database, which means that you do not have to choose a specific language; Unicode encoding includes characters from almost all of the living languages in the world.

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Database - Globalization (Localization, NLS parameter)

Globalization support enables the storing, processing and retrieval of data in native languages. The languages that can be stored in an Oracle database are encoded by Oracle Database-supported character...
Card Puncher Data Processing
Oracle Database - NLS_DATE_LANGUAGE

NLS_DATE_LANGUAGE is a parameter which control the language used in the date format datatype and that you can use to control the implicit datatype conversion
Card Puncher Data Processing
Oracle Database - NLS_SORT (Sorting Character parameter)

Different languages have different sort orders. In addition, different cultures or countries that use the same alphabets may sort words differently. For example, in Danish, Æ is after Z, while Y and...
Card Puncher Data Processing
Oracle Database - Userenv (Current Session Informations)

Userenv is a pre-build context that describes the current session. You can query the context Userenv with two functions. the SYS_CONTEXT...

Share this page:
Follow us:
Task Runner