NLS LANG

From Oracle FAQ
Jump to: navigation, search

NLS_LANG is an environment variable used to define language, territory and character set properties.

Setting NLS_LANG[edit]

Windows (in cmd window): 

set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

Unix/ Linux: 

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

Valid settings[edit]

Here are some valid NLS_LANG settings:

  • French_France.WE8ISO8895P1
  • French_Switzerland.WE8ISO8895P1
  • Norwegian_Norway.NDK7DEC
  • Norwegian_Norway.WE8ISO8895P1
  • Japanese_Japan.JA16SJIS
  • Arabic_Egypt.AR8MSWIN1256
  • American_America.AR8MSWIN1256
  • American_America.WE8ISO8859P1
  • Latvian_Latvia.BLT8CP921

The space in some country names must be there:

  • DUTCH_THE NETHERLANDS.WE8ISO8859P15
  • CZECH_CZECH REPUBLIC.EE8MSWIN1250

Also see[edit]

Retrieved from "http://www.www.orafaq.com/wiki/index.php?title=NLS_LANG&oldid=18430"