Re: Umlauts in SQLPLus (ÄÖÜ) not promptet

Did you set the env var
NLS_LANG to GERMANY_GERMAN.WE8ISO8859p1?

NLS_LANG is the only env var that takes the characterset, all others have nothing to do with the character set. Do not confuse it with NLS_LANGUAGE.

Hth,

--
Sybrand Bakker, Oracle DBA
Josef Buergi <josef.buergi_at_ascom.ch> wrote in message news:384582a2.4848191_at_news.hasler.ascom.ch...
> Hello
>
> It's late at night, and I'm trying to fix a problem since a few hours!
>
> We run Oracle 7.3.4.0.1 under Solaris 2.6.
>
> I created the DB with we8iso8859P1 (It's the western european
> Character set, specially for umlauts. I also set the NLS Parameter to
> GERMAN/GERMANY.
>
> Now I run SQLPlus 3.3.4.0.1 and what I get suprises me a lot (on the
> Server side). Client Side is not a Problem.
>
> A simple
>
> PROMPT ÄÄÄÄÄ writes Blanks out
>
> another
>
> PROMPT ÜÜÜÜÄÄÄÄÄ writes Blanks out
>
> I cannot use any date functions like SELECT * FROM BLA WHERE
> DAT_X1='10-MÄR-1999';
>
> What is this. If I write umlauts into an ASCII file using vi, it comes
> right.
>
> Is this an ORACLE bug or waht.
>
> All unix variables like TERM, LC_TYPE are set right.
>
> Any help is really really welcome.
>
> Regards, Josef
>
> please write to josef.buergi_at_ascom.ch
Received on Wed Dec 01 1999 - 16:46:34 CST