• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Not able to store ukrainian characters in Oracle 10g database

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic