wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android 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
Character decoding in Java
Reading NVarChar2 from Oracle 10g database
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