RE: problem in GREEK char upload to Data

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.

Oracle LazyDBA home page