In your sql loader script, include the follwoing line:

export NLS_LANG=<territory>.<character set>

Kevin

-----Original Message-----
From: AVUDAIAPPAN Palani Kumar
[mailto:oracledba-ezmlmshield-x74996423.[Email address protected]
Sent: Thursday, January 25, 2007 3:01 AM
To: LazyDBA Discussion
Subject: problem in GREEK char upload to Data


HI



I am facing a problem with Greek character set. I have one flat file
(contains data from mainframe) and I am using SQL Loader command to Read
the flat file and insert into Oracle DB table.



This process is executed in Solaris Environment using script.



The problem is Flat file contains GREEK letters. After Insertion, only
the Greek letters are stored as Junk/unreadable form (like
this??????????).



I have confirmed with oracle side, the character set for character field
is UTF-8 and NationalCharacter Field is UTF-8 and the flat file
character set is ISO8859-7 (GREEK) at solaris side.

Still I am getting wrong format.



Please help me on this issue ...



Regards

palani





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page