Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: german so-called umlaute in dosshell
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