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: export, import on different NLS_LANG servers

Re: export, import on different NLS_LANG servers

From: Gordon Cartwright <gordon_cartwright_at_yahoo.co.uk>
Date: Wed, 07 Feb 2001 08:07:25 +0000
Message-ID: <3A81023D.A42F4AFB@yahoo.co.uk>

Are you saying that you have binary data in character fields, that is being affected by character set translation?

tigrans_at_my-deja.com wrote:

> I has an non english information in tables and when I try to import exported
> table in new table information changed to ???????????
>
> In article <95ojfa$oll$1_at_nnrp1.deja.com>,
> sybrandb_at_my-deja.com wrote:
> > In article <95ogv3$mt9$1_at_nnrp1.deja.com>,
> > spider_at_zvartnots.am wrote:
> > > Hello
> > >
> > > how I can exported information on 1st server with
> > > NLS_LANG=AMERICAN_CIS.WE8PC850 (Oracle 8.1.5) import on 2nd server
 with
> > > NLS_LANG=AMERICAN_CIS.CL8MSWIN1251(Oracle 8.1.6)
> > >
> > > without any errors in text ?
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> > >
> > Export will perform automatic conversion, as long at the charactersets
> > are compatible. What is your problem?
> >
> > Regards,
> >
> > --
> > Sybrand Bakker, Oracle DBA
> >
> > All standard disclaimers apply
> > ------------------------------------------------------------------------
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
  Received on Wed Feb 07 2001 - 02:07:25 CST

Original text of this message

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