No announcement yet.

Images in blob field

  • Filter
  • Time
  • Show
Clear All
new posts

  • Images in blob field

    Hi all,

    I'm trying to recover images froma blob field in a SQLite database. Everything works great until Mirth try to generate a XML message with the results of the query. No problem with regular fields (string, integers, etc), but when blob field appears everything crashes because SQLite stored data inblob fields in binary format, and this binary format, of course, is not valid data for an XML.

    At htis point I tried to convert to base64 format from database query but without success. Another time, I try to convert to base64 in preprocessor, but I don't know how to apply the encode functionexplicitly to that field, and not to the entire message.

    Any hints about?, can I apply FileUtil.encode only to the field that contains binary data?

    Thanks for your help,

    Ricard Bernat