• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Convert XML data stored in a BLOB column in database back to XML format

 
Ramya Teja
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

XML data is being stored in an BLOB column in database.
I want to convert the BLOB data back to XML data.
Please tell me how to do this using JDBC code.

Thanks
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34669
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
XML is character data and should be stored in a CLOB. BLOBs are for binary data and it doesn't make sense for XML.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic