Skip to content

Instantly share code, notes, and snippets.

@voidius
Created October 16, 2015 14:42
Show Gist options
  • Save voidius/1d2fcd311fc7b50db425 to your computer and use it in GitHub Desktop.
Save voidius/1d2fcd311fc7b50db425 to your computer and use it in GitHub Desktop.
One can use the following v$nls_parameters view to find the database LANGUAGE, TERRITORY and CHARACTER SET.
select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
'NLS_LANGUAGE', 'LANGUAGE',
'NLS_TERRITORY', 'TERRITORY') name,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY')
/
NAME VALUE
————- —————–
LANGUAGE ENGLISH
TERRITORY LATVIA
CHARACTER SET UTF8
export NLS_LANG=<language>_<territory>.<character set>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment