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 6 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.