aspose file tools*
The moose likes JDBC and the fly likes Not able to store ukrainian characters in Oracle 10g database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Not able to store ukrainian characters in Oracle 10g database" Watch "Not able to store ukrainian characters in Oracle 10g database" New topic
Author

Not able to store ukrainian characters in Oracle 10g database

shri Beej
Greenhorn

Joined: Feb 21, 2011
Posts: 2
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
Bartender

Joined: Oct 14, 2005
Posts: 18120
    
    8

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

Joined: Feb 21, 2011
Posts: 2
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
Bartender

Joined: Oct 14, 2005
Posts: 18120
    
    8

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Not able to store ukrainian characters in Oracle 10g database
 
Similar Threads
Special characters converts to ? in Oracle 10g databse
i18n
Sample Data for Tables in Oracle 10g XE
Difference between Oracle 10g Express Edition & Other editions
java.sql.SQLException: Io exception: The Network Adapter could not establish the conn