Globalization

NLS_TERRITORY to NLS_DATE_FORMAT Mapping Table

Posted on
How NLS_LANG Affects NLS_DATE_FORMAT When NLS_LANG is Set Territory Only
NLS_TERRITORY to NLS_DATE_FORMAT Here in this post is the mapping table for showing NLS_TERRITORY to their respective NLS_DATE_FORMAT. In some situations, you may need this mapping table to solve globalization problems. For instances, ORA-01861 and ORA-12705. Please note that, NLS_DATE_FORMAT is not derived from NLS_LANGUAGE, in fact, it’s derived from NLS_TERRITORY. Therefore, any conflicts between […]
Globalization

NLS_LANGUAGE to NLS_TERRITORY Mapping Table

Posted on
NLS_LANGUAGE to NLS_TERRITORY Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_TERRITORY. In some situations, you may need this mapping table to solve globalization problems. In order to change NLS_TERRITORY, you can change NLS_LANGUAGE by setting the environment variable NLS_LANG at OS-level, database sessions will use the value to […]
Globalization

NLS_LANGUAGE to NLS_DATE_FORMAT Mapping Table

Posted on
How NLS_LANG Affects NLS_DATE_FORMAT When NLS_LANG is Set Language Only
NLS_LANGUAGE to NLS_DATE_FORMAT Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_DATE_FORMAT. In some situations, you may need this mapping table to solve globalization problems. For instances, ORA-01861 and ORA-12705. In order to change NLS_DATE_FORMAT, you can change NLS_LANGUAGE by setting the environment variable NLS_LANG at OS-level, then NLS_TERRITORY […]
Globalization

NLS_LANG, How and Why

Posted on
What is NLS_LANG? What is NLS_LANG? NLS_LANG is an environment variable in the client’s environment, it’s also a notation that can notify database what NLS (National Language Support) parameters should be used for current session. The format of NLS_LANG is such: <LANGUAGE>_<TERRITORY>.<CHARACTERSET> There’re 3 components in the environment variable NLS_LANG: LANGUAGE: It is equivalent to […]