Re: export 7-bit character set into 8-bit instance?

From: Hieraklion <hieraklion_at_spray.fr>
Date: Wed, 22 Aug 2001 11:53:04 +0200
Message-ID: <3B838100.B11B07EB@spray.fr>

"Bonjour" from Paris

Imp/exp do the conversion between the databse and the user environment. Do for example the following :

Base in USASCII
export with a user environment in USASCI (NLS_LANG=xxx_xxx.USASCII Unix variable or appropriate register value for NT) -> dump file in USASCII (no conversion)

base in WE8iso8859P1
import with a user environnment in USASCII -> conversion from USASCCII to WE8ISO8859P1

"Au revoir" from Paris
Christophe Brault

Ed Wong a écrit :

> I need to export/import a database from one instance to another. The
> instance I export from is US7ASCII character set and the instance I
> import to is WE8ISO8859P1 character set. How can I do that? How can
> I convert the US7ASCII dump file into the WE8ISO8859P1 instance? I
> would like to use WE8ISO8859P1 character set on my new instance(the
> one I import to).
>
> Thanks in advance.
Received on Wed Aug 22 2001 - 04:53:04 CDT