Re: Convert DB characterset WE8ISO8859P1 from to AL32UTF8.

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 25 Jul 2007 16:50:14 -0700
Message-ID: <1185407414.037718.249690@x40g2000prg.googlegroups.com>

On Jul 25, 6:23 pm, RA <ang..._at_gmail.com> wrote:
> Hi,
>
> Please need help with database conversion.
>
> I have a database which has character set of WE8ISO8859P1. I need to
> convert the DB to UTF8.
>
> Below are the steps I followed for conversion, Please let me know If
> my steps are wrong.
>
> 1) I created a new database with AL32UTF8 character set.
> 2) Exported(exp utility) the data from original database(source) with
> character set WE8ISO8859P1.
> 3) Copied the dump to the new server.
> 4) Imported the data into the new database(destination) with character
> set AL32UTF8.
>
> Question: Do I have to use the same character set when importing the
> data as the source database Or use the new database character set.
>
> Thank you
> RA

I believe the ways it works is that Oracle will recongize the character set in use in the export file from the export header information and will convert it to the character set of the database automatically.

HTH -- Mark D Powell -- Received on Wed Jul 25 2007 - 18:50:14 CDT