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
posted 7 years ago
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.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads