shri Beej wrote:I can able to store ukrainian characters/data into Oracle XE but can not able to store ukrainian characters/data into Oracle 10g.
So you can't store Ukrainian characters into Oracle 10g.
Data type used to store data is NCHAR.
In Oracle XE : NLS_CHARACTERSET = AL32UTF8; NCHAR_CHARACTERSET=AL16UTF16
In Oracle 10g : NLS_CHARACTERSET = WE8ISO8859P1; NCHAR_CHARACTERSET=AL16UTF16
Then i tried to insert values( ukrainian characters/data ) in the Oracle 10g using scriptlet, values are properly stored in the database.
So i think NLS_CHARACTERSET is not the issue.
So you can store Ukrainian characters into Oracle 10g.
Which of those two statements is true?
Assuming the first one is true (otherwise you wouldn't have a problem), that's almost certainly because WE8ISO8859P1 is a Western European charset which doesn't support Ukrainian characters.
Joined: Feb 21, 2011
I can able to store ukrainian characters/data into Oracle XE through java web application.
When same web application try to store ukrainian characters/data into Oracle 10g, garbage data is getting stored.
That's i written sample jsp with java code written into scriptlet to store ukrainin characer into Oracle 10g.
And it is found that ukrainian characters/data is stored into Oracle 10g without changing changing its charset.
Okay. I give up. You can't even tell me whether you have a problem or not, and if you do, you can't tell me what it is. And you don't answer the questions I ask. So good luck with your problem, if you have one.
subject: Not able to store ukrainian characters in Oracle 10g database