Antw: Re: sqlldr and character set

From: COAST <coast_at_cedes.com>
Date: Fri, 11 Jun 2004 15:58:18 +0200
Message-ID: <40c9ba7c$0$19650$4d4ef98e@read.news.ch.uu.net>

Hi Frank

thanks for your hint.

set nls_lang=GERMAN_GERMANY.WE8PC850
is working for me.

My Source is PC-DOS and the db is set nls_lang=GERMAN_GERMANY.WE8ISO8859P1

Peter

>>> Frank van Bortel<fvanbortel_at_netscape.net> 11.06.2004 13:13:29 >>>

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 - 08:58:18 CDT