Change Oracle Database Character Set : NLS_CHARACTERSET

Change Oracle Database Character Set : NLS_CHARACTERSET

Step 1 – About

NLS_LANG is an environment parameter used to set the locale of a client application.

Setting the NLS_LANG environment parameter is the simplest way to specify locale behaviour for Oracle Database software. It sets the language and territory used by the client application. It also sets the client’s character set, which is the character set for data entered or displayed by a client program such as SQL*Plus.

NLS_LANG is not a NLS parameter, it’s an oracle environment variable set:

  • As an environment variable on UNIX platforms.
  • As a key in the registry on Windows platforms.

Continue reading “Change Oracle Database Character Set : NLS_CHARACTERSET”