Re: Import/Export server character set????

Steve is right on the money. Listen to him.

Michael

• Original Message ----- From: "Steve Orr" <sorr_at_arzoo.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, June 09, 2000 3:30 PM Subject: RE: Import/Export server character set????

> You need to set the NLS_LANG environment variable. Example:
> NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
>
> See the "Character Set Conversion" section in the import manual and the
> export manual.
> Here's a clip from the manual:
> Export writes export files using the character set specified in the
NLS_LANG
> environment variable for the user session. A character set conversion is
> performed if the value of NLS_LANG differs from the database character
set.
>
> Steve Orr
>
>
>
>
> > -----Original Message-----
> > From: Geeta Iyer [mailto:geeta.iyer_at_sprintparanet.com]
> > Sent: Friday, June 09, 2000 9:57 AM
> > To: Oracle List_at_Fatcity; Oracle LazyDba
> > Subject: Import/Export server character set????
> >
> >
> > Hello all,
> >
> > I have inherited a database with default character set and default nls
> > character set of US7ASCII
> > Yet, when I do any export/import from/to the database.. it converts the
> > character set
> >
> > Export done in US7ASCII character set and US7ASCII NCHAR character set
> > server uses WE8ISO8859P1 character set (possible charset conversion)
> >
> > import done in US7ASCII character set and US7ASCII NCHAR character set
> > import server uses WE8ISO8859P1 character set (possible charset
> > conversion)
> >
> > and this may be obvious, but I cannot see it.. anyone tell me why the
> > above is happening!!
> >
> >
> >
> > Geeta Iyer
> > Sprint Enterprise Network Services
> > Work: (303)220-4788
> > Pager: 800-724-3508
> > E-Mail: Geeta.Iyer_at_SprintParanet.com
Received on Fri Jun 09 2000 - 22:30:15 CDT