You need to make sure you set the character set for the data in the file you are loading. If it is Greek, you should use a Greek character set. After you get the data loaded, try setting your NLS_LANG to american_america.UTF8 on the client to see if the characters are displaying correctly. If the database supports multi-byte characters, which UTF8 does, the characters should display correctly.
If your sql loader control file is on the unix file system, you would use:
export NLS_LANG=american_america.EL8ISO8859P7
or
setenv NLS_LANG=american_america.EL8ISO8859P7
If it is on the windows system, you would use:
set NLS_LANG=american_america.EL8ISO8859P7
Kevin
-----Original Message-----
From: AVUDAIAPPAN Palani Kumar
[mailto:oracledba-ezmlmshield-x69111290.[Email address protected]
Sent: Thursday, January 25, 2007 10:53 PM
To: LazyDBA Discussion
Subject: RE: problem in GREEK char upload to Data
Hi thanks for your Reply
But still I am getting wrong format of Greek letters.
Actually my client application and Oracle server both are running on windows XP. Thru sql loader , I am uploading the flat file to Oracle database. In oracle Data base character set is UFT8 and National Character set is AL16UTF16.
In my local (client)env , current NLS_Lang is AMERICAN_AMERICA.WE8ISO8859P1. Flat file contains Greek letters which are stored in to the table ,After insertion I am executing the selection query in SQL prompt , I got the following result
żżżżżżż żżżżżżż żżżżżżż
But the same result in application page , I am getting ?????????????? .
How to set the character set for GREEK in windows environment Or Unix Solaris Environment. Please provide the correct steps to solve this issue
Thanks and Regards
Palani
-----Original Message-----
From: Kevin Merrill [mailto:oracledba-ezmlmshield-x54531273.[Email address protected]
Sent: Friday, January 26, 2007 1:16 AM
To: LazyDBA Discussion
Subject: RE: problem in GREEK char upload to Data
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
---------------------------------------------------------------------
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
This E-Mail is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure. If the reader of this document is not the intended recipient or an employee or agent responsible for delivering this document to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this document is strictly prohibited. If you have received this document in error, please delete it. Thank you.
---------------------------------------------------------------------
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