RE: problem in GREEK char upload to Data

RE: problem in GREEK char upload to Data

 

  

Kevin

Thanks for your reply, now it is working fine


And moreover I have similar problem..........



We are storing some data in oracle database in Greek language through the application in a case (some times in lower case and some times in upper case).
After that when we try to search through the application that data in the same case the data get searching but when tried in upper case it is not searching.
But for English language it is working fine for any case.
We doubt that there will be some mismatch of character set of Oracle database.



Can you please help over this?


Thanks in advance

Palani

-----Original Message-----
From: Kevin Merrill [mailto:[Email address protected]
Sent: Monday, January 29, 2007 9:47 PM
To: AVUDAIAPPAN Palani Kumar
Subject: RE: problem in GREEK char upload to Data

Hi Apalani, how did you save the data in prepartion for loading? I had a similar issue trying to load Korean data in the past. I saved the data using Excel as type Unicode text and then used SQL Loader to load into the database setting the correct NLS_LANG in my batch file.

How does the data appear when you open your source file before you load it?

I am also wondering if you need to set the Greek NLS_LANG for your app server session so it will display properly through the application.

Kevin

-----Original Message-----
From: AVUDAIAPPAN Palani Kumar [mailto:[Email address protected]
Sent: Sunday, January 28, 2007 10:40 PM
To: Kevin Merrill
Subject: RE: problem in GREEK char upload to Data


Thanks you reply

As per your below mail.

I have set the language is

set NLS_LANG=american_america.EL8ISO8859P7 in windows environment.
Sample code:

echo ************** Processing ListItems File ********************
echo Processing ListItems File - SQLLOADER Task Initiated
set NLS_LANG=AMERICAN_AMERICA.EL8ISO8859P7
sqlldr navbatch/[Email Address Removed] control="D://pala//AGF_CUST.ctl"
log="D://pala//AGF_CUST.log"
echo Processing ListItems File - SQLLOADER Task completed
echo Processing ListItems File - PostLoader Task Initiated
echo Processing ListItems File - PostLoader Task Completed


after loading data into DB. I used SQL developer and try to retrieve data from the particular table ,

Again Greek letters are displayed as ¿¿¿¿¿¿¿

And open my application , it shows ????????


Sample greek data to upload is ˆ—€ŒŒ†‘ ˆ—€ŒŒŽ“ ‘’„ŠŠ€ ‹€‰€‰†‘ €Œ€‚ˆ—’†

Regards
apalani


-----Original Message-----
From: Kevin Merrill [mailto:[Email address protected]
Sent: Friday, January 26, 2007 10:40 PM
To: AVUDAIAPPAN Palani Kumar
Subject: RE: problem in GREEK char upload to Data

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


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
[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

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.

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