Problem with german umlauts with sqlplus on Linux
936910May 12 2012 — edited May 17 2012We are using Oracle 11g on Ubuntu Linux 10.04 (64Bit) and have problems with SQL scripts that contain german umlauts (äöüß).
When starting a SQL script that uses ISO8859-1 in sqlplus on Linux all umlauts ar shown as �.
I've tried to set the NLS_Lang Parameters on the Linux client to:
export NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
and also to
export NLS_LANG=GERMAN_GERMANY.UTF8
But i still see the � instead of äöüß when starting a script in sqlplus.
What goes wrong? What are the right parameters for the client to fit to
our Database?
SQL> SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE GERMAN
NLS_TERRITORY GERMANY
NLS_CURRENCY ?
NLS_ISO_CURRENCY GERMANY
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD.MM.RR
NLS_DATE_LANGUAGE GERMAN
NLS_SORT GERMAN
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD.MM.RR HH24:MI:SSXFF
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD.MM.RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY ?
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE