• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle BLOB and UTF-8 Question

 
Milind Mahajan
Ranch Hand
Posts: 77
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 77
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic