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: Umlauts lost while export

Re: Umlauts lost while export

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 28 Oct 2000 15:37:24 +1000
Message-ID: <39fa5851@news.iprimus.com.au>

Well, it sounds as if there has been a conversion from one character set (the one you mention as being the database's) and another -presumably, therefore, your client character set down not match the back end's.

So setting your client to the database's character set should resolve the issue, and yes, NLS_LANG will do that.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Cornelius Buschka" <cornelius.buschka_at_propertygate.com> wrote in message
news:39f82dfc.19355972_at_news.cis.dfn.de...

> On exporting a database schema we lose our umlauts. U umlaut becomes U
> and so on.
>
> The system is Solaris. The database is UTF-8 installed. Can this
> problem be solved by setting NLS_LANG in the user oracle environment?
> What value has to be set?
>
> Thanx.
>
> Please mailto: cornelius.buschka_at_propertygate.com addtitionally.
Received on Sat Oct 28 2000 - 00:37:24 CDT

Original text of this message

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