• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Not able to store ukrainian characters in Oracle 10g database

 
shri Beej
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I can able to store ukrainian characters/data into Oracle XE but can not able to store ukrainian characters/data 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.
 
Paul Clapham
Sheriff
Posts: 21554
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
shri Beej
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Paul Clapham
Sheriff
Posts: 21554
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic