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

Home -> Community -> Usenet -> c.d.o.server -> Convert DB characterset WE8ISO8859P1 from to AL32UTF8.

Convert DB characterset WE8ISO8859P1 from to AL32UTF8.

From: RA <angani_at_gmail.com>
Date: Wed, 25 Jul 2007 22:23:28 -0000
Message-ID: <1185402208.655414.316120@x35g2000prf.googlegroups.com>


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 Received on Wed Jul 25 2007 - 17:23:28 CDT

Original text of this message

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