Re: How to convert a database from ZHT16MSWIN950 to UTF8 or AL32UTF8

From: <justin.cave_at_gmail.com>
Date: 24 Sep 2004 08:36:22 -0700
Message-ID: <1096040182.135483.57210@k26g2000oda.googlegroups.com>

William wrote:
> As the tilte, I try to convert the character but failed.
>
> 2. Using "import & export" , also failed. Got messages
>
> IMP-00019: row rejected due to ORACLE error 1401
> IMP-00003: ORACLE error 1401 encountered
> ORA-01401: inserted value too large for column
>
> 3. The interesting way is to use "convert" function. It worked. Since
> what I need is to convert the whole 10 GB database. It didn't help me
> anything, just prove the "covert" is possible in one row.

Did you run the character set scanner to verify that the data in the database is properly encoded? Or do you have improperly encoded data values?

Justin Cave <jcave_at_ddbcinc.com>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC Received on Fri Sep 24 2004 - 10:36:22 CDT