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.