Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Umlauts lost while export
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...Received on Sat Oct 28 2000 - 00:37:24 CDT
> 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.