Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: german so-called umlaute in dosshell

Re: german so-called umlaute in dosshell

From: Michael Gast <mig-sm_at_web.de>
Date: Wed, 28 Apr 2004 16:31:51 +0200
Message-ID: <408fc078$0$263$4d4ebb8e@read.news.de.uu.net>


Hi Micha,

Micha schrieb:
> i have a problem with oracle 9.2.0.1.0. i want to execute som batchfiles
> which calls some sql-script which work with historic tables from another
> database which have german tablenames. these table have with so-called
> "umlaute" ("äöüß") but oracle don't show me this characters in dosshell. in
> dba studio, everything is okay...
>
> i only work on the server.
>
> i checked the registry for global language-settings:
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_LANG =
> German_germany.we8mswin1252
> then i changed the init.ora with the parameters:
>
> ###########################################
> NLS_LANGAUGE=GERMAN
> NLS_TERRITORY=GERMANY
> NLS_CHARACTERSET=WE8MSWIN1252
>
> but there is no way to show the right chrachacters in the DOSSHELL.
> can anybody help me?
>
> thanks
> michael
>
>

Try to set the environment variable NLS_CHARACTERSET in your dos shell to the value WE8PC850.

-- 
Mit freundlichen Grüßen / Best regards
Michael Gast
SEPP MED GmbH

All emails sent to this address are never read and never will be
answered. Sorry, but until someone cleans up the spam mess, that's the
way it has to be.

E-Mails, die direkt an diese Adresse geschickt werden, lese und
beantworte ich nicht. Ich bedauere diesen Umstand sehr, kenne derzeit
aber keine bessere Möglichkeit, um die Spam-Flut abzustellen.
Received on Wed Apr 28 2004 - 09:31:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US