Nidheesh Krishna wrote:is there any significance in characterset of database?
Yes! However, the client also has a character set. SQLPlus may show funny characters, and ought to be set, whether in Windows or Linux. SQL Developer should not require the setting.
Before we go any further, please verify what was inserted. Use SQL Developer and query the datum, and post here what you find.
Nidheesh Krishna wrote:by using SQL developer, insert query works correctly. But, through java codes, problems again arises
I want to be clear, because this is very important. Are you saying that when INSERTing and SELECTing via SQL Developer, you see the correct character? If so, the database character set supports the character and needs no changing.
Please answer that, and then 2 more questions:
1) If you INSERT via SQL Developer, but SELECT in java, what character is shown?
2) If you INSERT via java , but SELECT in SQL Developer, what character is shown?
Nidheesh Krishna wrote:when INSERTing and SELECTing via SQL Developer, i got the correct character
Okay, so it's Java. Now let's do one more test, but i hope someone else can help, because this is not my expertise.
1) How are you displaying the results? A web page?
2) If you log the results, showing them either in a debug window or in a file, which character shows?
(On an unrelated note, I don't think "Umstünde" is a word in German. "Umstände" is, as would be "umstünde", although the latter would be old-fashioned.)
Nidheesh Krishna wrote:1) i used a simple java console program
Thank you. I do not know the answer. Hopefully one of the java experts here can answer.
Note please, this is not an Oracle issue. This is simply an issue with the program displaying foreign characters. That much we have established, and simplifies the question.
It could be the character set you have read from (eg a file or database), it could be the character set you have written to (a database or command line or file).
in this case you have to double that, as you have written to a db and are then reading from it and displaying it.
So, when you INSERT that word into the DB via Java and then look at it in the DB using SQL Developer does it look correct?
Then you need to check whether it is read out correctly, which would require writing it to some reliable output, and a File in the correct character set would be the best bet...but be sure to open it in a viewer that can handle that character set.