Oracle sets the environment variable NLS_LANG (client environment variable)

NLS_LANG format:

NLS_LANG = LANGUAGE_TERRITORY.Client CHARACTERSET

1. Composition of the NLS_LANG Parameter

The NLS_LANG parameter consists of the following parts:

NLS_LANG = <Language >_< Territory>. <Clients Characterset>

The meanings of NLS_LANG are as follows:

LANGUAGE:

Oracle message language

Show month and day in date

Specified by TERRITORY

Currency and Number Format

Regional and day calculation habits

CHARACTERSET:

Controls character sets used by Client Applications

In Oracle NLS_LANG settings, it is usually set to or equal to the client (such as Windows) code page.

Or set the unicode application to UTF8.

View the CHARACHERSET used by oracle:

Select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET ';

View the instance character set Language and Territory:

Select * from nls_instance_parameters;

NLS_LANGUAGE

NLS_TERRITORY

View the two items

2. view the NLS_LANG settings:

Env | grep NLS_LANG