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 -> Re: How to convert a database from ZHT16MSWIN950 to UTF8 or AL32UTF8

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

From: Nogates\(門都沒有\) <william_h_at_consultant.com>
Date: Sun, 26 Sep 2004 16:19:24 +0800
Message-ID: <cj5u7g$jv0$1@netnews.hinet.net>


  I tried to use NLS_LANG=american_america.ZHT16MSWIN950 to run    export. While doing import, using ZHT16MSWIN950 will generate no    error, but the data won't be correctly showed in AL32UTF8.

  If I use "AL32UTF8" to import to the "AL32UTF8" database, I got these     messages

   IMP-00019: row rejected due to ORACLE error 1401
   IMP-00003: ORACLE error 1401 encountered
   ORA-01401: inserted value too large for column



  "Justin Cave" <jcave_at_ddbcinc.com> 在郵件 news:1096136561.902447.142330_at_k17g2000odb.googlegroups.com 中撰寫...
>
> William wrote:
> > 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 ).
>
> What are the NLS_LANG settings on the client machine where you are
> running export and import?
>
> Justin Cave <jcave_at_ddbcinc.com>
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
>
Received on Sun Sep 26 2004 - 03:19:24 CDT

Original text of this message

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