Re: SQL-Loader & International Languages Problem

From: Anil Kamath <akk_16_at_yahoo.com>
Date: Sat, 25 Sep 1999 07:54:07 GMT
Message-ID: <7shv2t$gui$1@nnrp1.deja.com>

Set it and it worked ..thanks.

-anil

In article <938108239.5214.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> Did you set the environment variable NLS_LANG?
> (mimimum to American_America.WE8ISO8859P1)
>
> Hth,
> --
> Sybrand Bakker, Oracle DBA
> <akk_16_at_yahoo.com> wrote in message

news:7sdn64$fbu$1_at_nnrp1.deja.com...
> > Hi,
> >
> > I have an interesting situation. I am using SQL Loader
> > to load a bunch of records in french from a text file
> > into database tables. My 8.0.5 Database is created using the
> > WE8ISO8859P1 charcter set which supports western european
> > languages. The instance is running on a Sun Solaris 2.6
> > OS.
> >
> > The problem is that when I do the load the special characters
> > vanish from the loaded data. I specify the same character
> > set in my SQL Loader control file also but the special
> > characters still vanish...I know my Solaris box supports the
> > character set bcos when I do a cat on the text file I see the
> > special characters.
> >
> > Any suggestions will be appreciated. Has anyone encountered
> > the problem before while loading French,Spanish or German
> > data into the Oracle database.
> >
> > thx,
> > -anil
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
>

--
Anil Kamath
SmartOnline Inc. (www.smartonline.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Sep 25 1999 - 02:54:07 CDT