This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle BLOB and UTF-8 Question
 
Similar Threads
Oracle function using Java to return Blob is zero size
Data size bigger than the max size for this type;
String, UTF-8, Unicode and DB
Reading NVarChar2 from Oracle 10g database
Character decoding in Java