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: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Wed, 13 Jun 2007 14:11:52 -0000
Message-ID: <1181743912.898507.38340@e26g2000pro.googlegroups.com>


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 Received on Wed Jun 13 2007 - 09:11:52 CDT

Original text of this message

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