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

Home -> Community -> Usenet -> c.d.o.server -> Re: German Characterset

Re: German Characterset

From: Doeni <doeni_at_evhr.net>
Date: 13 Jan 2000 20:42:44 +0100
Message-ID: <874schep1n.fsf@freebie.evhr.net>


"Keith Jamieson" <jamiesonk_at_phoenix.ie> writes:

> We have set up one of our Oracle databases to be in German, and have changed
> our keyboard to be a german keyboard.
> However, we do not appear able to insert german characters , eg
> like u with an umlaut.
> In addition, when we use the to_date /to_char functions, the database is
> still expecting the months to appear in english.
> Can anyone help me on this please.

What is the database's characterset ?
It should be an 8 bits characterset (typically WE8ISO8859P1)

How is your client environment set up ? NLS_LANG should be set to german_germany.we8iso8859p1

Once this is done, it should work fine.

>
>

--
The fundamental aim of King Crimson is to organize anarchy, to utilize

   the latent power of chaos and to allow the varying influences to

	       interact and find their own equilibrium.
                                        -Robert Fripp
Received on Thu Jan 13 2000 - 13:42:44 CST

Original text of this message

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