Did you specify the character set option in SQL loader control file?

We are able to load Japanese characters by specifying CHARACTERSET UTF8
in sql loader control file.

So you should be able to load Greek character.

-----Original Message-----
From: AVUDAIAPPAN Palani Kumar
[mailto:oracledba-ezmlmshield-x74996423.[Email address protected]
Sent: Thursday, January 25, 2007 4: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