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: sqlldr and character set

Re: sqlldr and character set

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 11 Jun 2004 13:13:29 +0200
Message-ID: <cac3sa$kr$1@news3.tilbu1.nb.home.nl>


COAST wrote:
> Hi NG
>
> how can I change the character set from "PC DOS" to e.g. WE8MSWIN1252
> importing datas using sglldr.
>
> Thanks
> Peter

C:> set nls_lang=AMERICAN_AMERICA.WE8ISO8859P1 C:> sqlldr .....

Permanent (well... more permanent) changes are made in the registry, using regedt32. Be careful; if you're not familiar with the registry, don't attempt this at home!

-- 

Regards,
Frank van Bortel
Received on Fri Jun 11 2004 - 06:13:29 CDT

Original text of this message

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