Re: export import : german special chars not visible in target -db

(Excuse my english)
The user who would export your database , must have : a) if you are in windows : you change his base registre by : NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 if you are in unix environnemenet you must set this variable in the .profile of the the user who export you database.

au revoir !

"Richard" <qaz1521_at_hotmail.com> a écrit dans le message news: bakuku$csb$1$8300dec7_at_news.demon.co.uk...
> Can you tell us what the database and national character sets are on the
> source and destination databases? Also, when you say that the German
> characters are not visible, are they converted into unaccented characters
> (eg Ä becomes A) or are they displayed as a completely different character
> like a square block? When you perform the export and import, are any
> messages about character set conversion displayed?
>
> "Orca777" <member28638_at_dbforums.com> wrote in message
> news:2914650.1053680104_at_dbforums.com...
> >
> > Hi;
> > We have a source db having character set UsAscci 7 Bit, but german
> > special chars 'Äß..' are stored too and on the client the special chars
> > are visible!
> >
> > Now an export is done, and an import is done to a WE8ISO.. DB.
> > The german chars are not visible any more.
> >
> > I know that this has something to do with NLS_LANG-Settings.
> > can you give me a tip getting the data right stored
> > in the target -db?
> >
> > Regards
> > Orca
> >
> > --
> > Posted via http://dbforums.com
>
>
Received on Fri May 23 2003 - 07:24:35 CDT