problem in GREEK char upload to Data

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




Oracle LazyDBA home page