DB version: 11.2.0.2
Platform : RHEL 5.6
We have a software vendor who occasionaly sends us SQL scripts to deploy.
The scripts will usually contain few DDLs and lots DMLs
From textpad, i can the see the DMLs (INSERTs , UPDATEs) in SQL Script. It usually contain non-english characters (Dutch, German, French) like
'Übersicht Buchungssätze' .
'Fehler beim Löschen der zugeordneten Referenzen!'
They always ask us to set NLS_LANG like following.
export NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P15"
After the INSERT, I queried the inserted values from PL/SQL developer. The values appear as it appears in the SQL Script text file as shown above.
So, what was the effect of setting NLS_LANG ?
What could have happened if I hadn't set NLS_LANG ?
NLS info within out DB
SQL > select * from nls_Database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE ENGLISH
NLS_TERRITORY UNITED KINGDOM
NLS_CURRENCY #
NLS_ISO_CURRENCY UNITED KINGDOM
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE ENGLISH
NLS_SORT BINARY
NLS_TIME_FORMAT HH24.MI.SSXFF
NLS_TIMESTAMP_FORMAT DD-MON-RR HH24.MI.SSXFF
NLS_TIME_TZ_FORMAT HH24.MI.SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH24.MI.SSXFF TZR
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_DUAL_CURRENCY ?
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_RDBMS_VERSION 11.2.0.2.0
20 rows selected.