Meaningless Drivel is fun!*
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
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
 
Similar Threads
How to avoid special charcters from a file
Polish characters are gets changed to ? in websphere6.1 environment
Issue in character encoding....
Issue in character encoding
Non english characters