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

From: William <william.h850_at_msa.hinet.net>
Date: 24 Sep 2004 19:44:21 -0700
Message-ID: <544e016e.0409241844.124890d3@posting.google.com>

I already used the csscan before I post this question. For simulation, I created a database in ZHT16MSWIN950 which has only one user table with one column.

No error I can find in the csscan results, that's why the command "convert" can work ( I think this is the reason ).

Any ideas now?

THX,
William

justin.cave_at_gmail.com wrote in message news:<1096040182.135483.57210_at_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 - 21:44:21 CDT