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

Home -> Community -> Usenet -> c.d.o.tools -> Re: character set conversion

Re: character set conversion

From: Kari Pannila <Xkartsa_at_ougf.fi>
Date: 2000/06/20
Message-ID: <394FA82C.6CB4FD90@ougf.fi>#1/1

Ulrich Knecht wrote:
> How can I migrate the data in a way that what is, e.g. an "ä"
> (a-umlaut) in the old data base still appears as an "ä" in the new one?

You can't get WE8ISO8859P1 out of "German" US7ASCII just by export/import.
I'm afraid that you have to convert all your data "manually". Maybe by convert function, column by column... or spool/convert in unix/sqlload

regards Kari

   (Mr) Kari Pannila

        Oracle DBA (OCP)

PS. Delete X from my mail address , it (X) is only for SPAMMERS.

    Poista X mail-osoitteen edestä, se on SPAMmereita varten. Received on Tue Jun 20 2000 - 00:00:00 CDT

Original text of this message

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