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 character set syntax

Re: export character set syntax

From: Jeff B <jbisch1_at_yahoo.com>
Date: Thu, 14 Jun 2007 06:35:49 -0700
Message-ID: <1181828149.628444.176140@x35g2000prf.googlegroups.com>


On Jun 13, 10:11 am, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:
> On Jun 13, 4:45 pm, Jeff B <jbis..._at_yahoo.com> wrote:
>
> > Hello,
>
> > In order to avoid a possible charset conversion during export/import,
> > I want to specify a character set in both my export and import
> > scripts. Could some tell me what the proper syntax would be in order
> > to accomplish this? At this moment, I am using a par file in a
> > windows cmd file.
>
> > I am using Oracle 9.2.0.8 on Windows 2003 Server, 32-bit.
>
> > Thanks in advance,
>
> > Jeff
>
> Put
>
> set NLS_LANG=LANGUAGE_TERRITORY.CHARSET
>
> into your cmd script before exp/imp invocation. Obviously, LANGUAGE,
> TERRITORY and CHARSET should be replaced with correct values,
> especially CHARSET, which should be the same as database charset to
> avoid charset conversion. For example,
>
> set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
>
> will cause the utilities to speak American English, use American date/
> currency/number formats, and iso-8859-p1 charset.
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

Thank you for your help!!! Received on Thu Jun 14 2007 - 08:35:49 CDT

Original text of this message

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