Re: sqlldr and character set

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 11 Jun 2004 13:28:44 +0200
Message-ID: <cac4ot$50h$2@news3.tilbu1.nb.home.nl>

Frank van Bortel wrote:

> 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!
>

Oops.. =AMERICAN_AMERICA.WE8MSWIN1252

-- 

Regards,
Frank van Bortel

Received on Fri Jun 11 2004 - 06:28:44 CDT