Re: german umlauts in SQL*plus/Windows w/ WE8PC850 charset

Christian Birzer wrote:
>
> Hi Folks!
>
> Is it possible to display german umlauts in SQL*plus under Windows,
> even if the Database-Charset is set to WE8PC850?
> Under Dos, umlauts are displayed correct. In windows, umlauts are
> displayed as black boxes. I can't use them in queries too.
> I need something like
> alter session set NLS_CHARACTERSET = WE8ISO8859P1;
> Unfortunately this doesn't work. I tried it with NLS_LANGUAGE but this
> seems to have no effect on charset.
>
> How can I change the charset to displayed to have the umlauts
> converted 'on the fly'?
>
> BTW: Setting the Dos environment variable nls_lang to
> german_germany.we8iso8859P1 alters the nls_characterset but sql*plus
> does still no convert.
> --
> CU
> Christian Birzer student of computer science
> E-Mail : Christian.Birzer_at_t-online.de
> Homepage: http://home.t-online.de/home/Christian.Birzer
>
> ...Jetzt haben wir ein Programm - machen wir Software d'raus!
Setting the Windows enviroment oracle.ini NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
may help you.

Olaf Hübsch Received on Fri Dec 05 1997 - 00:00:00 CST