aspose file tools*
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 Java 8 in Action this week in the Java 8 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
Data size bigger than the max size for this type;
Character decoding in Java
Reading NVarChar2 from Oracle 10g database
String, UTF-8, Unicode and DB
Oracle function using Java to return Blob is zero size