aspose file tools*
The moose likes JDBC and the fly likes Problem in storing non ascii charaters n oracle 9i Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in storing non ascii charaters n oracle 9i" Watch "Problem in storing non ascii charaters n oracle 9i" New topic
Author

Problem in storing non ascii charaters n oracle 9i

faisal ishaque
Greenhorn

Joined: Feb 21, 2003
Posts: 14
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

Joined: Apr 14, 2004
Posts: 10336

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.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem in storing non ascii charaters n oracle 9i