Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in storing non ascii charaters n oracle 9i

 
faisal ishaque
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have successfully get and display arabic and russian charaters from JSP with UTF-8 charset setting, but i am facing problem while storing the non ascii charaters on oracle using JDBC.
When i insert the record and fetched it from sql plus then garbage charaters were returned.

Kindly help me in this regard on urgent basis.

regards
Faisal
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is you database configured to support unicode? If you redisplay the data on you JSP does it look OK? If it does, SQLPlus is the problem, not your database.

Does SQL Plus support the character set yuo are trying to display? My guess is no. I'd have a hunt around Oracle's site - see if you can find a version that support Russian.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic