Database Software

We 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