german umlauts in SQL*plus/Windows w/ WE8PC850 charset 
Author Message
 german umlauts in SQL*plus/Windows w/ WE8PC850 charset

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

 Homepage: http://www.***.com/

 ...Jetzt haben wir ein Programm - machen wir Software d'raus!



Tue, 23 May 2000 03:00:00 GMT
 german umlauts in SQL*plus/Windows w/ WE8PC850 charset

Quote:

> 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

>  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 Hbsch



Tue, 23 May 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ODBC, SQL and german umlauts

2. DTS Import, German Umlaut, ignor some characters

3. german umlaut signs false representation after read from SQL2000 database

4. lower does not handle german umlaut

5. Troubles using German Umlauts with JDBC

6. oracle jdbc and german umlauts

7. oas+jservlets and german umlauts

8. German umlauts

9. WebDB: German umlauts problem

10. German Umlauts and ISQL

11. INFORMIX and german "umlaut"

12. Problems with Charsets / Special german characters


 
Powered by phpBB® Forum Software