This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Oracle BLOB and UTF-8 Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle BLOB and UTF-8 Question" Watch "Oracle BLOB and UTF-8 Question" New topic
Author

Oracle BLOB and UTF-8 Question

Milind Mahajan
Ranch Hand

Joined: Oct 23, 2000
Posts: 77
Hello,

I have a column in database table defined with datatype BLOB. It is used to store large xmls. (After some reading, I understand that CLOB should have been used for this purpose. But can't change that now.) The problems is that when xml contains umlaut characters like - "ÄËÜ", they are deformed in database. I suspect it has something to do with BLOB and UTF-8 compatibility. Any ideas? How do I get around this problem? Any help is appreciated.

Oracle DB Version - 9i
JDBC Driver - Thin, Classes12.jar

Thanks,
-Milind
Milind Mahajan
Ranch Hand

Joined: Oct 23, 2000
Posts: 77
Turns out, the BLOB was not actually deforming the characters. The DB client tool I used to see the blob contents showed them as deformed and lead me to wrong the conclusion. Just thought of letting others know.

Thanks,
-Milind
 
Have you checked out Aspose?
 
subject: Oracle BLOB and UTF-8 Question
 
It's not a secret anymore!