Re: export, import on different NLS_LANG servers

I've only seen ???? output when the character in the database cannot be represented in the client character set, so I guess Oracle thinks that is the case here. You've given NLS_LANG settings (presumably these were used for exp/imp). What are the database character sets and how did you display the ??????. Can you post the export and import logs and the sqlplus session?

spider_at_zvartnots.am wrote:

> Yes, but not binary, its text information in not english language.
>
> In article <3A81023D.A42F4AFB_at_yahoo.co.uk>,
> gordon_cartwright_at_yahoo.co.uk wrote:
> > 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/
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Feb 08 2001 - 17:27:22 CST