Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: export character set syntax
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